LYZHGD_3.0/还原代码/DAL/T_Members.cs

using DBUtility;
using JAnCallCenter.Model;
using System;
using System.Data;
using Oracle.ManagedDataAccess.Client;
using System.Text;

namespace JAnCallCenter.DAL
{
	public class T_Members
	{
		public bool Exists(decimal CLIENTID)
		{
			StringBuilder strSql = new StringBuilder();
			strSql.Append("select count(1) from T_MEMBERS");
			strSql.Append(" where CLIENTID=:CLIENTID ");
			OracleParameter[] parameters = new OracleParameter[]
			{
				new OracleParameter(":CLIENTID", OracleDbType.Int32, 4)
			};
			parameters[0].Value = CLIENTID;
			return DbHelperOra.Exists(strSql.ToString(), parameters);
		}

		public bool Add(Model.T_Members model)
		{
			StringBuilder strSql = new StringBuilder();
			strSql.Append("insert into T_MEMBERS(");
			strSql.Append("CLIENTID,CUSCODE,CUSNAME,CUSADD,CUSBOX,CUSZIP,CUSTEL,CUSCABLE,CUSFAX,CUSURL,CUSEMAIL,CUSCC,CUSPNAME,CUSBANKACNT,CUSBANK,CUSTAXES,CUSUNITMODE,CUSPROVN,CUSAREA,CUSTOTCASH,CUSDEBT,CUSCNTCOUNT,CUSTRADE,CUSBUSINESS,CORSCAL,YEARVALUE,YEARPROFIT,RCVSTATION,CUSREGION,DELTYPE,FPNAME,FPADD,SALMAN,HASSALMAN,FREIGHTMODE,ORDERDESC,FPDESC,CREATEDATE,DELIVEDESC,SENDADD,LIMITMONEY,INCPOSTDESC,CUSSIGN,AREA,SALENO,NATION,LAND,DELIPLANNER,CUSCANCEL,CUSABNAME,IMPSIGN,ZXBH,CUSSERVICER,SOURCETYPE)");
			strSql.Append(" values (");
			strSql.Append("s_t_members.nextval,s_t_members.currval,:CUSNAME,:CUSADD,:CUSBOX,:CUSZIP,:CUSTEL,:CUSCABLE,:CUSFAX,:CUSURL,:CUSEMAIL,:CUSCC,:CUSPNAME,:CUSBANKACNT,:CUSBANK,:CUSTAXES,:CUSUNITMODE,:CUSPROVN,:CUSAREA,:CUSTOTCASH,:CUSDEBT,:CUSCNTCOUNT,:CUSTRADE,:CUSBUSINESS,:CORSCAL,:YEARVALUE,:YEARPROFIT,:RCVSTATION,:CUSREGION,:DELTYPE,:FPNAME,:FPADD,:SALMAN,:HASSALMAN,:FREIGHTMODE,:ORDERDESC,:FPDESC,:CREATEDATE,:DELIVEDESC,:SENDADD,:LIMITMONEY,:INCPOSTDESC,:CUSSIGN,:AREA,:SALENO,:NATION,:LAND,:DELIPLANNER,:CUSCANCEL,:CUSABNAME,:IMPSIGN,:ZXBH,:CUSSERVICER,:SOURCETYPE)");
			OracleParameter[] parameters = new OracleParameter[]
			{
				new OracleParameter(":CUSNAME", OracleDbType.Varchar2, 60),
				new OracleParameter(":CUSADD", OracleDbType.Varchar2, 100),
				new OracleParameter(":CUSBOX", OracleDbType.Varchar2, 100),
				new OracleParameter(":CUSZIP", OracleDbType.Varchar2, 6),
				new OracleParameter(":CUSTEL", OracleDbType.Varchar2, 30),
				new OracleParameter(":CUSCABLE", OracleDbType.Varchar2, 30),
				new OracleParameter(":CUSFAX", OracleDbType.Varchar2, 500),
				new OracleParameter(":CUSURL", OracleDbType.Varchar2, 30),
				new OracleParameter(":CUSEMAIL", OracleDbType.Varchar2, 30),
				new OracleParameter(":CUSCC", OracleDbType.Varchar2, 1),
				new OracleParameter(":CUSPNAME", OracleDbType.Varchar2, 30),
				new OracleParameter(":CUSBANKACNT", OracleDbType.Varchar2, 30),
				new OracleParameter(":CUSBANK", OracleDbType.Varchar2, 60),
				new OracleParameter(":CUSTAXES", OracleDbType.Varchar2, 30),
				new OracleParameter(":CUSUNITMODE", OracleDbType.Varchar2, 1),
				new OracleParameter(":CUSPROVN", OracleDbType.Varchar2, 16),
				new OracleParameter(":CUSAREA", OracleDbType.Varchar2, 16),
				new OracleParameter(":CUSTOTCASH", OracleDbType.Int32, 21),
				new OracleParameter(":CUSDEBT", OracleDbType.Int32, 21),
				new OracleParameter(":CUSCNTCOUNT", OracleDbType.Int32, 6),
				new OracleParameter(":CUSTRADE", OracleDbType.Varchar2, 32),
				new OracleParameter(":CUSBUSINESS", OracleDbType.Varchar2, 500),
				new OracleParameter(":CORSCAL", OracleDbType.Int32, 10),
				new OracleParameter(":YEARVALUE", OracleDbType.Int32, 20),
				new OracleParameter(":YEARPROFIT", OracleDbType.Int32, 20),
				new OracleParameter(":RCVSTATION", OracleDbType.Varchar2, 30),
				new OracleParameter(":CUSREGION", OracleDbType.Varchar2, 16),
				new OracleParameter(":DELTYPE", OracleDbType.Varchar2, 1),
				new OracleParameter(":FPNAME", OracleDbType.Varchar2, 100),
				new OracleParameter(":FPADD", OracleDbType.Varchar2, 100),
				new OracleParameter(":SALMAN", OracleDbType.Varchar2, 16),
				new OracleParameter(":HASSALMAN", OracleDbType.Varchar2, 1),
				new OracleParameter(":FREIGHTMODE", OracleDbType.Varchar2, 1),
				new OracleParameter(":ORDERDESC", OracleDbType.Varchar2, 1000),
				new OracleParameter(":FPDESC", OracleDbType.Varchar2, 1000),
				new OracleParameter(":CREATEDATE", OracleDbType.Date),
				new OracleParameter(":DELIVEDESC", OracleDbType.Varchar2, 1000),
				new OracleParameter(":SENDADD", OracleDbType.Varchar2, 100),
				new OracleParameter(":LIMITMONEY", OracleDbType.Int32, 21),
				new OracleParameter(":INCPOSTDESC", OracleDbType.Varchar2, 1000),
				new OracleParameter(":CUSSIGN", OracleDbType.Varchar2, 1),
				new OracleParameter(":AREA", OracleDbType.Varchar2, 24),
				new OracleParameter(":SALENO", OracleDbType.Varchar2, 3),
				new OracleParameter(":NATION", OracleDbType.Varchar2, 32),
				new OracleParameter(":LAND", OracleDbType.Varchar2, 32),
				new OracleParameter(":DELIPLANNER", OracleDbType.Varchar2, 30),
				new OracleParameter(":CUSCANCEL", OracleDbType.Varchar2, 1),
				new OracleParameter(":CUSABNAME", OracleDbType.Varchar2, 60),
				new OracleParameter(":IMPSIGN", OracleDbType.Varchar2, 1),
				new OracleParameter(":ZXBH", OracleDbType.Int32, 4),
				new OracleParameter(":CUSSERVICER", OracleDbType.Varchar2, 20),
				new OracleParameter(":SOURCETYPE", OracleDbType.Int32, 4)
			};
			parameters[0].Value = model.CUSNAME;
			parameters[1].Value = model.CUSADD;
			parameters[2].Value = model.CUSBOX;
			parameters[3].Value = model.CUSZIP;
			parameters[4].Value = model.CUSTEL;
			parameters[5].Value = model.CUSCABLE;
			parameters[6].Value = model.CUSFAX;
			parameters[7].Value = model.CUSURL;
			parameters[8].Value = model.CUSEMAIL;
			parameters[9].Value = model.CUSCC;
			parameters[10].Value = model.CUSPNAME;
			parameters[11].Value = model.CUSBANKACNT;
			parameters[12].Value = model.CUSBANK;
			parameters[13].Value = model.CUSTAXES;
			parameters[14].Value = model.CUSUNITMODE;
			parameters[15].Value = model.CUSPROVN;
			parameters[16].Value = model.CUSAREA;
			parameters[17].Value = model.CUSTOTCASH;
			parameters[18].Value = model.CUSDEBT;
			parameters[19].Value = model.CUSCNTCOUNT;
			parameters[20].Value = model.CUSTRADE;
			parameters[21].Value = model.CUSBUSINESS;
			parameters[22].Value = model.CORSCAL;
			parameters[23].Value = model.YEARVALUE;
			parameters[24].Value = model.YEARPROFIT;
			parameters[25].Value = model.RCVSTATION;
			parameters[26].Value = model.CUSREGION;
			parameters[27].Value = model.DELTYPE;
			parameters[28].Value = model.FPNAME;
			parameters[29].Value = model.FPADD;
			parameters[30].Value = model.SALMAN;
			parameters[31].Value = model.HASSALMAN;
			parameters[32].Value = model.FREIGHTMODE;
			parameters[33].Value = model.ORDERDESC;
			parameters[34].Value = model.FPDESC;
			parameters[35].Value = model.CREATEDATE;
			parameters[36].Value = model.DELIVEDESC;
			parameters[37].Value = model.SENDADD;
			parameters[38].Value = model.LIMITMONEY;
			parameters[39].Value = model.INCPOSTDESC;
			parameters[40].Value = model.CUSSIGN;
			parameters[41].Value = model.AREA;
			parameters[42].Value = model.SALENO;
			parameters[43].Value = model.NATION;
			parameters[44].Value = model.LAND;
			parameters[45].Value = model.DELIPLANNER;
			parameters[46].Value = "1";
			parameters[47].Value = model.CUSABNAME;
			parameters[48].Value = model.IMPSIGN;
			parameters[49].Value = model.ZXBH;
			parameters[50].Value = model.CUSSERVICER;
			parameters[51].Value = 2;
			int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
			return rows > 0;
		}

		public bool Update(Model.T_Members model)
		{
			StringBuilder strSql = new StringBuilder();
			strSql.Append("update T_MEMBERS set ");
			strSql.Append("CUSCODE=:CUSCODE,");
			strSql.Append("CUSNAME=:CUSNAME,");
			strSql.Append("CUSADD=:CUSADD,");
			strSql.Append("CUSBOX=:CUSBOX,");
			strSql.Append("CUSZIP=:CUSZIP,");
			strSql.Append("CUSTEL=:CUSTEL,");
			strSql.Append("CUSCABLE=:CUSCABLE,");
			strSql.Append("CUSFAX=:CUSFAX,");
			strSql.Append("CUSURL=:CUSURL,");
			strSql.Append("CUSEMAIL=:CUSEMAIL,");
			strSql.Append("CUSCC=:CUSCC,");
			strSql.Append("CUSPNAME=:CUSPNAME,");
			strSql.Append("CUSBANKACNT=:CUSBANKACNT,");
			strSql.Append("CUSBANK=:CUSBANK,");
			strSql.Append("CUSTAXES=:CUSTAXES,");
			strSql.Append("CUSUNITMODE=:CUSUNITMODE,");
			strSql.Append("CUSPROVN=:CUSPROVN,");
			strSql.Append("CUSAREA=:CUSAREA,");
			strSql.Append("CUSTOTCASH=:CUSTOTCASH,");
			strSql.Append("CUSDEBT=:CUSDEBT,");
			strSql.Append("CUSCNTCOUNT=:CUSCNTCOUNT,");
			strSql.Append("CUSTRADE=:CUSTRADE,");
			strSql.Append("CUSBUSINESS=:CUSBUSINESS,");
			strSql.Append("CORSCAL=:CORSCAL,");
			strSql.Append("YEARVALUE=:YEARVALUE,");
			strSql.Append("YEARPROFIT=:YEARPROFIT,");
			strSql.Append("RCVSTATION=:RCVSTATION,");
			strSql.Append("CUSREGION=:CUSREGION,");
			strSql.Append("DELTYPE=:DELTYPE,");
			strSql.Append("FPNAME=:FPNAME,");
			strSql.Append("FPADD=:FPADD,");
			strSql.Append("SALMAN=:SALMAN,");
			strSql.Append("HASSALMAN=:HASSALMAN,");
			strSql.Append("FREIGHTMODE=:FREIGHTMODE,");
			strSql.Append("ORDERDESC=:ORDERDESC,");
			strSql.Append("FPDESC=:FPDESC,");
			strSql.Append("CREATEDATE=:CREATEDATE,");
			strSql.Append("DELIVEDESC=:DELIVEDESC,");
			strSql.Append("SENDADD=:SENDADD,");
			strSql.Append("LIMITMONEY=:LIMITMONEY,");
			strSql.Append("INCPOSTDESC=:INCPOSTDESC,");
			strSql.Append("CUSSIGN=:CUSSIGN,");
			strSql.Append("AREA=:AREA,");
			strSql.Append("SALENO=:SALENO,");
			strSql.Append("NATION=:NATION,");
			strSql.Append("LAND=:LAND,");
			strSql.Append("DELIPLANNER=:DELIPLANNER,");
			strSql.Append("CUSCANCEL=:CUSCANCEL,");
			strSql.Append("CUSABNAME=:CUSABNAME,");
			strSql.Append("IMPSIGN=:IMPSIGN,");
			strSql.Append("ZXBH=:ZXBH,");
			strSql.Append("CUSSERVICER=:CUSSERVICER,");
			strSql.Append("SOURCETYPE=:SOURCETYPE");
			strSql.Append(" where CLIENTID=:CLIENTID ");
			OracleParameter[] parameters = new OracleParameter[]
			{
				new OracleParameter(":CUSCODE", OracleDbType.Varchar2, 16),
				new OracleParameter(":CUSNAME", OracleDbType.Varchar2, 60),
				new OracleParameter(":CUSADD", OracleDbType.Varchar2, 100),
				new OracleParameter(":CUSBOX", OracleDbType.Varchar2, 100),
				new OracleParameter(":CUSZIP", OracleDbType.Varchar2, 6),
				new OracleParameter(":CUSTEL", OracleDbType.Varchar2, 30),
				new OracleParameter(":CUSCABLE", OracleDbType.Varchar2, 30),
				new OracleParameter(":CUSFAX", OracleDbType.Varchar2, 500),
				new OracleParameter(":CUSURL", OracleDbType.Varchar2, 30),
				new OracleParameter(":CUSEMAIL", OracleDbType.Varchar2, 30),
				new OracleParameter(":CUSCC", OracleDbType.Varchar2, 1),
				new OracleParameter(":CUSPNAME", OracleDbType.Varchar2, 30),
				new OracleParameter(":CUSBANKACNT", OracleDbType.Varchar2, 30),
				new OracleParameter(":CUSBANK", OracleDbType.Varchar2, 60),
				new OracleParameter(":CUSTAXES", OracleDbType.Varchar2, 30),
				new OracleParameter(":CUSUNITMODE", OracleDbType.Varchar2, 1),
				new OracleParameter(":CUSPROVN", OracleDbType.Varchar2, 16),
				new OracleParameter(":CUSAREA", OracleDbType.Varchar2, 16),
				new OracleParameter(":CUSTOTCASH", OracleDbType.Int32, 21),
				new OracleParameter(":CUSDEBT", OracleDbType.Int32, 21),
				new OracleParameter(":CUSCNTCOUNT", OracleDbType.Int32, 6),
				new OracleParameter(":CUSTRADE", OracleDbType.Varchar2, 32),
				new OracleParameter(":CUSBUSINESS", OracleDbType.Varchar2, 500),
				new OracleParameter(":CORSCAL", OracleDbType.Int32, 10),
				new OracleParameter(":YEARVALUE", OracleDbType.Int32, 20),
				new OracleParameter(":YEARPROFIT", OracleDbType.Int32, 20),
				new OracleParameter(":RCVSTATION", OracleDbType.Varchar2, 30),
				new OracleParameter(":CUSREGION", OracleDbType.Varchar2, 16),
				new OracleParameter(":DELTYPE", OracleDbType.Varchar2, 1),
				new OracleParameter(":FPNAME", OracleDbType.Varchar2, 100),
				new OracleParameter(":FPADD", OracleDbType.Varchar2, 100),
				new OracleParameter(":SALMAN", OracleDbType.Varchar2, 16),
				new OracleParameter(":HASSALMAN", OracleDbType.Varchar2, 1),
				new OracleParameter(":FREIGHTMODE", OracleDbType.Varchar2, 1),
				new OracleParameter(":ORDERDESC", OracleDbType.Varchar2, 1000),
				new OracleParameter(":FPDESC", OracleDbType.Varchar2, 1000),
				new OracleParameter(":CREATEDATE", OracleDbType.Date),
				new OracleParameter(":DELIVEDESC", OracleDbType.Varchar2, 1000),
				new OracleParameter(":SENDADD", OracleDbType.Varchar2, 100),
				new OracleParameter(":LIMITMONEY", OracleDbType.Int32, 21),
				new OracleParameter(":INCPOSTDESC", OracleDbType.Varchar2, 1000),
				new OracleParameter(":CUSSIGN", OracleDbType.Varchar2, 1),
				new OracleParameter(":AREA", OracleDbType.Varchar2, 24),
				new OracleParameter(":SALENO", OracleDbType.Varchar2, 3),
				new OracleParameter(":NATION", OracleDbType.Varchar2, 32),
				new OracleParameter(":LAND", OracleDbType.Varchar2, 32),
				new OracleParameter(":DELIPLANNER", OracleDbType.Varchar2, 30),
				new OracleParameter(":CUSCANCEL", OracleDbType.Varchar2, 1),
				new OracleParameter(":CUSABNAME", OracleDbType.Varchar2, 60),
				new OracleParameter(":IMPSIGN", OracleDbType.Varchar2, 1),
				new OracleParameter(":ZXBH", OracleDbType.Int32, 4),
				new OracleParameter(":CUSSERVICER", OracleDbType.Varchar2, 20),
				new OracleParameter(":SOURCETYPE", OracleDbType.Int32, 4),
				new OracleParameter(":CLIENTID", OracleDbType.Int32, 4)
			};
			parameters[0].Value = model.CUSCODE;
			parameters[1].Value = model.CUSNAME;
			parameters[2].Value = model.CUSADD;
			parameters[3].Value = model.CUSBOX;
			parameters[4].Value = model.CUSZIP;
			parameters[5].Value = model.CUSTEL;
			parameters[6].Value = model.CUSCABLE;
			parameters[7].Value = model.CUSFAX;
			parameters[8].Value = model.CUSURL;
			parameters[9].Value = model.CUSEMAIL;
			parameters[10].Value = model.CUSCC;
			parameters[11].Value = model.CUSPNAME;
			parameters[12].Value = model.CUSBANKACNT;
			parameters[13].Value = model.CUSBANK;
			parameters[14].Value = model.CUSTAXES;
			parameters[15].Value = model.CUSUNITMODE;
			parameters[16].Value = model.CUSPROVN;
			parameters[17].Value = model.CUSAREA;
			parameters[18].Value = model.CUSTOTCASH;
			parameters[19].Value = model.CUSDEBT;
			parameters[20].Value = model.CUSCNTCOUNT;
			parameters[21].Value = model.CUSTRADE;
			parameters[22].Value = model.CUSBUSINESS;
			parameters[23].Value = model.CORSCAL;
			parameters[24].Value = model.YEARVALUE;
			parameters[25].Value = model.YEARPROFIT;
			parameters[26].Value = model.RCVSTATION;
			parameters[27].Value = model.CUSREGION;
			parameters[28].Value = model.DELTYPE;
			parameters[29].Value = model.FPNAME;
			parameters[30].Value = model.FPADD;
			parameters[31].Value = model.SALMAN;
			parameters[32].Value = model.HASSALMAN;
			parameters[33].Value = model.FREIGHTMODE;
			parameters[34].Value = model.ORDERDESC;
			parameters[35].Value = model.FPDESC;
			parameters[36].Value = model.CREATEDATE;
			parameters[37].Value = model.DELIVEDESC;
			parameters[38].Value = model.SENDADD;
			parameters[39].Value = model.LIMITMONEY;
			parameters[40].Value = model.INCPOSTDESC;
			parameters[41].Value = model.CUSSIGN;
			parameters[42].Value = model.AREA;
			parameters[43].Value = model.SALENO;
			parameters[44].Value = model.NATION;
			parameters[45].Value = model.LAND;
			parameters[46].Value = model.DELIPLANNER;
			parameters[47].Value = model.CUSCANCEL;
			parameters[48].Value = model.CUSABNAME;
			parameters[49].Value = model.IMPSIGN;
			parameters[50].Value = model.ZXBH;
			parameters[51].Value = model.CUSSERVICER;
			parameters[52].Value = model.SOURCETYPE;
			parameters[53].Value = model.CLIENTID;
			int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
			return rows > 0;
		}

		public bool Delete(decimal CLIENTID)
		{
			StringBuilder strSql = new StringBuilder();
			strSql.Append("delete from T_MEMBERS ");
			strSql.Append(" where CLIENTID=:CLIENTID ");
			OracleParameter[] parameters = new OracleParameter[]
			{
				new OracleParameter(":CLIENTID", OracleDbType.Int32, 4)
			};
			parameters[0].Value = CLIENTID;
			int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
			return rows > 0;
		}

		public bool DeleteList(string CLIENTIDlist)
		{
			DbHelperOra.ExecuteSql("delete from T_CONTACT where CUSCODE in (select CUSCODE from T_MEMBERS where CLIENTID in (" + CLIENTIDlist + ") and  SOURCETYPE=2)");
			StringBuilder strSql = new StringBuilder();
			strSql.Append("delete from T_MEMBERS ");
			strSql.Append(" where CLIENTID in (" + CLIENTIDlist + ") and  SOURCETYPE=2");
			int rows = DbHelperOra.ExecuteSql(strSql.ToString());
			return rows > 0;
		}

		public Model.T_Members GetModel(decimal CLIENTID)
		{
			StringBuilder strSql = new StringBuilder();
			strSql.Append("select CLIENTID,CUSCODE,CUSNAME,CUSADD,CUSBOX,CUSZIP,CUSTEL,CUSCABLE,CUSFAX,CUSURL,CUSEMAIL,CUSCC,CUSPNAME,CUSBANKACNT,CUSBANK,CUSTAXES,CUSUNITMODE,CUSPROVN,CUSAREA,CUSTOTCASH,CUSDEBT,CUSCNTCOUNT,CUSTRADE,CUSBUSINESS,CORSCAL,YEARVALUE,YEARPROFIT,RCVSTATION,CUSREGION,DELTYPE,FPNAME,FPADD,SALMAN,HASSALMAN,FREIGHTMODE,ORDERDESC,FPDESC,CREATEDATE,DELIVEDESC,SENDADD,LIMITMONEY,INCPOSTDESC,CUSSIGN,AREA,SALENO,NATION,LAND,DELIPLANNER,CUSCANCEL,CUSABNAME,IMPSIGN,ZXBH,CUSSERVICER,SOURCETYPE from T_MEMBERS ");
			strSql.Append(" where CLIENTID=:CLIENTID ");
			OracleParameter[] parameters = new OracleParameter[]
			{
				new OracleParameter(":CLIENTID", OracleDbType.Int32, 4)
			};
			parameters[0].Value = CLIENTID;
            Model.T_Members model = new Model.T_Members();
			DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
            Model.T_Members result;
			if (ds.Tables[0].Rows.Count > 0)
			{
				if (ds.Tables[0].Rows[0]["CLIENTID"] != null && ds.Tables[0].Rows[0]["CLIENTID"].ToString() != "")
				{
					model.CLIENTID = decimal.Parse(ds.Tables[0].Rows[0]["CLIENTID"].ToString());
				}
				if (ds.Tables[0].Rows[0]["CUSCODE"] != null && ds.Tables[0].Rows[0]["CUSCODE"].ToString() != "")
				{
					model.CUSCODE = ds.Tables[0].Rows[0]["CUSCODE"].ToString();
				}
				if (ds.Tables[0].Rows[0]["CUSNAME"] != null && ds.Tables[0].Rows[0]["CUSNAME"].ToString() != "")
				{
					model.CUSNAME = ds.Tables[0].Rows[0]["CUSNAME"].ToString();
				}
				if (ds.Tables[0].Rows[0]["CUSADD"] != null && ds.Tables[0].Rows[0]["CUSADD"].ToString() != "")
				{
					model.CUSADD = ds.Tables[0].Rows[0]["CUSADD"].ToString();
				}
				if (ds.Tables[0].Rows[0]["CUSBOX"] != null && ds.Tables[0].Rows[0]["CUSBOX"].ToString() != "")
				{
					model.CUSBOX = ds.Tables[0].Rows[0]["CUSBOX"].ToString();
				}
				if (ds.Tables[0].Rows[0]["CUSZIP"] != null && ds.Tables[0].Rows[0]["CUSZIP"].ToString() != "")
				{
					model.CUSZIP = ds.Tables[0].Rows[0]["CUSZIP"].ToString();
				}
				if (ds.Tables[0].Rows[0]["CUSTEL"] != null && ds.Tables[0].Rows[0]["CUSTEL"].ToString() != "")
				{
					model.CUSTEL = ds.Tables[0].Rows[0]["CUSTEL"].ToString();
				}
				if (ds.Tables[0].Rows[0]["CUSCABLE"] != null && ds.Tables[0].Rows[0]["CUSCABLE"].ToString() != "")
				{
					model.CUSCABLE = ds.Tables[0].Rows[0]["CUSCABLE"].ToString();
				}
				if (ds.Tables[0].Rows[0]["CUSFAX"] != null && ds.Tables[0].Rows[0]["CUSFAX"].ToString() != "")
				{
					model.CUSFAX = ds.Tables[0].Rows[0]["CUSFAX"].ToString();
				}
				if (ds.Tables[0].Rows[0]["CUSURL"] != null && ds.Tables[0].Rows[0]["CUSURL"].ToString() != "")
				{
					model.CUSURL = ds.Tables[0].Rows[0]["CUSURL"].ToString();
				}
				if (ds.Tables[0].Rows[0]["CUSEMAIL"] != null && ds.Tables[0].Rows[0]["CUSEMAIL"].ToString() != "")
				{
					model.CUSEMAIL = ds.Tables[0].Rows[0]["CUSEMAIL"].ToString();
				}
				if (ds.Tables[0].Rows[0]["CUSCC"] != null && ds.Tables[0].Rows[0]["CUSCC"].ToString() != "")
				{
					model.CUSCC = ds.Tables[0].Rows[0]["CUSCC"].ToString();
				}
				if (ds.Tables[0].Rows[0]["CUSPNAME"] != null && ds.Tables[0].Rows[0]["CUSPNAME"].ToString() != "")
				{
					model.CUSPNAME = ds.Tables[0].Rows[0]["CUSPNAME"].ToString();
				}
				if (ds.Tables[0].Rows[0]["CUSBANKACNT"] != null && ds.Tables[0].Rows[0]["CUSBANKACNT"].ToString() != "")
				{
					model.CUSBANKACNT = ds.Tables[0].Rows[0]["CUSBANKACNT"].ToString();
				}
				if (ds.Tables[0].Rows[0]["CUSBANK"] != null && ds.Tables[0].Rows[0]["CUSBANK"].ToString() != "")
				{
					model.CUSBANK = ds.Tables[0].Rows[0]["CUSBANK"].ToString();
				}
				if (ds.Tables[0].Rows[0]["CUSTAXES"] != null && ds.Tables[0].Rows[0]["CUSTAXES"].ToString() != "")
				{
					model.CUSTAXES = ds.Tables[0].Rows[0]["CUSTAXES"].ToString();
				}
				if (ds.Tables[0].Rows[0]["CUSUNITMODE"] != null && ds.Tables[0].Rows[0]["CUSUNITMODE"].ToString() != "")
				{
					model.CUSUNITMODE = ds.Tables[0].Rows[0]["CUSUNITMODE"].ToString();
				}
				if (ds.Tables[0].Rows[0]["CUSPROVN"] != null && ds.Tables[0].Rows[0]["CUSPROVN"].ToString() != "")
				{
					model.CUSPROVN = ds.Tables[0].Rows[0]["CUSPROVN"].ToString();
				}
				if (ds.Tables[0].Rows[0]["CUSAREA"] != null && ds.Tables[0].Rows[0]["CUSAREA"].ToString() != "")
				{
					model.CUSAREA = ds.Tables[0].Rows[0]["CUSAREA"].ToString();
				}
				if (ds.Tables[0].Rows[0]["CUSTOTCASH"] != null && ds.Tables[0].Rows[0]["CUSTOTCASH"].ToString() != "")
				{
					model.CUSTOTCASH = decimal.Parse(ds.Tables[0].Rows[0]["CUSTOTCASH"].ToString());
				}
				if (ds.Tables[0].Rows[0]["CUSDEBT"] != null && ds.Tables[0].Rows[0]["CUSDEBT"].ToString() != "")
				{
					model.CUSDEBT = decimal.Parse(ds.Tables[0].Rows[0]["CUSDEBT"].ToString());
				}
				if (ds.Tables[0].Rows[0]["CUSCNTCOUNT"] != null && ds.Tables[0].Rows[0]["CUSCNTCOUNT"].ToString() != "")
				{
					model.CUSCNTCOUNT = decimal.Parse(ds.Tables[0].Rows[0]["CUSCNTCOUNT"].ToString());
				}
				if (ds.Tables[0].Rows[0]["CUSTRADE"] != null && ds.Tables[0].Rows[0]["CUSTRADE"].ToString() != "")
				{
					model.CUSTRADE = ds.Tables[0].Rows[0]["CUSTRADE"].ToString();
				}
				if (ds.Tables[0].Rows[0]["CUSBUSINESS"] != null && ds.Tables[0].Rows[0]["CUSBUSINESS"].ToString() != "")
				{
					model.CUSBUSINESS = ds.Tables[0].Rows[0]["CUSBUSINESS"].ToString();
				}
				if (ds.Tables[0].Rows[0]["CORSCAL"] != null && ds.Tables[0].Rows[0]["CORSCAL"].ToString() != "")
				{
					model.CORSCAL = new decimal?(decimal.Parse(ds.Tables[0].Rows[0]["CORSCAL"].ToString()));
				}
				if (ds.Tables[0].Rows[0]["YEARVALUE"] != null && ds.Tables[0].Rows[0]["YEARVALUE"].ToString() != "")
				{
					model.YEARVALUE = new decimal?(decimal.Parse(ds.Tables[0].Rows[0]["YEARVALUE"].ToString()));
				}
				if (ds.Tables[0].Rows[0]["YEARPROFIT"] != null && ds.Tables[0].Rows[0]["YEARPROFIT"].ToString() != "")
				{
					model.YEARPROFIT = new decimal?(decimal.Parse(ds.Tables[0].Rows[0]["YEARPROFIT"].ToString()));
				}
				if (ds.Tables[0].Rows[0]["RCVSTATION"] != null && ds.Tables[0].Rows[0]["RCVSTATION"].ToString() != "")
				{
					model.RCVSTATION = ds.Tables[0].Rows[0]["RCVSTATION"].ToString();
				}
				if (ds.Tables[0].Rows[0]["CUSREGION"] != null && ds.Tables[0].Rows[0]["CUSREGION"].ToString() != "")
				{
					model.CUSREGION = ds.Tables[0].Rows[0]["CUSREGION"].ToString();
				}
				if (ds.Tables[0].Rows[0]["DELTYPE"] != null && ds.Tables[0].Rows[0]["DELTYPE"].ToString() != "")
				{
					model.DELTYPE = ds.Tables[0].Rows[0]["DELTYPE"].ToString();
				}
				if (ds.Tables[0].Rows[0]["FPNAME"] != null && ds.Tables[0].Rows[0]["FPNAME"].ToString() != "")
				{
					model.FPNAME = ds.Tables[0].Rows[0]["FPNAME"].ToString();
				}
				if (ds.Tables[0].Rows[0]["FPADD"] != null && ds.Tables[0].Rows[0]["FPADD"].ToString() != "")
				{
					model.FPADD = ds.Tables[0].Rows[0]["FPADD"].ToString();
				}
				if (ds.Tables[0].Rows[0]["SALMAN"] != null && ds.Tables[0].Rows[0]["SALMAN"].ToString() != "")
				{
					model.SALMAN = ds.Tables[0].Rows[0]["SALMAN"].ToString();
				}
				if (ds.Tables[0].Rows[0]["HASSALMAN"] != null && ds.Tables[0].Rows[0]["HASSALMAN"].ToString() != "")
				{
					model.HASSALMAN = ds.Tables[0].Rows[0]["HASSALMAN"].ToString();
				}
				if (ds.Tables[0].Rows[0]["FREIGHTMODE"] != null && ds.Tables[0].Rows[0]["FREIGHTMODE"].ToString() != "")
				{
					model.FREIGHTMODE = ds.Tables[0].Rows[0]["FREIGHTMODE"].ToString();
				}
				if (ds.Tables[0].Rows[0]["ORDERDESC"] != null && ds.Tables[0].Rows[0]["ORDERDESC"].ToString() != "")
				{
					model.ORDERDESC = ds.Tables[0].Rows[0]["ORDERDESC"].ToString();
				}
				if (ds.Tables[0].Rows[0]["FPDESC"] != null && ds.Tables[0].Rows[0]["FPDESC"].ToString() != "")
				{
					model.FPDESC = ds.Tables[0].Rows[0]["FPDESC"].ToString();
				}
				if (ds.Tables[0].Rows[0]["CREATEDATE"] != null && ds.Tables[0].Rows[0]["CREATEDATE"].ToString() != "")
				{
					model.CREATEDATE = new DateTime?(DateTime.Parse(ds.Tables[0].Rows[0]["CREATEDATE"].ToString()));
				}
				if (ds.Tables[0].Rows[0]["DELIVEDESC"] != null && ds.Tables[0].Rows[0]["DELIVEDESC"].ToString() != "")
				{
					model.DELIVEDESC = ds.Tables[0].Rows[0]["DELIVEDESC"].ToString();
				}
				if (ds.Tables[0].Rows[0]["SENDADD"] != null && ds.Tables[0].Rows[0]["SENDADD"].ToString() != "")
				{
					model.SENDADD = ds.Tables[0].Rows[0]["SENDADD"].ToString();
				}
				if (ds.Tables[0].Rows[0]["LIMITMONEY"] != null && ds.Tables[0].Rows[0]["LIMITMONEY"].ToString() != "")
				{
					model.LIMITMONEY = new decimal?(decimal.Parse(ds.Tables[0].Rows[0]["LIMITMONEY"].ToString()));
				}
				if (ds.Tables[0].Rows[0]["INCPOSTDESC"] != null && ds.Tables[0].Rows[0]["INCPOSTDESC"].ToString() != "")
				{
					model.INCPOSTDESC = ds.Tables[0].Rows[0]["INCPOSTDESC"].ToString();
				}
				if (ds.Tables[0].Rows[0]["CUSSIGN"] != null && ds.Tables[0].Rows[0]["CUSSIGN"].ToString() != "")
				{
					model.CUSSIGN = ds.Tables[0].Rows[0]["CUSSIGN"].ToString();
				}
				if (ds.Tables[0].Rows[0]["AREA"] != null && ds.Tables[0].Rows[0]["AREA"].ToString() != "")
				{
					model.AREA = ds.Tables[0].Rows[0]["AREA"].ToString();
				}
				if (ds.Tables[0].Rows[0]["SALENO"] != null && ds.Tables[0].Rows[0]["SALENO"].ToString() != "")
				{
					model.SALENO = ds.Tables[0].Rows[0]["SALENO"].ToString();
				}
				if (ds.Tables[0].Rows[0]["NATION"] != null && ds.Tables[0].Rows[0]["NATION"].ToString() != "")
				{
					model.NATION = ds.Tables[0].Rows[0]["NATION"].ToString();
				}
				if (ds.Tables[0].Rows[0]["LAND"] != null && ds.Tables[0].Rows[0]["LAND"].ToString() != "")
				{
					model.LAND = ds.Tables[0].Rows[0]["LAND"].ToString();
				}
				if (ds.Tables[0].Rows[0]["DELIPLANNER"] != null && ds.Tables[0].Rows[0]["DELIPLANNER"].ToString() != "")
				{
					model.DELIPLANNER = ds.Tables[0].Rows[0]["DELIPLANNER"].ToString();
				}
				if (ds.Tables[0].Rows[0]["CUSCANCEL"] != null && ds.Tables[0].Rows[0]["CUSCANCEL"].ToString() != "")
				{
					model.CUSCANCEL = ds.Tables[0].Rows[0]["CUSCANCEL"].ToString();
				}
				if (ds.Tables[0].Rows[0]["CUSABNAME"] != null && ds.Tables[0].Rows[0]["CUSABNAME"].ToString() != "")
				{
					model.CUSABNAME = ds.Tables[0].Rows[0]["CUSABNAME"].ToString();
				}
				if (ds.Tables[0].Rows[0]["IMPSIGN"] != null && ds.Tables[0].Rows[0]["IMPSIGN"].ToString() != "")
				{
					model.IMPSIGN = ds.Tables[0].Rows[0]["IMPSIGN"].ToString();
				}
				if (ds.Tables[0].Rows[0]["ZXBH"] != null && ds.Tables[0].Rows[0]["ZXBH"].ToString() != "")
				{
					model.ZXBH = new decimal?(decimal.Parse(ds.Tables[0].Rows[0]["ZXBH"].ToString()));
				}
				if (ds.Tables[0].Rows[0]["CUSSERVICER"] != null && ds.Tables[0].Rows[0]["CUSSERVICER"].ToString() != "")
				{
					model.CUSSERVICER = ds.Tables[0].Rows[0]["CUSSERVICER"].ToString();
				}
				if (ds.Tables[0].Rows[0]["SOURCETYPE"] != null && ds.Tables[0].Rows[0]["SOURCETYPE"].ToString() != "")
				{
					model.SOURCETYPE = new decimal?(decimal.Parse(ds.Tables[0].Rows[0]["SOURCETYPE"].ToString()));
				}
				result = model;
			}
			else
			{
				result = null;
			}
			return result;
		}

		public DataSet GetList(string strWhere)
		{
			StringBuilder strSql = new StringBuilder();
			strSql.Append("select CLIENTID,CUSCODE,CUSNAME,CUSADD,CUSBOX,CUSZIP,CUSTEL,CUSCABLE,CUSFAX,CUSURL,CUSEMAIL,CUSCC,CUSPNAME,CUSBANKACNT,CUSBANK,CUSTAXES,CUSUNITMODE,CUSPROVN,CUSAREA,CUSTOTCASH,CUSDEBT,CUSCNTCOUNT,CUSTRADE,CUSBUSINESS,CORSCAL,YEARVALUE,YEARPROFIT,RCVSTATION,CUSREGION,DELTYPE,FPNAME,FPADD,SALMAN,HASSALMAN,FREIGHTMODE,ORDERDESC,FPDESC,CREATEDATE,DELIVEDESC,SENDADD,LIMITMONEY,INCPOSTDESC,CUSSIGN,AREA,SALENO,NATION,LAND,DELIPLANNER,CUSCANCEL,CUSABNAME,IMPSIGN,ZXBH,CUSSERVICER,SOURCETYPE ");
			strSql.Append(" FROM T_MEMBERS ");
			if (strWhere.Trim() != "")
			{
				strSql.Append(" where " + strWhere);
			}
			return DbHelperOra.Query(strSql.ToString());
		}

		public int GetRecordCount(string strWhere)
		{
			StringBuilder strSql = new StringBuilder();
			strSql.Append("select count(1) FROM T_MEMBERS ");
			if (strWhere.Trim() != "")
			{
				strSql.Append(" where " + strWhere);
			}
			object obj = DbHelperSQL.GetSingle(strSql.ToString());
			int result;
			if (obj == null)
			{
				result = 0;
			}
			else
			{
				result = Convert.ToInt32(obj);
			}
			return result;
		}

		public DataSet GetListByPage(string strWhere, string orderby, int startIndex, int endIndex)
		{
			StringBuilder strSql = new StringBuilder();
			strSql.Append("SELECT * FROM ( ");
			strSql.Append(" SELECT ROW_NUMBER() OVER (");
			if (!string.IsNullOrEmpty(orderby.Trim()))
			{
				strSql.Append("order by T." + orderby);
			}
			else
			{
				strSql.Append("order by T.CLIENTID desc");
			}
			strSql.Append(")AS Row, T.*  from T_MEMBERS T ");
			if (!string.IsNullOrEmpty(strWhere.Trim()))
			{
				strSql.Append(" WHERE " + strWhere);
			}
			strSql.Append(" ) TT");
			strSql.AppendFormat(" WHERE TT.Row between {0} and {1}", startIndex, endIndex);
			return DbHelperOra.Query(strSql.ToString());
		}
	}
}