/// <summary>
/// 得到一个对象实体
/// </summary>
public MES.Model.form4_Customer_mstr GetModel(int requestid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,requestid,Code,CreateDate,Userid,UserName,UserName_AD,dept,managerid,manager,manager_AD,Class,CmClassID,cmClassName,cm_domain,BusinessRelationCode,BusinessRelationName1,AddressSearchName,AddressTypeCode,AddressStreet1,cm_lang,ctry_country,cm_region,AddressZip,AddressCity,AddressState,ad_fax,ad_phone,AddressEMail,ContactName,ContactGender,ContactTelephone,ContactEmail,AddressIsTaxable,AddressIsTaxIncluded,AddressIsTaxInCity,TxzTaxZone,TxclTaxCls,LedgerDays,cm_slspsn,cm_pr_list,cm_fix_pr,BankNumberIsActive,InvControlGLProfileCode,CnControlGLProfileCode,PrepayControlGLProfileCode,SalesAccountGLProfileCode,ReasonCode,NormalPaymentConditionCode,CurrencyCode,BankAccFormatCode,BankNumberFormatted,OwnBankNumber,DebtorTypeCode,ExistsClass,Status_id from form4_Customer_mstr ");
strSql.Append(" where requestid=@requestid ");
SqlParameter[] parameters =
{
new SqlParameter("@requestid", SqlDbType.Int, 4)
};
parameters[0].Value = requestid;
MES.Model.form4_Customer_mstr model = new MES.Model.form4_Customer_mstr();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(MES.Model.form4_Customer_mstr model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into form4_Customer_mstr(");
strSql.Append("requestid,Code,CreateDate,Userid,UserName,UserName_AD,dept,managerid,manager,manager_AD,Class,CmClassID,cmClassName,cm_domain,BusinessRelationCode,BusinessRelationName1,AddressSearchName,AddressTypeCode,AddressStreet1,cm_lang,ctry_country,cm_region,AddressZip,AddressCity,AddressState,ad_fax,ad_phone,AddressEMail,ContactName,ContactGender,ContactTelephone,ContactEmail,AddressIsTaxable,AddressIsTaxIncluded,AddressIsTaxInCity,TxzTaxZone,TxclTaxCls,LedgerDays,cm_slspsn,cm_pr_list,cm_fix_pr,BankNumberIsActive,InvControlGLProfileCode,CnControlGLProfileCode,PrepayControlGLProfileCode,SalesAccountGLProfileCode,ReasonCode,NormalPaymentConditionCode,CurrencyCode,BankAccFormatCode,BankNumberFormatted,OwnBankNumber,DebtorTypeCode,ExistsClass,Status_id)");
strSql.Append(" values (");
strSql.Append("@requestid,@Code,@CreateDate,@Userid,@UserName,@UserName_AD,@dept,@managerid,@manager,@manager_AD,@Class,@CmClassID,@cmClassName,@cm_domain,@BusinessRelationCode,@BusinessRelationName1,@AddressSearchName,@AddressTypeCode,@AddressStreet1,@cm_lang,@ctry_country,@cm_region,@AddressZip,@AddressCity,@AddressState,@ad_fax,@ad_phone,@AddressEMail,@ContactName,@ContactGender,@ContactTelephone,@ContactEmail,@AddressIsTaxable,@AddressIsTaxIncluded,@AddressIsTaxInCity,@TxzTaxZone,@TxclTaxCls,@LedgerDays,@cm_slspsn,@cm_pr_list,@cm_fix_pr,@BankNumberIsActive,@InvControlGLProfileCode,@CnControlGLProfileCode,@PrepayControlGLProfileCode,@SalesAccountGLProfileCode,@ReasonCode,@NormalPaymentConditionCode,@CurrencyCode,@BankAccFormatCode,@BankNumberFormatted,@OwnBankNumber,@DebtorTypeCode,@ExistsClass,@Status_id)");
SqlParameter[] parameters =
{
// new SqlParameter("@ID", SqlDbType.Int,4),
new SqlParameter("@requestid", SqlDbType.Int, 4),
new SqlParameter("@Code", SqlDbType.NVarChar, 50),
new SqlParameter("@CreateDate", SqlDbType.DateTime),
new SqlParameter("@Userid", SqlDbType.NVarChar, 50),
new SqlParameter("@UserName", SqlDbType.NVarChar, 50),
new SqlParameter("@UserName_AD", SqlDbType.NVarChar, 50),
new SqlParameter("@dept", SqlDbType.NVarChar, 50),
new SqlParameter("@managerid", SqlDbType.NVarChar, 50),
new SqlParameter("@manager", SqlDbType.NVarChar, 50),
new SqlParameter("@manager_AD", SqlDbType.NVarChar, 50),
new SqlParameter("@Class", SqlDbType.NVarChar, 10),
new SqlParameter("@CmClassID", SqlDbType.NVarChar, 20),
new SqlParameter("@cmClassName", SqlDbType.NVarChar, 100),
new SqlParameter("@cm_domain", SqlDbType.NVarChar, 50),
new SqlParameter("@BusinessRelationCode", SqlDbType.NVarChar, 50),
new SqlParameter("@BusinessRelationName1", SqlDbType.NVarChar, 50),
new SqlParameter("@AddressSearchName", SqlDbType.NVarChar, 50),
new SqlParameter("@AddressTypeCode", SqlDbType.NVarChar, 50),
new SqlParameter("@AddressStreet1", SqlDbType.NVarChar, 100),
new SqlParameter("@cm_lang", SqlDbType.NVarChar, 50),
new SqlParameter("@ctry_country", SqlDbType.NVarChar, 50),
new SqlParameter("@cm_region", SqlDbType.NVarChar, 50),
new SqlParameter("@AddressZip", SqlDbType.NVarChar, 50),
new SqlParameter("@AddressCity", SqlDbType.VarChar, 50),
new SqlParameter("@AddressState", SqlDbType.NVarChar, 50),
new SqlParameter("@ad_fax", SqlDbType.NVarChar, 50),
new SqlParameter("@ad_phone", SqlDbType.NVarChar, 50),
new SqlParameter("@AddressEMail", SqlDbType.NVarChar, 50),
new SqlParameter("@ContactName", SqlDbType.NVarChar, 50),
new SqlParameter("@ContactGender", SqlDbType.NVarChar, 50),
new SqlParameter("@ContactTelephone", SqlDbType.NVarChar, 50),
new SqlParameter("@ContactEmail", SqlDbType.NVarChar, 50),
new SqlParameter("@AddressIsTaxable", SqlDbType.VarChar, 150),
new SqlParameter("@AddressIsTaxIncluded", SqlDbType.NVarChar, 50),
new SqlParameter("@AddressIsTaxInCity", SqlDbType.NVarChar, 50),
new SqlParameter("@TxzTaxZone", SqlDbType.NVarChar, 50),
new SqlParameter("@TxclTaxCls", SqlDbType.NVarChar, 50),
new SqlParameter("@LedgerDays", SqlDbType.NVarChar, 50),
new SqlParameter("@cm_slspsn", SqlDbType.NVarChar, 50),
new SqlParameter("@cm_pr_list", SqlDbType.NVarChar, 50),
new SqlParameter("@cm_fix_pr", SqlDbType.NVarChar, 50),
new SqlParameter("@BankNumberIsActive", SqlDbType.NVarChar, 50),
new SqlParameter("@InvControlGLProfileCode", SqlDbType.NVarChar, 50),
new SqlParameter("@CnControlGLProfileCode", SqlDbType.NVarChar, 50),
new SqlParameter("@PrepayControlGLProfileCode", SqlDbType.NVarChar, 50),
new SqlParameter("@SalesAccountGLProfileCode", SqlDbType.NVarChar, 50),
new SqlParameter("@ReasonCode", SqlDbType.NVarChar, 50),
new SqlParameter("@NormalPaymentConditionCode", SqlDbType.NVarChar, 50),
new SqlParameter("@CurrencyCode", SqlDbType.NVarChar, 50),
new SqlParameter("@BankAccFormatCode", SqlDbType.NVarChar, 50),
new SqlParameter("@BankNumberFormatted", SqlDbType.NVarChar, 50),
new SqlParameter("@OwnBankNumber", SqlDbType.NVarChar, 50),
new SqlParameter("@DebtorTypeCode", SqlDbType.NVarChar, 50),
new SqlParameter("@ExistsClass", SqlDbType.NVarChar, 50),
new SqlParameter("@Status_id", SqlDbType.NVarChar, 50)
};
//parameters[0].Value = model.ID;
parameters[0].Value = model.requestid;
parameters[1].Value = model.Code;
parameters[2].Value = model.CreateDate;
parameters[3].Value = model.Userid;
parameters[4].Value = model.UserName;
parameters[5].Value = model.UserName_AD;
parameters[6].Value = model.dept;
parameters[7].Value = model.managerid;
parameters[8].Value = model.manager;
parameters[9].Value = model.manager_AD;
parameters[10].Value = model.Class;
parameters[11].Value = model.CmClassID;
parameters[12].Value = model.cmClassName;
parameters[13].Value = model.cm_domain;
parameters[14].Value = model.BusinessRelationCode;
parameters[15].Value = model.BusinessRelationName1;
parameters[16].Value = model.AddressSearchName;
parameters[17].Value = model.AddressTypeCode;
parameters[18].Value = model.AddressStreet1;
parameters[19].Value = model.cm_lang;
parameters[20].Value = model.ctry_country;
parameters[21].Value = model.cm_region;
parameters[22].Value = model.AddressZip;
parameters[23].Value = model.AddressCity;
parameters[24].Value = model.AddressState;
parameters[25].Value = model.ad_fax;
parameters[26].Value = model.ad_phone;
parameters[27].Value = model.AddressEMail;
parameters[28].Value = model.ContactName;
parameters[29].Value = model.ContactGender;
parameters[30].Value = model.ContactTelephone;
parameters[31].Value = model.ContactEmail;
parameters[32].Value = model.AddressIsTaxable;
parameters[33].Value = model.AddressIsTaxIncluded;
parameters[34].Value = model.AddressIsTaxInCity;
parameters[35].Value = model.TxzTaxZone;
parameters[36].Value = model.TxclTaxCls;
parameters[37].Value = model.LedgerDays;
parameters[38].Value = model.cm_slspsn;
parameters[39].Value = model.cm_pr_list;
parameters[40].Value = model.cm_fix_pr;
parameters[41].Value = model.BankNumberIsActive;
parameters[42].Value = model.InvControlGLProfileCode;
parameters[43].Value = model.CnControlGLProfileCode;
parameters[44].Value = model.PrepayControlGLProfileCode;
parameters[45].Value = model.SalesAccountGLProfileCode;
parameters[46].Value = model.ReasonCode;
parameters[47].Value = model.NormalPaymentConditionCode;
parameters[48].Value = model.CurrencyCode;
parameters[49].Value = model.BankAccFormatCode;
parameters[50].Value = model.BankNumberFormatted;
parameters[51].Value = model.OwnBankNumber;
parameters[52].Value = model.DebtorTypeCode;
parameters[53].Value = model.ExistsClass;
parameters[54].Value = model.Status_id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MES.Model.form4_Customer_mstr DataRowToModel(DataRow row)
{
MES.Model.form4_Customer_mstr model = new MES.Model.form4_Customer_mstr();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = int.Parse(row["ID"].ToString());
}
if (row["requestid"] != null && row["requestid"].ToString() != "")
{
model.requestid = int.Parse(row["requestid"].ToString());
}
if (row["Code"] != null)
{
model.Code = row["Code"].ToString();
}
if (row["CreateDate"] != null && row["CreateDate"].ToString() != "")
{
model.CreateDate = DateTime.Parse(row["CreateDate"].ToString());
}
if (row["Userid"] != null)
{
model.Userid = row["Userid"].ToString();
}
if (row["UserName"] != null)
{
model.UserName = row["UserName"].ToString();
}
if (row["UserName_AD"] != null)
{
model.UserName_AD = row["UserName_AD"].ToString();
}
if (row["dept"] != null)
{
model.dept = row["dept"].ToString();
}
if (row["managerid"] != null)
{
model.managerid = row["managerid"].ToString();
}
if (row["manager"] != null)
{
model.manager = row["manager"].ToString();
}
if (row["manager_AD"] != null)
{
model.manager_AD = row["manager_AD"].ToString();
}
if (row["Class"] != null)
{
model.Class = row["Class"].ToString();
}
if (row["CmClassID"] != null)
{
model.CmClassID = row["CmClassID"].ToString();
}
if (row["cmClassName"] != null)
{
model.cmClassName = row["cmClassName"].ToString();
}
if (row["cm_domain"] != null)
{
model.cm_domain = row["cm_domain"].ToString();
}
if (row["BusinessRelationCode"] != null)
{
model.BusinessRelationCode = row["BusinessRelationCode"].ToString();
}
if (row["BusinessRelationName1"] != null)
{
model.BusinessRelationName1 = row["BusinessRelationName1"].ToString();
}
if (row["AddressSearchName"] != null)
{
model.AddressSearchName = row["AddressSearchName"].ToString();
}
if (row["AddressTypeCode"] != null)
{
model.AddressTypeCode = row["AddressTypeCode"].ToString();
}
if (row["AddressStreet1"] != null)
{
model.AddressStreet1 = row["AddressStreet1"].ToString();
}
if (row["cm_lang"] != null)
{
model.cm_lang = row["cm_lang"].ToString();
}
if (row["ctry_country"] != null)
{
model.ctry_country = row["ctry_country"].ToString();
}
if (row["cm_region"] != null)
{
model.cm_region = row["cm_region"].ToString();
}
if (row["AddressZip"] != null)
{
model.AddressZip = row["AddressZip"].ToString();
}
if (row["AddressCity"] != null)
{
model.AddressCity = row["AddressCity"].ToString();
}
if (row["AddressState"] != null)
{
model.AddressState = row["AddressState"].ToString();
}
if (row["ad_fax"] != null)
{
model.ad_fax = row["ad_fax"].ToString();
}
if (row["ad_phone"] != null)
{
model.ad_phone = row["ad_phone"].ToString();
}
if (row["AddressEMail"] != null)
{
model.AddressEMail = row["AddressEMail"].ToString();
}
if (row["ContactName"] != null)
{
model.ContactName = row["ContactName"].ToString();
}
if (row["ContactGender"] != null)
{
model.ContactGender = row["ContactGender"].ToString();
}
if (row["ContactTelephone"] != null)
{
model.ContactTelephone = row["ContactTelephone"].ToString();
}
if (row["ContactEmail"] != null)
{
model.ContactEmail = row["ContactEmail"].ToString();
}
if (row["AddressIsTaxable"] != null)
{
model.AddressIsTaxable = row["AddressIsTaxable"].ToString();
}
if (row["AddressIsTaxIncluded"] != null)
{
model.AddressIsTaxIncluded = row["AddressIsTaxIncluded"].ToString();
}
if (row["AddressIsTaxInCity"] != null)
{
model.AddressIsTaxInCity = row["AddressIsTaxInCity"].ToString();
}
if (row["TxzTaxZone"] != null)
{
model.TxzTaxZone = row["TxzTaxZone"].ToString();
}
if (row["TxclTaxCls"] != null)
{
model.TxclTaxCls = row["TxclTaxCls"].ToString();
}
if (row["LedgerDays"] != null)
{
model.LedgerDays = row["LedgerDays"].ToString();
}
if (row["cm_slspsn"] != null)
{
model.cm_slspsn = row["cm_slspsn"].ToString();
}
if (row["cm_pr_list"] != null)
{
model.cm_pr_list = row["cm_pr_list"].ToString();
}
if (row["cm_fix_pr"] != null)
{
model.cm_fix_pr = row["cm_fix_pr"].ToString();
}
if (row["BankNumberIsActive"] != null)
{
model.BankNumberIsActive = row["BankNumberIsActive"].ToString();
}
if (row["InvControlGLProfileCode"] != null)
{
model.InvControlGLProfileCode = row["InvControlGLProfileCode"].ToString();
}
if (row["CnControlGLProfileCode"] != null)
{
model.CnControlGLProfileCode = row["CnControlGLProfileCode"].ToString();
}
if (row["PrepayControlGLProfileCode"] != null)
{
model.PrepayControlGLProfileCode = row["PrepayControlGLProfileCode"].ToString();
}
if (row["SalesAccountGLProfileCode"] != null)
{
model.SalesAccountGLProfileCode = row["SalesAccountGLProfileCode"].ToString();
}
if (row["ReasonCode"] != null)
{
model.ReasonCode = row["ReasonCode"].ToString();
}
if (row["NormalPaymentConditionCode"] != null)
{
model.NormalPaymentConditionCode = row["NormalPaymentConditionCode"].ToString();
}
if (row["CurrencyCode"] != null)
{
model.CurrencyCode = row["CurrencyCode"].ToString();
}
if (row["BankAccFormatCode"] != null)
{
model.BankAccFormatCode = row["BankAccFormatCode"].ToString();
}
if (row["BankNumberFormatted"] != null)
{
model.BankNumberFormatted = row["BankNumberFormatted"].ToString();
}
if (row["OwnBankNumber"] != null)
{
model.OwnBankNumber = row["OwnBankNumber"].ToString();
}
if (row["DebtorTypeCode"] != null)
{
model.DebtorTypeCode = row["DebtorTypeCode"].ToString();
}
if (row["ExistsClass"] != null)
{
model.ExistsClass = row["ExistsClass"].ToString();
}
if (row["Status_id"] != null)
{
model.Status_id = row["Status_id"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MES.Model.form4_Customer_mstr model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update form4_Customer_mstr set ");
strSql.Append("@ID=@ID,");
strSql.Append("Code=@Code,");
strSql.Append("CreateDate=@CreateDate,");
strSql.Append("Userid=@Userid,");
strSql.Append("UserName=@UserName,");
strSql.Append("UserName_AD=@UserName_AD,");
strSql.Append("dept=@dept,");
strSql.Append("managerid=@managerid,");
strSql.Append("manager=@manager,");
strSql.Append("manager_AD=@manager_AD,");
strSql.Append("Class=@Class,");
strSql.Append("CmClassID=@CmClassID,");
strSql.Append("cmClassName=@cmClassName,");
strSql.Append("cm_domain=@cm_domain,");
strSql.Append("BusinessRelationCode=@BusinessRelationCode,");
strSql.Append("BusinessRelationName1=@BusinessRelationName1,");
strSql.Append("AddressSearchName=@AddressSearchName,");
strSql.Append("AddressTypeCode=@AddressTypeCode,");
strSql.Append("AddressStreet1=@AddressStreet1,");
strSql.Append("cm_lang=@cm_lang,");
strSql.Append("ctry_country=@ctry_country,");
strSql.Append("cm_region=@cm_region,");
strSql.Append("AddressZip=@AddressZip,");
strSql.Append("AddressCity=@AddressCity,");
strSql.Append("AddressState=@AddressState,");
strSql.Append("ad_fax=@ad_fax,");
strSql.Append("ad_phone=@ad_phone,");
strSql.Append("AddressEMail=@AddressEMail,");
strSql.Append("ContactName=@ContactName,");
strSql.Append("ContactGender=@ContactGender,");
strSql.Append("ContactTelephone=@ContactTelephone,");
strSql.Append("ContactEmail=@ContactEmail,");
strSql.Append("AddressIsTaxable=@AddressIsTaxable,");
strSql.Append("AddressIsTaxIncluded=@AddressIsTaxIncluded,");
strSql.Append("AddressIsTaxInCity=@AddressIsTaxInCity,");
strSql.Append("TxzTaxZone=@TxzTaxZone,");
strSql.Append("TxclTaxCls=@TxclTaxCls,");
strSql.Append("LedgerDays=@LedgerDays,");
strSql.Append("cm_slspsn=@cm_slspsn,");
strSql.Append("cm_pr_list=@cm_pr_list,");
strSql.Append("cm_fix_pr=@cm_fix_pr,");
strSql.Append("BankNumberIsActive=@BankNumberIsActive,");
strSql.Append("InvControlGLProfileCode=@InvControlGLProfileCode,");
strSql.Append("CnControlGLProfileCode=@CnControlGLProfileCode,");
strSql.Append("PrepayControlGLProfileCode=@PrepayControlGLProfileCode,");
strSql.Append("SalesAccountGLProfileCode=@SalesAccountGLProfileCode,");
strSql.Append("ReasonCode=@ReasonCode,");
strSql.Append("NormalPaymentConditionCode=@NormalPaymentConditionCode,");
strSql.Append("CurrencyCode=@CurrencyCode,");
strSql.Append("BankAccFormatCode=@BankAccFormatCode,");
strSql.Append("BankNumberFormatted=@BankNumberFormatted,");
strSql.Append("OwnBankNumber=@OwnBankNumber,");
strSql.Append("DebtorTypeCode=@DebtorTypeCode,");
strSql.Append("ExistsClass=@ExistsClass,");
strSql.Append("Status_id=@Status_id");
strSql.Append(" where requestid=@requestid ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@Code", SqlDbType.NVarChar, 50),
new SqlParameter("@CreateDate", SqlDbType.DateTime),
new SqlParameter("@Userid", SqlDbType.NVarChar, 50),
new SqlParameter("@UserName", SqlDbType.NVarChar, 50),
new SqlParameter("@UserName_AD", SqlDbType.NVarChar, 50),
new SqlParameter("@dept", SqlDbType.NVarChar, 50),
new SqlParameter("@managerid", SqlDbType.NVarChar, 50),
new SqlParameter("@manager", SqlDbType.NVarChar, 50),
new SqlParameter("@manager_AD", SqlDbType.NVarChar, 50),
new SqlParameter("@Class", SqlDbType.NVarChar, 10),
new SqlParameter("@CmClassID", SqlDbType.NVarChar, 20),
new SqlParameter("@cmClassName", SqlDbType.NVarChar, 100),
new SqlParameter("@cm_domain", SqlDbType.NVarChar, 50),
new SqlParameter("@BusinessRelationCode", SqlDbType.NVarChar, 50),
new SqlParameter("@BusinessRelationName1", SqlDbType.NVarChar, 50),
new SqlParameter("@AddressSearchName", SqlDbType.NVarChar, 50),
new SqlParameter("@AddressTypeCode", SqlDbType.NVarChar, 50),
new SqlParameter("@AddressStreet1", SqlDbType.NVarChar, 100),
new SqlParameter("@cm_lang", SqlDbType.NVarChar, 50),
new SqlParameter("@ctry_country", SqlDbType.NVarChar, 50),
new SqlParameter("@cm_region", SqlDbType.NVarChar, 50),
new SqlParameter("@AddressZip", SqlDbType.NVarChar, 50),
new SqlParameter("@AddressCity", SqlDbType.VarChar, 50),
new SqlParameter("@AddressState", SqlDbType.NVarChar, 50),
new SqlParameter("@ad_fax", SqlDbType.NVarChar, 50),
new SqlParameter("@ad_phone", SqlDbType.NVarChar, 50),
new SqlParameter("@AddressEMail", SqlDbType.NVarChar, 50),
new SqlParameter("@ContactName", SqlDbType.NVarChar, 50),
new SqlParameter("@ContactGender", SqlDbType.NVarChar, 50),
new SqlParameter("@ContactTelephone", SqlDbType.NVarChar, 50),
new SqlParameter("@ContactEmail", SqlDbType.NVarChar, 50),
new SqlParameter("@AddressIsTaxable", SqlDbType.VarChar, 150),
new SqlParameter("@AddressIsTaxIncluded", SqlDbType.NVarChar, 50),
new SqlParameter("@AddressIsTaxInCity", SqlDbType.NVarChar, 50),
new SqlParameter("@TxzTaxZone", SqlDbType.NVarChar, 50),
new SqlParameter("@TxclTaxCls", SqlDbType.NVarChar, 50),
new SqlParameter("@LedgerDays", SqlDbType.NVarChar, 50),
new SqlParameter("@cm_slspsn", SqlDbType.NVarChar, 50),
new SqlParameter("@cm_pr_list", SqlDbType.NVarChar, 50),
new SqlParameter("@cm_fix_pr", SqlDbType.NVarChar, 50),
new SqlParameter("@BankNumberIsActive", SqlDbType.NVarChar, 50),
new SqlParameter("@InvControlGLProfileCode", SqlDbType.NVarChar, 50),
new SqlParameter("@CnControlGLProfileCode", SqlDbType.NVarChar, 50),
new SqlParameter("@PrepayControlGLProfileCode", SqlDbType.NVarChar, 50),
new SqlParameter("@SalesAccountGLProfileCode", SqlDbType.NVarChar, 50),
new SqlParameter("@ReasonCode", SqlDbType.NVarChar, 50),
new SqlParameter("@NormalPaymentConditionCode", SqlDbType.NVarChar, 50),
new SqlParameter("@CurrencyCode", SqlDbType.NVarChar, 50),
new SqlParameter("@BankAccFormatCode", SqlDbType.NVarChar, 50),
new SqlParameter("@BankNumberFormatted", SqlDbType.NVarChar, 50),
new SqlParameter("@OwnBankNumber", SqlDbType.NVarChar, 50),
new SqlParameter("@DebtorTypeCode", SqlDbType.NVarChar, 50),
new SqlParameter("@ExistsClass", SqlDbType.NVarChar, 50),
new SqlParameter("@Status_id", SqlDbType.NVarChar, 50),
new SqlParameter("@requestid", SqlDbType.Int, 4)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.Code;
parameters[2].Value = model.CreateDate;
parameters[3].Value = model.Userid;
parameters[4].Value = model.UserName;
parameters[5].Value = model.UserName_AD;
parameters[6].Value = model.dept;
parameters[7].Value = model.managerid;
parameters[8].Value = model.manager;
parameters[9].Value = model.manager_AD;
parameters[10].Value = model.Class;
parameters[11].Value = model.CmClassID;
parameters[12].Value = model.cmClassName;
parameters[13].Value = model.cm_domain;
parameters[14].Value = model.BusinessRelationCode;
parameters[15].Value = model.BusinessRelationName1;
parameters[16].Value = model.AddressSearchName;
parameters[17].Value = model.AddressTypeCode;
parameters[18].Value = model.AddressStreet1;
parameters[19].Value = model.cm_lang;
parameters[20].Value = model.ctry_country;
parameters[21].Value = model.cm_region;
parameters[22].Value = model.AddressZip;
parameters[23].Value = model.AddressCity;
parameters[24].Value = model.AddressState;
parameters[25].Value = model.ad_fax;
parameters[26].Value = model.ad_phone;
parameters[27].Value = model.AddressEMail;
parameters[28].Value = model.ContactName;
parameters[29].Value = model.ContactGender;
parameters[30].Value = model.ContactTelephone;
parameters[31].Value = model.ContactEmail;
parameters[32].Value = model.AddressIsTaxable;
parameters[33].Value = model.AddressIsTaxIncluded;
parameters[34].Value = model.AddressIsTaxInCity;
parameters[35].Value = model.TxzTaxZone;
parameters[36].Value = model.TxclTaxCls;
parameters[37].Value = model.LedgerDays;
parameters[38].Value = model.cm_slspsn;
parameters[39].Value = model.cm_pr_list;
parameters[40].Value = model.cm_fix_pr;
parameters[41].Value = model.BankNumberIsActive;
parameters[42].Value = model.InvControlGLProfileCode;
parameters[43].Value = model.CnControlGLProfileCode;
parameters[44].Value = model.PrepayControlGLProfileCode;
parameters[45].Value = model.SalesAccountGLProfileCode;
parameters[46].Value = model.ReasonCode;
parameters[47].Value = model.NormalPaymentConditionCode;
parameters[48].Value = model.CurrencyCode;
parameters[49].Value = model.BankAccFormatCode;
parameters[50].Value = model.BankNumberFormatted;
parameters[51].Value = model.OwnBankNumber;
parameters[52].Value = model.DebtorTypeCode;
parameters[53].Value = model.ExistsClass;
parameters[54].Value = model.Status_id;
parameters[55].Value = model.requestid;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
