protected void btnImport_Click(object sender, ImageClickEventArgs e)
{
try
{
string orderString = hiddExpOrder.Value.Trim();//排序
string order = "asc";//排序：降序
string orderBy = (!string.IsNullOrEmpty(orderString)) ? orderString.Substring(0, orderString.Length - 2) : "linkmanname";//要排序的字段，如果为空，默认为"ID"
if (orderString.EndsWith("_d"))
{
order = "desc";//排序：降序
}
string CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
string ord = " ORDER BY " + orderBy + " " + order;
LinkManModel LinkManM = new LinkManModel();
string CustID = hiddCustID.Value;//客户ID
LinkManM.LinkManName = txtLinkManName.Value.Trim();
LinkManM.Handset = txtHandset.Value.Trim();
LinkManM.Important = seleImportant.Value;
LinkManM.LinkType = ddlLinkType.SelectedItem.Value == "0" ? 0 : Convert.ToInt32(ddlLinkType.SelectedItem.Value);
string DateBegin = txtDateBegin.Value.Trim();
string DateEnd = txtDateEnd.Value.Trim();
LinkManM.WorkTel = txtWorkTel.Value.Trim();
LinkManM.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
LinkManM.CanViewUser = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeID.ToString();//当前用户ID
DataTable dt = LinkManBus.ExportLinkManInfo(CustID, LinkManM, DateBegin, DateEnd, ord);
OutputToExecl.ExportToTableFormat(this, dt,
new string[] { "联系人姓名", "对应客户", "称谓", "联系人类型", "重要程度", "工作电话", "手机", "QQ", "生日"},
new string[] { "linkmanname", "CustName", "Appellation", "TypeName", "Important", "WorkTel", "Handset", "QQ", "Birthday" },
"联系人列表");
}
catch
{
ClientScript.RegisterStartupScript(this.GetType(), "Exp", "<script language=javascript>showPopup('../../../Images/Pic/Close.gif','../../../Images/Pic/note.gif','导出发生异常');</script>");
}
}
protected void btn_excel_Click(object sender, EventArgs e)
{
string ErrorMsg = string.Empty;
#region 上传文件包含验证
/*获取公司的上传路径*/
string FileUrl = XBase.Business.Office.SupplyChain.ProductInfoBus.GetCompanyUpFilePath(UserInfo.CompanyCD);
/*验证该公司路径是否存在 不存在则创建*/
DirectoryInfo dir = new DirectoryInfo(FileUrl);
if (!dir.Exists)
{
try
{
dir.Create();
}
catch (Exception ex)
{
lblMsg.Text = ex.ToString();
return;
}
}
/*验证是否选择了文件*/
if (string.IsNullOrEmpty(fileExportExcel.PostedFile.FileName))
{
lblMsg.Text = "请选择需要导入的Excel文件";
return;
}
/*验证文件类型*/
string FileExtension = fileExportExcel.PostedFile.FileName.Split('.')[1].ToUpper();
if (FileExtension != "XLS" && FileExtension != "XLSX")
{
lblMsg.Text = "文件类型错误，请上传正确的Excel文件";
return;
}
/*上传文件*/
string FileName = Guid.NewGuid().ToString() + "." + FileExtension.ToLower();
string FileNewUrl = FileUrl + "\\" + FileName;
try
{
fileExportExcel.PostedFile.SaveAs(FileNewUrl);
}
catch (Exception ex)
{
lblMsg.Text = ex.ToString();
return;
}
#endregion
#region 将Excel转换为DataTable
/*将Excel转换成DataTable*/
System.Data.DataTable dt = ExcelToDataTable(FileNewUrl);
/*验证Excel是否为空*/
if (dt == null || dt.Rows.Count <= 0)
{
lblMsg.Text = "Excel文件为空，请重新上传Excel文件";
try
{
//删除上传的Excel文件
DelExcel(FileNewUrl);
}
catch (Exception ex)
{
lblMsg.Text = ex.ToString();
return;
}
return;
}
//转换成功，删除上传的Excel文件、
try
{
DelExcel(FileNewUrl);
}
catch (Exception ex)
{
lblMsg.Text = ex.ToString();
}
#endregion
#region 重新设置列名
int m = 0;
dt.Columns[m++].ColumnName = "CustName";
dt.Columns[m++].ColumnName = "ContactName";
dt.Columns[m++].ColumnName = "Sex";
dt.Columns[m++].ColumnName = "Important";
dt.Columns[m++].ColumnName = "TypeName";
dt.Columns[m++].ColumnName = "Age";
dt.Columns[m++].ColumnName = "Operation";
dt.Columns[m++].ColumnName = "Company";
dt.Columns[m++].ColumnName = "Position";
dt.Columns[m++].ColumnName = "Department";
dt.Columns[m++].ColumnName = "WorkTel";
dt.Columns[m++].ColumnName = "Handset";
dt.Columns[m++].ColumnName = "Fax";
dt.Columns[m++].ColumnName = "HomeTel";
dt.Columns[m++].ColumnName = "MailAddress";
#endregion
#region 重新构造数据源
//DataTable dtNew = new DataTable();
//dtNew.Columns.Add(new DataColumn("custNo", typeof(string)));
//dtNew.Columns.Add(new DataColumn("LinkType", typeof(string)));
//dtNew.Columns.Add(new DataColumn("LinkManName", typeof(string)));
//dtNew.Columns.Add(new DataColumn("Sex", typeof(string)));
//dtNew.Columns.Add(new DataColumn("Important", typeof(string)));
//dtNew.Columns.Add(new DataColumn("Age", typeof(string)));
//dtNew.Columns.Add(new DataColumn("Operation", typeof(string)));
//dtNew.Columns.Add(new DataColumn("Company", typeof(string)));
//dtNew.Columns.Add(new DataColumn("Position", typeof(string)));
//dtNew.Columns.Add(new DataColumn("Department", typeof(string)));
//dtNew.Columns.Add(new DataColumn("WorkTel", typeof(string)));
//dtNew.Columns.Add(new DataColumn("Fax", typeof(string)));
//dtNew.Columns.Add(new DataColumn("Handset", typeof(string)));
//dtNew.Columns.Add(new DataColumn("HomeTel", typeof(string)));
//dtNew.Columns.Add(new DataColumn("MailAddress", typeof(string)));
#endregion
#region 数据验证,并重新构造实体列表
List<XBase.Model.Office.CustManager.LinkManModel> modelList = new List<XBase.Model.Office.CustManager.LinkManModel>();
int index = 2;
foreach (DataRow row in dt.Rows)
{
#region 对应客户验证
string custNo = string.Empty;
if (string.IsNullOrEmpty(row["CustName"].ToString()))
ErrorMsg += "对应客户不能为空。<br />";
else
{
custNo = CustomContactImportBus.CustomExists(UserInfo.CompanyCD, row["CustName"].ToString());
if (string.IsNullOrEmpty(custNo))
ErrorMsg += "所填写的客户在系统中不存在。<br />";
}
#endregion
#region 验证联系人姓名
if (string.IsNullOrEmpty(row["ContactName"].ToString()))
ErrorMsg += "联系人姓名不能为空。<br />";
#endregion
#region 验证联系人类型
string typeName = string.Empty;
if (!string.IsNullOrEmpty(row["TypeName"].ToString()))
{
typeName = CustomContactImportBus.ContactExists(UserInfo.CompanyCD, row["TypeName"].ToString());
if (string.IsNullOrEmpty(typeName))
ErrorMsg += "所填写的联系人类型在系统中不存在。<br />";
}
else
typeName = "0";
#endregion
#region 客户重要程度
string Important = "0";
if (!string.IsNullOrEmpty(row["Important"].ToString()))
{
switch (row["Important"].ToString())
{
case "": Important = "0"; break;
case "不重要": Important = "1"; break;
case "普通": Important = "2"; break;
case "重要": Important = "3"; break;
case "关键": Important = "4"; break;
default: ErrorMsg += "联系人重要程度不正确。<br />"; break;
}
}
#endregion
#region 性别
string sex = string.Empty;
if (string.IsNullOrEmpty(row["Sex"].ToString()))
{
ErrorMsg += "性别不能为空。<br />";
}
else
{
switch (row["Sex"].ToString())
{
case "男": sex = "1"; break;
case "女": sex = "2"; break;
default: ErrorMsg += "性别只能为男或女。<br />"; break;
}
}
#endregion
#region 若无错误信息，则将该行数据添加至新的数据源,反之则保存错误信息
if (string.IsNullOrEmpty(ErrorMsg))
{
XBase.Model.Office.CustManager.LinkManModel model = new XBase.Model.Office.CustManager.LinkManModel();
model.CustNo = custNo;
model.LinkType = Convert.ToInt32(typeName);
model.LinkManName = row["ContactName"].ToString();
model.Sex = sex;
model.Important = Important;
model.Age = row["Age"].ToString();
model.Operation = row["Operation"].ToString();
model.Company = row["Company"].ToString();
model.Position = row["Position"].ToString();
model.Department = row["Department"].ToString();
model.WorkTel = row["WorkTel"].ToString();
model.Fax = row["Fax"].ToString();
model.Handset = row["Handset"].ToString();
model.HomeTel = row["HomeTel"].ToString();
model.MailAddress = row["MailAddress"].ToString();
model.CreatedDate = DateTime.Now.ToString();
model.Creator = UserInfo.EmployeeID.ToString();
model.CanViewUser = UserInfo.EmployeeID.ToString() + ".";
model.CompanyCD = UserInfo.CompanyCD;
modelList.Add(model);
}
else
{
ErrorMsg = "第 " + index.ToString() + " 行中存在的错误：<br />" + ErrorMsg;
}
#endregion
index++;
}
#endregion
#region 添加数据
if (string.IsNullOrEmpty(ErrorMsg))
{
try
{
bool res = CustomContactImportBus.ImportContact(modelList);
if (res)
lblMsg.Text = "数据导入成功！";
else
lblMsg.Text = "数据导入失败！";
}
catch (Exception ex)
{
lblMsg.Text = ex.ToString();
}
}
else
{
lblMsg.Text = "数据导入失败，原因如下：<br />" + ErrorMsg;
}
#endregion
}
/// <summary>
/// 增加客户信息的方法
/// </summary>
/// <param name="CustModel">客户信息Model</param>
/// <returns>bool值</returns>
public static bool CustInfoAdd(CustInfoModel CustModel,LinkManModel LinkManM, Hashtable htExtAttr)
{
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
LogInfoModel logModel = new LogInfoModel(); //操作日志
bool isSucc = false;//定义返回变量
#region 设置操作日志内容
//设置公司代码
logModel.CompanyCD = userInfo.CompanyCD;
//设置登陆用户ID
logModel.UserID = userInfo.UserID;
//设置模块ID 模块ID在ConstUtil中定义，以便维护
logModel.ModuleID = ConstUtil.MODULE_ID_CUST_INFO_ADD;
//操作单据编号 客户编号
logModel.ObjectID = CustModel.CustNo;
//操作对象 操作的表信息
logModel.ObjectName = ConstUtil.TABLE_NAME_CUST;
//涉及关键元素 涉及其他业务、表关系
logModel.Element = string.Empty;
//备注 操作类型
logModel.Remark = ConstUtil.LOG_PROCESS_INSERT;
#endregion
try
{
//if (CustModel.CustBig == "2")//会员客户时，添加到2个表中
//{
//}
//else
//{
isSucc = CustInfoDBHelper.CustInfoAdd(CustModel,LinkManM, htExtAttr);
//}
}
catch (System.Exception ex)
{
#region 操作失败时记录日志到文件
//定义变量
LogInfo logSys = new LogInfo();
//设置日志类型 需要指定为系统日志
logSys.Type = LogInfo.LogType.SYSTEM;
//指定系统日志类型 出错信息
logSys.SystemKind = LogInfo.SystemLogKind.SYSTEM_ERROR;
//指定登陆用户信息
logSys.UserInfo = userInfo;
//设定模块ID
logSys.ModuleID = ConstUtil.MODULE_ID_CUST_INFO_ADD;
//描述
logSys.Description = ex.ToString();
//输出日志
LogUtil.WriteLog(logSys);
#endregion
}
if (isSucc)//操作成功
{
logModel.Remark += "成功";
}
else//操作失败
{
logModel.Remark += "失败";
}
//记录日志
LogDBHelper.InsertLog(logModel);
return isSucc;
}
protected void btn_excel_Click(object sender, EventArgs e)
{
string ErrorMsg = string.Empty;
#region 文件包含验证
/*获取公司的上传路径*/
string FileUrl = XBase.Business.Office.SupplyChain.ProductInfoBus.GetCompanyUpFilePath(UserInfo.CompanyCD);
/*验证该公司路径是否存在 不存在则创建*/
DirectoryInfo dir = new DirectoryInfo(FileUrl);
if (!dir.Exists)
{
try
{
dir.Create();
}
catch (Exception ex)
{
lblMsg.Text = ex.ToString();
return;
}
}
/*验证是否选择了文件*/
if (string.IsNullOrEmpty(fileExportExcel.PostedFile.FileName))
{
lblMsg.Text = "请选择需要导入的Excel文件";
return;
}
/*验证文件类型*/
string FileExtension = fileExportExcel.PostedFile.FileName.Split('.')[1].ToUpper();
if (FileExtension != "XLS" && FileExtension != "XLSX")
{
lblMsg.Text = "文件类型错误，请上传正确的Excel文件";
return;
}
/*上传文件*/
string FileName = Guid.NewGuid().ToString() + "." + FileExtension.ToLower();
string FileNewUrl = FileUrl + "\\" + FileName;
try
{
fileExportExcel.PostedFile.SaveAs(FileNewUrl);
}
catch (Exception ex)
{
lblMsg.Text = ex.ToString();
return;
}
#endregion
#region 将Excel转换为DataTable
/*将Excel转换成DataTable*/
System.Data.DataTable dt = ExcelToDataTable(FileNewUrl);
/*验证Excel是否为空*/
if (dt == null || dt.Rows.Count <= 0)
{
lblMsg.Text = "Excel文件为空，请重新上传Excel文件";
try
{
//删除上传的Excel文件
DelExcel(FileNewUrl);
}
catch (Exception ex)
{
lblMsg.Text = ex.ToString();
return;
}
return;
}
//转换成功，删除上传的Excel文件、
try
{
DelExcel(FileNewUrl);
}
catch (Exception ex)
{
lblMsg.Text = ex.ToString();
}
#endregion
#region 重新设置列名
int m = 0;
dt.Columns[m++].ColumnName = "CustName";
dt.Columns[m++].ColumnName = "ContactName";
dt.Columns[m++].ColumnName = "Sex";
dt.Columns[m++].ColumnName = "Important";
dt.Columns[m++].ColumnName = "TypeName";
dt.Columns[m++].ColumnName = "Age";
dt.Columns[m++].ColumnName = "Operation";
dt.Columns[m++].ColumnName = "Company";
dt.Columns[m++].ColumnName = "Position";
dt.Columns[m++].ColumnName = "Department";
dt.Columns[m++].ColumnName = "WorkTel";
dt.Columns[m++].ColumnName = "Handset";
dt.Columns[m++].ColumnName = "Fax";
dt.Columns[m++].ColumnName = "HomeTel";
dt.Columns[m++].ColumnName = "MailAddress";
#endregion
#region 重新构造数据源
//DataTable dtNew = new DataTable();
//dtNew.Columns.Add(new DataColumn("custNo", typeof(string)));
//dtNew.Columns.Add(new DataColumn("LinkType", typeof(string)));
//dtNew.Columns.Add(new DataColumn("LinkManName", typeof(string)));
//dtNew.Columns.Add(new DataColumn("Sex", typeof(string)));
//dtNew.Columns.Add(new DataColumn("Important", typeof(string)));
//dtNew.Columns.Add(new DataColumn("Age", typeof(string)));
//dtNew.Columns.Add(new DataColumn("Operation", typeof(string)));
//dtNew.Columns.Add(new DataColumn("Company", typeof(string)));
//dtNew.Columns.Add(new DataColumn("Position", typeof(string)));
//dtNew.Columns.Add(new DataColumn("Department", typeof(string)));
//dtNew.Columns.Add(new DataColumn("WorkTel", typeof(string)));
//dtNew.Columns.Add(new DataColumn("Fax", typeof(string)));
//dtNew.Columns.Add(new DataColumn("Handset", typeof(string)));
//dtNew.Columns.Add(new DataColumn("HomeTel", typeof(string)));
//dtNew.Columns.Add(new DataColumn("MailAddress", typeof(string)));
#endregion
#region 数据验证,并重新构造实体列表
List <XBase.Model.Office.CustManager.LinkManModel> modelList = new List <XBase.Model.Office.CustManager.LinkManModel>();
int index = 2;
foreach (DataRow row in dt.Rows)
{
#region 对应客户验证
string custNo = string.Empty;
if (string.IsNullOrEmpty(row["CustName"].ToString()))
{
ErrorMsg += "对应客户不能为空。<br />";
}
else
{
custNo = CustomContactImportBus.CustomExists(UserInfo.CompanyCD, row["CustName"].ToString());
if (string.IsNullOrEmpty(custNo))
{
ErrorMsg += "所填写的客户在系统中不存在。<br />";
}
}
#endregion
#region 验证联系人姓名
if (string.IsNullOrEmpty(row["ContactName"].ToString()))
{
ErrorMsg += "联系人姓名不能为空。<br />";
}
#endregion
#region 验证联系人类型
string typeName = string.Empty;
if (!string.IsNullOrEmpty(row["TypeName"].ToString()))
{
typeName = CustomContactImportBus.ContactExists(UserInfo.CompanyCD, row["TypeName"].ToString());
if (string.IsNullOrEmpty(typeName))
{
ErrorMsg += "所填写的联系人类型在系统中不存在。<br />";
}
}
else
{
typeName = "0";
}
#endregion
#region 客户重要程度
string Important = "0";
if (!string.IsNullOrEmpty(row["Important"].ToString()))
{
switch (row["Important"].ToString())
{
case "": Important = "0"; break;
case "不重要": Important = "1"; break;
case "普通": Important = "2"; break;
case "重要": Important = "3"; break;
case "关键": Important = "4"; break;
default: ErrorMsg += "联系人重要程度不正确。<br />"; break;
}
}
#endregion
#region 性别
string sex = string.Empty;
if (string.IsNullOrEmpty(row["Sex"].ToString()))
{
ErrorMsg += "性别不能为空。<br />";
}
else
{
switch (row["Sex"].ToString())
{
case "男": sex = "1"; break;
case "女": sex = "2"; break;
default: ErrorMsg += "性别只能为男或女。<br />"; break;
}
}
#endregion
#region 若无错误信息，则将该行数据添加至新的数据源,反之则保存错误信息
if (string.IsNullOrEmpty(ErrorMsg))
{
XBase.Model.Office.CustManager.LinkManModel model = new XBase.Model.Office.CustManager.LinkManModel();
model.CustNo = custNo;
model.LinkType = Convert.ToInt32(typeName);
model.LinkManName = row["ContactName"].ToString();
model.Sex = sex;
model.Important = Important;
model.Age = row["Age"].ToString();
model.Operation = row["Operation"].ToString();
model.Company = row["Company"].ToString();
model.Position = row["Position"].ToString();
model.Department = row["Department"].ToString();
model.WorkTel = row["WorkTel"].ToString();
model.Fax = row["Fax"].ToString();
model.Handset = row["Handset"].ToString();
model.HomeTel = row["HomeTel"].ToString();
model.MailAddress = row["MailAddress"].ToString();
model.CreatedDate = DateTime.Now.ToString();
model.Creator = UserInfo.EmployeeID.ToString();
model.CanViewUser = UserInfo.EmployeeID.ToString() + ".";
model.CompanyCD = UserInfo.CompanyCD;
modelList.Add(model);
}
else
{
ErrorMsg = "第 " + index.ToString() + " 行中存在的错误：<br />" + ErrorMsg;
}
#endregion
index++;
}
#endregion
#region 添加数据
if (string.IsNullOrEmpty(ErrorMsg))
{
try
{
bool res = CustomContactImportBus.ImportContact(modelList);
if (res)
{
lblMsg.Text = "数据导入成功！";
}
else
{
lblMsg.Text = "数据导入失败！";
}
}
catch (Exception ex)
{
lblMsg.Text = ex.ToString();
}
}
else
{
lblMsg.Text = "数据导入失败，原因如下：<br />" + ErrorMsg;
}
#endregion
}
/// <summary>
/// 同时添加客户信息及联系人列表信息的方法
/// </summary>
/// <param name="CustInfoModel">客户信息Model</param>
/// <param name="LinkManlist">联系人列表信息流</param>
/// <returns>bool值</returns>
public static bool AddCustAndLinkMan(CustInfoModel CustInfoModel, string LinkManlist)
{
try
{
#region 拼写添加客户信息SQL语句
StringBuilder sql = new StringBuilder();
sql.AppendLine("INSERT INTO officedba.CustInfo");
sql.AppendLine("(CompanyCD");
sql.AppendLine(",CustType");
sql.AppendLine(",CustClass ");
sql.AppendLine(",CustNo ");
sql.AppendLine(",CustName ");
sql.AppendLine(",CustNam ");
sql.AppendLine(",CustShort ");
sql.AppendLine(",CreditGrade ");
sql.AppendLine(",Manager ");
sql.AppendLine(",AreaID ");
sql.AppendLine(",CustNote ");
sql.AppendLine(",LinkCycle ");
sql.AppendLine(",HotIs ");
sql.AppendLine(",HotHow ");
sql.AppendLine(",HotType ");
sql.AppendLine(",MeritGrade ");
sql.AppendLine(",RelaGrade ");
sql.AppendLine(",Relation ");
sql.AppendLine(",CompanyType ");
sql.AppendLine(",StaffCount ");
sql.AppendLine(",Source ");
sql.AppendLine(",Phase ");
sql.AppendLine(",CustSupe ");
sql.AppendLine(",Trade ");
sql.AppendLine(",SetupDate ");
sql.AppendLine(",ArtiPerson ");
sql.AppendLine(",SetupMoney ");
sql.AppendLine(",SetupAddress ");
sql.AppendLine(",CapitalScale ");
sql.AppendLine(",SaleroomY ");
sql.AppendLine(",ProfitY ");
sql.AppendLine(",TaxCD ");
sql.AppendLine(",BusiNumber ");
sql.AppendLine(",IsTax ");
sql.AppendLine(",SellMode ");
sql.AppendLine(",SellArea ");
sql.AppendLine(",CountryID ");
sql.AppendLine(",Province ");
sql.AppendLine(",City ");
sql.AppendLine(",Tel ");
sql.AppendLine(",ContactName ");
sql.AppendLine(",Mobile ");
sql.AppendLine(",ReceiveAddress ");
sql.AppendLine(",WebSite ");
sql.AppendLine(",Post ");
sql.AppendLine(",email ");
sql.AppendLine(",Fax ");
sql.AppendLine(",OnLine ");
sql.AppendLine(",TakeType ");
sql.AppendLine(",CarryType ");
sql.AppendLine(",BusiType ");
sql.AppendLine(",BillType ");
sql.AppendLine(",PayType ");
sql.AppendLine(",MoneyType ");
sql.AppendLine(",CurrencyType ");
sql.AppendLine(",CreditManage ");
sql.AppendLine(",MaxCredit ");
sql.AppendLine(",MaxCreditDate ");
//sql.AppendLine(",UpdateCredit ");
sql.AppendLine(",UsedStatus ");
sql.AppendLine(",Creator ");
sql.AppendLine(",CreatedDate ");
sql.AppendLine(",OpenBank ");
sql.AppendLine(",AccountMan ");
sql.AppendLine(",AccountNum ");
sql.AppendLine(",Remark) ");
sql.AppendLine(" values ");
sql.AppendLine("(@CompanyCD");
sql.AppendLine(",@CustType");
sql.AppendLine(",@CustClass ");
sql.AppendLine(",@CustNo ");
sql.AppendLine(",@CustName ");
sql.AppendLine(",@CustNam ");
sql.AppendLine(",@CustShort ");
sql.AppendLine(",@CreditGrade ");
sql.AppendLine(",@Manager ");
sql.AppendLine(",@AreaID ");
sql.AppendLine(",@CustNote ");
sql.AppendLine(",@LinkCycle ");
sql.AppendLine(",@HotIs ");
sql.AppendLine(",@HotHow ");
sql.AppendLine(",@HotType ");
sql.AppendLine(",@MeritGrade ");
sql.AppendLine(",@RelaGrade ");
sql.AppendLine(",@Relation ");
sql.AppendLine(",@CompanyType ");
sql.AppendLine(",@StaffCount ");
sql.AppendLine(",@Source ");
sql.AppendLine(",@Phase ");
sql.AppendLine(",@CustSupe ");
sql.AppendLine(",@Trade ");
sql.AppendLine(",@SetupDate ");
sql.AppendLine(",@ArtiPerson ");
sql.AppendLine(",@SetupMoney ");
sql.AppendLine(",@SetupAddress ");
sql.AppendLine(",@CapitalScale ");
sql.AppendLine(",@SaleroomY ");
sql.AppendLine(",@ProfitY ");
sql.AppendLine(",@TaxCD ");
sql.AppendLine(",@BusiNumber ");
sql.AppendLine(",@IsTax ");
sql.AppendLine(",@SellMode ");
sql.AppendLine(",@SellArea ");
sql.AppendLine(",@CountryID ");
sql.AppendLine(",@Province ");
sql.AppendLine(",@City ");
sql.AppendLine(",@Tel ");
sql.AppendLine(",@ContactName ");
sql.AppendLine(",@Mobile ");
sql.AppendLine(",@ReceiveAddress ");
sql.AppendLine(",@WebSite ");
sql.AppendLine(",@Post ");
sql.AppendLine(",@email ");
sql.AppendLine(",@Fax ");
sql.AppendLine(",@OnLine ");
sql.AppendLine(",@TakeType ");
sql.AppendLine(",@CarryType ");
sql.AppendLine(",@BusiType ");
sql.AppendLine(",@BillType ");
sql.AppendLine(",@PayType ");
sql.AppendLine(",@MoneyType ");
sql.AppendLine(",@CurrencyType ");
sql.AppendLine(",@CreditManage ");
sql.AppendLine(",@MaxCredit ");
sql.AppendLine(",@MaxCreditDate ");
//sql.AppendLine(",@UpdateCredit ");
sql.AppendLine(",@UsedStatus ");
sql.AppendLine(",@Creator ");
sql.AppendLine(",@CreatedDate ");
sql.AppendLine(",@OpenBank ");
sql.AppendLine(",@AccountMan ");
sql.AppendLine(",@AccountNum ");
sql.AppendLine(",@Remark) ");
#endregion
#region 设置添加客户信息参数
SqlParameter[] param = new SqlParameter[65];
param[0] = SqlHelper.GetParameter("@CompanyCD", CustInfoModel.CompanyCD);
param[1] = SqlHelper.GetParameter("@CustType", CustInfoModel.CustType);
param[2] = SqlHelper.GetParameter("@CustClass", CustInfoModel.CustClass);
param[3] = SqlHelper.GetParameter("@CustNo", CustInfoModel.CustNo);
param[4] = SqlHelper.GetParameter("@CustName", CustInfoModel.CustName);
param[5] = SqlHelper.GetParameter("@CustNam", CustInfoModel.CustNam);
param[6] = SqlHelper.GetParameter("@CustShort", CustInfoModel.CustShort);
param[7] = SqlHelper.GetParameter("@CreditGrade", CustInfoModel.CreditGrade);
param[8] = SqlHelper.GetParameter("@Manager", CustInfoModel.Seller);
param[9] = SqlHelper.GetParameter("@AreaID", CustInfoModel.AreaID);
param[10] = SqlHelper.GetParameter("@CustNote", CustInfoModel.CustNote);
param[11] = SqlHelper.GetParameter("@LinkCycle", CustInfoModel.LinkCycle);
param[12] = SqlHelper.GetParameter("@HotIs", CustInfoModel.HotIs);
param[13] = SqlHelper.GetParameter("@HotHow", CustInfoModel.HotHow);
param[14] = SqlHelper.GetParameter("@HotType", CustInfoModel.HotType);
param[15] = SqlHelper.GetParameter("@MeritGrade", CustInfoModel.MeritGrade);
param[16] = SqlHelper.GetParameter("@RelaGrade", CustInfoModel.RelaGrade);
param[17] = SqlHelper.GetParameter("@Relation", CustInfoModel.Relation);
param[18] = SqlHelper.GetParameter("@CompanyType", CustInfoModel.CompanyType);
param[19] = SqlHelper.GetParameter("@StaffCount", CustInfoModel.StaffCount);
param[20] = SqlHelper.GetParameter("@Source", CustInfoModel.Source);
param[21] = SqlHelper.GetParameter("@Phase", CustInfoModel.Phase);
param[22] = SqlHelper.GetParameter("@CustSupe", CustInfoModel.CustSupe);
param[23] = SqlHelper.GetParameter("@Trade", CustInfoModel.Trade);
param[24] = SqlHelper.GetParameter("@SetupDate", CustInfoModel.SetupDate == null
? SqlDateTime.Null
: SqlDateTime.Parse(CustInfoModel.SetupDate.ToString()));
param[25] = SqlHelper.GetParameter("@ArtiPerson", CustInfoModel.ArtiPerson);
param[26] = SqlHelper.GetParameter("@SetupMoney", CustInfoModel.SetupMoney);
param[27] = SqlHelper.GetParameter("@SetupAddress", CustInfoModel.SetupAddress);
param[28] = SqlHelper.GetParameter("@CapitalScale", CustInfoModel.CapitalScale);
param[29] = SqlHelper.GetParameter("@SaleroomY", CustInfoModel.SaleroomY);
param[30] = SqlHelper.GetParameter("@ProfitY", CustInfoModel.ProfitY);
param[31] = SqlHelper.GetParameter("@TaxCD", CustInfoModel.TaxCD);
param[32] = SqlHelper.GetParameter("@BusiNumber", CustInfoModel.BusiNumber);
param[33] = SqlHelper.GetParameter("@IsTax", CustInfoModel.IsTax);
param[34] = SqlHelper.GetParameter("@SellMode", CustInfoModel.SellMode);
param[35] = SqlHelper.GetParameter("@SellArea", CustInfoModel.SellArea);
param[36] = SqlHelper.GetParameter("@CountryID", CustInfoModel.CountryID);
param[37] = SqlHelper.GetParameter("@Province", CustInfoModel.Province);
param[38] = SqlHelper.GetParameter("@City", CustInfoModel.City);
param[39] = SqlHelper.GetParameter("@Tel", CustInfoModel.Tel);
param[40] = SqlHelper.GetParameter("@ContactName", CustInfoModel.ContactName);
param[41] = SqlHelper.GetParameter("@Mobile", CustInfoModel.Mobile);
param[42] = SqlHelper.GetParameter("@ReceiveAddress", CustInfoModel.ReceiveAddress);
param[43] = SqlHelper.GetParameter("@WebSite", CustInfoModel.WebSite);
param[44] = SqlHelper.GetParameter("@Post", CustInfoModel.Post);
param[45] = SqlHelper.GetParameter("@email", CustInfoModel.email);
param[46] = SqlHelper.GetParameter("@Fax", CustInfoModel.Fax);
param[47] = SqlHelper.GetParameter("@OnLine", CustInfoModel.OnLine);
param[48] = SqlHelper.GetParameter("@TakeType", CustInfoModel.TakeType);
param[49] = SqlHelper.GetParameter("@CarryType", CustInfoModel.CarryType);
param[50] = SqlHelper.GetParameter("@BusiType", CustInfoModel.BusiType);
param[51] = SqlHelper.GetParameter("@BillType", CustInfoModel.BillType);
param[52] = SqlHelper.GetParameter("@PayType", CustInfoModel.PayType);
param[53] = SqlHelper.GetParameter("@MoneyType", CustInfoModel.MoneyType);
param[54] = SqlHelper.GetParameter("@CurrencyType", CustInfoModel.CurrencyType);
param[55] = SqlHelper.GetParameter("@CreditManage", CustInfoModel.CreditManage);
param[56] = SqlHelper.GetParameter("@MaxCredit", CustInfoModel.MaxCredit);
param[57] = SqlHelper.GetParameter("@MaxCreditDate", CustInfoModel.MaxCreditDate);
param[58] = SqlHelper.GetParameter("@UsedStatus", CustInfoModel.UsedStatus);
param[59] = SqlHelper.GetParameter("@Creator", CustInfoModel.Creator);
param[60] = SqlHelper.GetParameter("@CreatedDate", CustInfoModel.CreatedDate == null
? SqlDateTime.Null
: SqlDateTime.Parse(CustInfoModel.CreatedDate.ToString()));
param[61] = SqlHelper.GetParameter("@OpenBank", CustInfoModel.OpenBank);
param[62] = SqlHelper.GetParameter("@AccountMan", CustInfoModel.AccountMan);
param[63] = SqlHelper.GetParameter("@AccountNum", CustInfoModel.AccountNum);
param[64] = SqlHelper.GetParameter("@Remark", CustInfoModel.Remark);
#endregion
LinkManModel LinkManM = new LinkManModel();
string[] strlinkman = LinkManlist.Split('|'); //把联系人列表流分隔成数组
SqlCommand[] comms = new SqlCommand[strlinkman.Length]; //申明cmd数组
SqlCommand cmdcust = new SqlCommand(sql.ToString()); //未执行的客户信息添加命令
cmdcust.Parameters.AddRange(param);
comms[0] = cmdcust; //把未执行的客户信息添加命令给cmd数组第一项
string recorditems = "";
string[] linkmanfield = null;
for (int i = 1; i < strlinkman.Length; i++) //循环数组
{
recorditems = strlinkman[i].ToString();//取到每一条记录:[序号,联系人姓名,手机,工作电话,职位,负责业务]
linkmanfield = recorditems.Split(','); //把每条记录分隔到字段
string fieldxh = linkmanfield[0].ToString();//序号
string fieldname = linkmanfield[1].ToString();//联系人姓名
string fieldhandset = linkmanfield[2].ToString();//手机
string fieldworktel = linkmanfield[3].ToString();//工作电话
string fieldposition = linkmanfield[4].ToString();//职务
string fieldoperation = linkmanfield[5].ToString();//负责业务
LinkManM.CompanyCD = CustInfoModel.CompanyCD; //联系人信息赋予一个LinkManM(联系人Model对象实例)
LinkManM.CustNo = CustInfoModel.CustNo;
LinkManM.LinkManName = fieldname;
LinkManM.Handset = fieldhandset;
LinkManM.WorkTel = fieldworktel;
LinkManM.Position = fieldposition;
LinkManM.Operation = fieldoperation;
LinkManM.ModifiedDate = DateTime.Now;
LinkManM.ModifiedUserID = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).UserID;//Session读取当前用户ID
#region 拼写添加联系人信息sql语句
StringBuilder sqllinkman = new StringBuilder();
sqllinkman.AppendLine("INSERT INTO officedba.CustLinkMan");
sqllinkman.AppendLine("(CompanyCD");
sqllinkman.AppendLine(",CustNo ");
sqllinkman.AppendLine(",LinkManName");
sqllinkman.AppendLine(",Position ");
sqllinkman.AppendLine(",Operation ");
sqllinkman.AppendLine(",WorkTel ");
sqllinkman.AppendLine(",Handset ");
sqllinkman.AppendLine(",ModifiedDate");
sqllinkman.AppendLine(",ModifiedUserID)");
sqllinkman.AppendLine(" values ");
sqllinkman.AppendLine("(@CompanyCD");
sqllinkman.AppendLine(",@CustNo ");
sqllinkman.AppendLine(",@LinkManName");
sqllinkman.AppendLine(",@Position ");
sqllinkman.AppendLine(",@Operation ");
sqllinkman.AppendLine(",@WorkTel ");
sqllinkman.AppendLine(",@Handset ");
sqllinkman.AppendLine(",@ModifiedDate");
sqllinkman.AppendLine(",@ModifiedUserID)");
#endregion
#region 设置参数
SqlParameter[] paramlinkman = new SqlParameter[9];
paramlinkman[0] = SqlHelper.GetParameter("@CompanyCD", CustInfoModel.CompanyCD);
paramlinkman[1] = SqlHelper.GetParameter("@CustNo", CustInfoModel.CustNo);
paramlinkman[2] = SqlHelper.GetParameter("@LinkManName", LinkManM.LinkManName);
paramlinkman[3] = SqlHelper.GetParameter("@Position", LinkManM.Position);
paramlinkman[4] = SqlHelper.GetParameter("@Operation", LinkManM.Operation);
paramlinkman[5] = SqlHelper.GetParameter("@WorkTel", LinkManM.WorkTel);
paramlinkman[6] = SqlHelper.GetParameter("@Handset", LinkManM.Handset);
paramlinkman[7] = SqlHelper.GetParameter("@ModifiedDate", LinkManM.ModifiedDate);
paramlinkman[8] = SqlHelper.GetParameter("@ModifiedUserID", LinkManM.ModifiedUserID);
#endregion
SqlCommand cmdlinkman = new SqlCommand(sqllinkman.ToString()); //未执行的联系人信息添加命令
cmdlinkman.Parameters.AddRange(paramlinkman);
comms[i] = cmdlinkman; //把未执行的联系人信息添加命令给cmd数组
}
//执行
SqlHelper.ExecuteTransForList(comms);
return SqlHelper.Result.OprateCount > 0 ? true : false;
}
catch
{
return false;
}
}
/// <summary>
/// 添加客户信息的方法
/// </summary>
/// <param name="CustInfoModel">客户信息</param>
/// <returns>bool值</returns>
public static bool CustInfoAdd(CustInfoModel CustInfoModel,LinkManModel LinkManM, Hashtable htExtAttr)
{
try
{
#region 拼写SQL语句
StringBuilder sql = new StringBuilder();
sql.AppendLine("INSERT INTO officedba.CustInfo");
sql.AppendLine("(CompanyCD");
sql.AppendLine(",CustTypeManage");
sql.AppendLine(",CustTypeSell");
sql.AppendLine(",CustTypeTime");
sql.AppendLine(",CustType");
sql.AppendLine(",CustClass ");
sql.AppendLine(",CustNo ");
sql.AppendLine(",CustName ");
sql.AppendLine(",CustNam ");
sql.AppendLine(",CustShort ");
sql.AppendLine(",CreditGrade ");
sql.AppendLine(",Manager ");
sql.AppendLine(",AreaID ");
sql.AppendLine(",CustNote ");
sql.AppendLine(",LinkCycle ");
sql.AppendLine(",HotIs ");
sql.AppendLine(",HotHow ");
sql.AppendLine(",MeritGrade ");
sql.AppendLine(",RelaGrade ");
sql.AppendLine(",Relation ");
sql.AppendLine(",CompanyType ");
sql.AppendLine(",StaffCount ");
sql.AppendLine(",Source ");
sql.AppendLine(",Phase ");
sql.AppendLine(",CustSupe ");
sql.AppendLine(",Trade ");
sql.AppendLine(",SetupDate ");
sql.AppendLine(",ArtiPerson ");
sql.AppendLine(",SetupMoney ");
sql.AppendLine(",SetupAddress ");
sql.AppendLine(",CapitalScale ");
sql.AppendLine(",SaleroomY ");
sql.AppendLine(",ProfitY ");
sql.AppendLine(",TaxCD ");
sql.AppendLine(",BusiNumber ");
sql.AppendLine(",IsTax ");
sql.AppendLine(",SellMode ");
sql.AppendLine(",SellArea ");
sql.AppendLine(",CountryID ");
sql.AppendLine(",Province ");
sql.AppendLine(",City ");
sql.AppendLine(",Tel ");
sql.AppendLine(",ContactName ");
sql.AppendLine(",Mobile ");
sql.AppendLine(",ReceiveAddress ");
sql.AppendLine(",WebSite ");
sql.AppendLine(",Post ");
sql.AppendLine(",email ");
sql.AppendLine(",Fax ");
sql.AppendLine(",OnLine ");
sql.AppendLine(",TakeType ");
sql.AppendLine(",CarryType ");
sql.AppendLine(",BusiType ");
sql.AppendLine(",BillType ");
sql.AppendLine(",PayType ");
sql.AppendLine(",MoneyType ");
sql.AppendLine(",CurrencyType ");
sql.AppendLine(",CreditManage ");
sql.AppendLine(",MaxCredit ");
sql.AppendLine(",MaxCreditDate ");
sql.AppendLine(",UsedStatus ");
sql.AppendLine(",CanViewUser ");
sql.AppendLine(",CanViewUserName ");
sql.AppendLine(",Creator ");
sql.AppendLine(",CreatedDate ");
sql.AppendLine(",FirstBuyDate ");
sql.AppendLine(",OpenBank ");
sql.AppendLine(",AccountMan ");
sql.AppendLine(",AccountNum ");
sql.AppendLine(",ModifiedUserID ");
sql.AppendLine(",CompanyValues ");
sql.AppendLine(",CatchWord ");
sql.AppendLine(",ManageValues ");
sql.AppendLine(",Potential ");
sql.AppendLine(",Problem ");
sql.AppendLine(",Advantages ");
sql.AppendLine(",TradePosition ");
sql.AppendLine(",Competition ");
sql.AppendLine(",Collaborator ");
sql.AppendLine(",ManagePlan ");
sql.AppendLine(",Collaborate ");
sql.AppendLine(",CustBig ");
sql.AppendLine(",CustNum ");
sql.AppendLine(",Remark) ");
sql.AppendLine(" values ");
sql.AppendLine("(@CompanyCD");
sql.AppendLine(",@CustTypeManage");
sql.AppendLine(",@CustTypeSell");
sql.AppendLine(",@CustTypeTime");
sql.AppendLine(",@CustType");
sql.AppendLine(",@CustClass ");
sql.AppendLine(",@CustNo ");
sql.AppendLine(",@CustName ");
sql.AppendLine(",@CustNam ");
sql.AppendLine(",@CustShort ");
sql.AppendLine(",@CreditGrade ");
sql.AppendLine(",@Manager ");
sql.AppendLine(",@AreaID ");
sql.AppendLine(",@CustNote ");
sql.AppendLine(",@LinkCycle ");
sql.AppendLine(",@HotIs ");
sql.AppendLine(",@HotHow ");
sql.AppendLine(",@MeritGrade ");
sql.AppendLine(",@RelaGrade ");
sql.AppendLine(",@Relation ");
sql.AppendLine(",@CompanyType ");
sql.AppendLine(",@StaffCount ");
sql.AppendLine(",@Source ");
sql.AppendLine(",@Phase ");
sql.AppendLine(",@CustSupe ");
sql.AppendLine(",@Trade ");
sql.AppendLine(",@SetupDate ");
sql.AppendLine(",@ArtiPerson ");
sql.AppendLine(",@SetupMoney ");
sql.AppendLine(",@SetupAddress ");
sql.AppendLine(",@CapitalScale ");
sql.AppendLine(",@SaleroomY ");
sql.AppendLine(",@ProfitY ");
sql.AppendLine(",@TaxCD ");
sql.AppendLine(",@BusiNumber ");
sql.AppendLine(",@IsTax ");
sql.AppendLine(",@SellMode ");
sql.AppendLine(",@SellArea ");
sql.AppendLine(",@CountryID ");
sql.AppendLine(",@Province ");
sql.AppendLine(",@City ");
sql.AppendLine(",@Tel ");
sql.AppendLine(",@ContactName ");
sql.AppendLine(",@Mobile ");
sql.AppendLine(",@ReceiveAddress ");
sql.AppendLine(",@WebSite ");
sql.AppendLine(",@Post ");
sql.AppendLine(",@email ");
sql.AppendLine(",@Fax ");
sql.AppendLine(",@OnLine ");
sql.AppendLine(",@TakeType ");
sql.AppendLine(",@CarryType ");
sql.AppendLine(",@BusiType ");
sql.AppendLine(",@BillType ");
sql.AppendLine(",@PayType ");
sql.AppendLine(",@MoneyType ");
sql.AppendLine(",@CurrencyType ");
sql.AppendLine(",@CreditManage ");
sql.AppendLine(",@MaxCredit ");
sql.AppendLine(",@MaxCreditDate ");
sql.AppendLine(",@UsedStatus ");
sql.AppendLine(",@CanViewUser ");
sql.AppendLine(",@CanViewUserName ");
sql.AppendLine(",@Creator ");
sql.AppendLine(",@CreatedDate ");
sql.AppendLine(",@FirstBuyDate ");
sql.AppendLine(",@OpenBank ");
sql.AppendLine(",@AccountMan ");
sql.AppendLine(",@AccountNum ");
sql.AppendLine(",@ModifiedUserID ");
sql.AppendLine(",@CompanyValues ");
sql.AppendLine(",@CatchWord ");
sql.AppendLine(",@ManageValues ");
sql.AppendLine(",@Potential ");
sql.AppendLine(",@Problem ");
sql.AppendLine(",@Advantages ");
sql.AppendLine(",@TradePosition ");
sql.AppendLine(",@Competition ");
sql.AppendLine(",@Collaborator ");
sql.AppendLine(",@ManagePlan ");
sql.AppendLine(",@Collaborate ");
sql.AppendLine(",@CustBig ");
sql.AppendLine(",@CustNum ");
sql.AppendLine(",@Remark) ");
#endregion
#region 设置参数
SqlCommand mycomm = new SqlCommand();
mycomm.Parameters.Add(SqlHelper.GetParameter("@CompanyCD", CustInfoModel.CompanyCD));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CustType", CustInfoModel.CustType));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CustClass", CustInfoModel.CustClass));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CustNo", CustInfoModel.CustNo));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CustName", CustInfoModel.CustName));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CustNam", CustInfoModel.CustNam));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CustShort", CustInfoModel.CustShort));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CreditGrade", CustInfoModel.CreditGrade));
mycomm.Parameters.Add(SqlHelper.GetParameter("@Manager", CustInfoModel.Seller));
mycomm.Parameters.Add(SqlHelper.GetParameter("@AreaID", CustInfoModel.AreaID));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CustNote", CustInfoModel.CustNote));
mycomm.Parameters.Add(SqlHelper.GetParameter("@LinkCycle", CustInfoModel.LinkCycle));
mycomm.Parameters.Add(SqlHelper.GetParameter("@HotIs", CustInfoModel.HotIs));
mycomm.Parameters.Add(SqlHelper.GetParameter("@HotHow", CustInfoModel.HotHow));
mycomm.Parameters.Add(SqlHelper.GetParameter("@MeritGrade", CustInfoModel.MeritGrade));
mycomm.Parameters.Add(SqlHelper.GetParameter("@RelaGrade", CustInfoModel.RelaGrade));
mycomm.Parameters.Add(SqlHelper.GetParameter("@Relation", CustInfoModel.Relation));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CompanyType", CustInfoModel.CompanyType));
mycomm.Parameters.Add(SqlHelper.GetParameter("@StaffCount", CustInfoModel.StaffCount));
mycomm.Parameters.Add(SqlHelper.GetParameter("@Source", CustInfoModel.Source));
mycomm.Parameters.Add(SqlHelper.GetParameter("@Phase", CustInfoModel.Phase));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CustSupe", CustInfoModel.CustSupe));
mycomm.Parameters.Add(SqlHelper.GetParameter("@Trade", CustInfoModel.Trade));
mycomm.Parameters.Add(SqlHelper.GetParameter("@SetupDate", CustInfoModel.SetupDate == null
? SqlDateTime.Null
: SqlDateTime.Parse(CustInfoModel.SetupDate.ToString())));
mycomm.Parameters.Add(SqlHelper.GetParameter("@ArtiPerson", CustInfoModel.ArtiPerson));
mycomm.Parameters.Add(SqlHelper.GetParameter("@SetupMoney", CustInfoModel.SetupMoney));
mycomm.Parameters.Add(SqlHelper.GetParameter("@SetupAddress", CustInfoModel.SetupAddress));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CapitalScale", CustInfoModel.CapitalScale));
mycomm.Parameters.Add(SqlHelper.GetParameter("@SaleroomY", CustInfoModel.SaleroomY));
mycomm.Parameters.Add(SqlHelper.GetParameter("@ProfitY", CustInfoModel.ProfitY));
mycomm.Parameters.Add(SqlHelper.GetParameter("@TaxCD", CustInfoModel.TaxCD));
mycomm.Parameters.Add(SqlHelper.GetParameter("@BusiNumber", CustInfoModel.BusiNumber));
mycomm.Parameters.Add(SqlHelper.GetParameter("@IsTax", CustInfoModel.IsTax));
mycomm.Parameters.Add(SqlHelper.GetParameter("@SellMode", CustInfoModel.SellMode));
mycomm.Parameters.Add(SqlHelper.GetParameter("@SellArea", CustInfoModel.SellArea));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CountryID", CustInfoModel.CountryID));
mycomm.Parameters.Add(SqlHelper.GetParameter("@Province", CustInfoModel.Province));
mycomm.Parameters.Add(SqlHelper.GetParameter("@City", CustInfoModel.City));
mycomm.Parameters.Add(SqlHelper.GetParameter("@Tel", CustInfoModel.Tel));
mycomm.Parameters.Add(SqlHelper.GetParameter("@ContactName", CustInfoModel.ContactName));
mycomm.Parameters.Add(SqlHelper.GetParameter("@Mobile", CustInfoModel.Mobile));
mycomm.Parameters.Add(SqlHelper.GetParameter("@ReceiveAddress", CustInfoModel.ReceiveAddress));
mycomm.Parameters.Add(SqlHelper.GetParameter("@WebSite", CustInfoModel.WebSite));
mycomm.Parameters.Add(SqlHelper.GetParameter("@Post", CustInfoModel.Post));
mycomm.Parameters.Add(SqlHelper.GetParameter("@email", CustInfoModel.email));
mycomm.Parameters.Add(SqlHelper.GetParameter("@Fax", CustInfoModel.Fax));
mycomm.Parameters.Add(SqlHelper.GetParameter("@OnLine", CustInfoModel.OnLine));
mycomm.Parameters.Add(SqlHelper.GetParameter("@TakeType", CustInfoModel.TakeType));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CarryType", CustInfoModel.CarryType));
mycomm.Parameters.Add(SqlHelper.GetParameter("@BusiType", CustInfoModel.BusiType));
mycomm.Parameters.Add(SqlHelper.GetParameter("@BillType", CustInfoModel.BillType));
mycomm.Parameters.Add(SqlHelper.GetParameter("@PayType", CustInfoModel.PayType));
mycomm.Parameters.Add(SqlHelper.GetParameter("@MoneyType", CustInfoModel.MoneyType));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CurrencyType", CustInfoModel.CurrencyType));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CreditManage", CustInfoModel.CreditManage));
mycomm.Parameters.Add(SqlHelper.GetParameter("@MaxCredit", CustInfoModel.MaxCredit));
mycomm.Parameters.Add(SqlHelper.GetParameter("@MaxCreditDate", CustInfoModel.MaxCreditDate));
mycomm.Parameters.Add(SqlHelper.GetParameter("@UsedStatus", CustInfoModel.UsedStatus));
mycomm.Parameters.Add(SqlHelper.GetParameter("@Creator", CustInfoModel.Creator));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CreatedDate", CustInfoModel.CreatedDate == null
? SqlDateTime.Null
: SqlDateTime.Parse(CustInfoModel.CreatedDate.ToString())));
mycomm.Parameters.Add(SqlHelper.GetParameter("@OpenBank", CustInfoModel.OpenBank));
mycomm.Parameters.Add(SqlHelper.GetParameter("@AccountMan", CustInfoModel.AccountMan));
mycomm.Parameters.Add(SqlHelper.GetParameter("@AccountNum", CustInfoModel.AccountNum));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CustBig", CustInfoModel.CustBig));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CustNum", CustInfoModel.CustNum));
mycomm.Parameters.Add(SqlHelper.GetParameter("@Remark", CustInfoModel.Remark));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CustTypeManage", CustInfoModel.CustTypeManage));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CustTypeSell", CustInfoModel.CustTypeSell));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CustTypeTime", CustInfoModel.CustTypeTime));
mycomm.Parameters.Add(SqlHelper.GetParameter("@FirstBuyDate", CustInfoModel.FirstBuyDate == null
? SqlDateTime.Null
: SqlDateTime.Parse(CustInfoModel.FirstBuyDate.ToString())));
mycomm.Parameters.Add(SqlHelper.GetParameter("@ModifiedUserID", CustInfoModel.ModifiedUserID));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CanViewUser", CustInfoModel.CanViewUser));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CanViewUserName", CustInfoModel.CanViewUserName));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CompanyValues", CustInfoModel.CompanyValues));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CatchWord", CustInfoModel.CatchWord));
mycomm.Parameters.Add(SqlHelper.GetParameter("@ManageValues", CustInfoModel.ManageValues));
mycomm.Parameters.Add(SqlHelper.GetParameter("@Potential", CustInfoModel.Potential));
mycomm.Parameters.Add(SqlHelper.GetParameter("@Problem", CustInfoModel.Problem));
mycomm.Parameters.Add(SqlHelper.GetParameter("@Advantages", CustInfoModel.Advantages));
mycomm.Parameters.Add(SqlHelper.GetParameter("@TradePosition", CustInfoModel.TradePosition));
mycomm.Parameters.Add(SqlHelper.GetParameter("@Competition", CustInfoModel.Competition));
mycomm.Parameters.Add(SqlHelper.GetParameter("@Collaborator", CustInfoModel.Collaborator));
mycomm.Parameters.Add(SqlHelper.GetParameter("@ManagePlan", CustInfoModel.ManagePlan));
mycomm.Parameters.Add(SqlHelper.GetParameter("@Collaborate", CustInfoModel.Collaborate));
mycomm.CommandText = sql.ToString();
#endregion
ArrayList lstCmd = new ArrayList();
SqlCommand cmd = new SqlCommand();
GetExtAttrCmd(CustInfoModel, htExtAttr, cmd);
lstCmd.Add(mycomm);//基本信息
if (htExtAttr != null)//扩展信息
lstCmd.Add(cmd);
if (CustInfoModel.CustBig == "2")//当选择会员客户时,插入信息到联系人表
{
SqlCommand cmdLinkMan = new SqlCommand();
StringBuilder sqlLinkMan = new StringBuilder();
sqlLinkMan.AppendLine(" insert into officedba.CustLinkMan ");
sqlLinkMan.AppendLine(" ( CompanyCD,CustNo,LinkManName,Sex,LinkType,PaperNum,Birthday,WorkTel,Handset,Fax,Position, ");
sqlLinkMan.AppendLine(" Important, ");
sqlLinkMan.AppendLine(" Age,Post,MailAddress,HomeTown,NationalID,CultureLevel,Professional,IncomeYear,FuoodDrink, ");
sqlLinkMan.AppendLine(" LoveMusic,LoveColor,LoveSmoke,LoveDrink,LoveTea,LoveBook,LoveSport,LoveClothes,Cosmetic, ");
sqlLinkMan.AppendLine(" Nature,Appearance,AdoutBody,AboutFamily,Car,CanViewUser,CanViewUserName,Creator,CreatedDate ) values ");
sqlLinkMan.AppendLine(" ( @CompanyCD,@CustNo,@LinkManName,@Sex,@LinkType,@PaperNum,@Birthday,@WorkTel,@Handset,@Fax,@Position, ");
sqlLinkMan.AppendLine(" '0',");
sqlLinkMan.AppendLine(" @Age,@Post,@MailAddress,@HomeTown,@NationalID,@CultureLevel,@Professional,@IncomeYear,@FuoodDrink, ");
sqlLinkMan.AppendLine(" @LoveMusic,@LoveColor,@LoveSmoke,@LoveDrink,@LoveTea,@LoveBook,@LoveSport,@LoveClothes,@Cosmetic, ");
sqlLinkMan.AppendLine(" @Nature,@Appearance,@AdoutBody,@AboutFamily,@Car,@CanViewUser,@CanViewUserName,@Creator,@CreatedDate ) ");
#region 设置联系人参数
SqlCommand commLinkMan = new SqlCommand();
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@CompanyCD", CustInfoModel.CompanyCD));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@CustNo", CustInfoModel.CustNo));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@LinkManName", CustInfoModel.CustName));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@Sex", LinkManM.Sex));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@LinkType", LinkManM.LinkType));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@PaperNum", LinkManM.PaperNum));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@Birthday", LinkManM.Birthday == null ? SqlDateTime.Null : SqlDateTime.Parse(LinkManM.Birthday.ToString())));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@WorkTel", LinkManM.WorkTel));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@Handset", LinkManM.Handset));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@Fax", LinkManM.Fax));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@Position", LinkManM.Position));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@Age", LinkManM.Age));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@Post", LinkManM.Post));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@MailAddress", LinkManM.MailAddress));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@HomeTown", LinkManM.HomeTown));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@NationalID", LinkManM.NationalID));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@CultureLevel", LinkManM.CultureLevel));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@Professional", LinkManM.Professional));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@IncomeYear", LinkManM.IncomeYear));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@FuoodDrink", LinkManM.FuoodDrink));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@LoveMusic", LinkManM.LoveMusic));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@LoveColor", LinkManM.LoveColor));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@LoveSmoke", LinkManM.LoveSmoke));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@LoveDrink", LinkManM.LoveDrink));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@LoveTea", LinkManM.LoveTea));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@LoveBook", LinkManM.LoveBook));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@LoveSport", LinkManM.LoveSport));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@LoveClothes", LinkManM.LoveClothes));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@Cosmetic", LinkManM.Cosmetic));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@Nature", LinkManM.Nature));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@Appearance", LinkManM.Appearance));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@AdoutBody", LinkManM.AdoutBody));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@AboutFamily", LinkManM.AboutFamily));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@Car", LinkManM.Car));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@CanViewUser", CustInfoModel.CanViewUser));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@CanViewUserName", CustInfoModel.CanViewUserName));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@Creator", CustInfoModel.Creator));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@CreatedDate", CustInfoModel.CreatedDate == null
? SqlDateTime.Null
: SqlDateTime.Parse(CustInfoModel.CreatedDate.ToString())));
commLinkMan.CommandText = sqlLinkMan.ToString();
#endregion
lstCmd.Add(commLinkMan);
}
//执行登陆操作
bool isSucc = SqlHelper.ExecuteTransWithArrayList(lstCmd);
return isSucc;
}
catch
{
return false;
}
}
/// <summary>
/// 同时修改客户信息及联系人列表信息的方法
/// </summary>
/// <param name="CustInfoModel">客户信息Model</param>
/// <param name="LinkManlist">联系人列表信息流</param>
/// <returns>bool值</returns>
public static bool UpdateCustAndLinkMan(CustInfoModel CustInfoModel, string LinkManlist)
{
try
{
#region 拼写修改客户信息SQL语句
StringBuilder sqlcust = new StringBuilder();
sqlcust.AppendLine("UPDATE officedba.CustInfo set ");
sqlcust.AppendLine("CompanyCD= @CompanyCD, ");
sqlcust.AppendLine("CustType= @CustType, ");
sqlcust.AppendLine("CustClass = @CustClass , ");
//sqlcust.AppendLine("CustNo = @CustNo , ");
sqlcust.AppendLine("CustName = @CustName , ");
sqlcust.AppendLine("CustNam = @CustNam , ");
sqlcust.AppendLine("CustShort = @CustShort , ");
sqlcust.AppendLine("CreditGrade = @CreditGrade , ");
sqlcust.AppendLine("Manager = @Manager , ");
sqlcust.AppendLine("AreaID = @AreaID , ");
sqlcust.AppendLine("CustNote = @CustNote , ");
sqlcust.AppendLine("LinkCycle = @LinkCycle , ");
sqlcust.AppendLine("HotIs = @HotIs , ");
sqlcust.AppendLine("HotHow = @HotHow , ");
sqlcust.AppendLine("HotType = @HotType , ");
sqlcust.AppendLine("MeritGrade = @MeritGrade , ");
sqlcust.AppendLine("RelaGrade = @RelaGrade , ");
sqlcust.AppendLine("Relation = @Relation , ");
sqlcust.AppendLine("CompanyType = @CompanyType , ");
sqlcust.AppendLine("StaffCount = @StaffCount , ");
sqlcust.AppendLine("Source = @Source , ");
sqlcust.AppendLine("Phase = @Phase , ");
sqlcust.AppendLine("CustSupe = @CustSupe , ");
sqlcust.AppendLine("Trade = @Trade , ");
sqlcust.AppendLine("SetupDate = @SetupDate , ");
sqlcust.AppendLine("ArtiPerson = @ArtiPerson , ");
sqlcust.AppendLine("SetupMoney = @SetupMoney , ");
sqlcust.AppendLine("SetupAddress = @SetupAddress , ");
sqlcust.AppendLine("CapitalScale = @CapitalScale , ");
sqlcust.AppendLine("SaleroomY = @SaleroomY , ");
sqlcust.AppendLine("ProfitY = @ProfitY , ");
sqlcust.AppendLine("TaxCD = @TaxCD , ");
sqlcust.AppendLine("BusiNumber = @BusiNumber , ");
sqlcust.AppendLine("IsTax = @IsTax , ");
sqlcust.AppendLine("SellMode = @SellMode , ");
sqlcust.AppendLine("SellArea = @SellArea , ");
sqlcust.AppendLine("CountryID = @CountryID , ");
sqlcust.AppendLine("Province = @Province , ");
sqlcust.AppendLine("City = @City , ");
sqlcust.AppendLine("Tel = @Tel , ");
sqlcust.AppendLine("ContactName = @ContactName , ");
sqlcust.AppendLine("Mobile = @Mobile , ");
sqlcust.AppendLine("ReceiveAddress = @ReceiveAddress , ");
sqlcust.AppendLine("WebSite = @WebSite , ");
sqlcust.AppendLine("Post = @Post , ");
sqlcust.AppendLine("email = @email , ");
sqlcust.AppendLine("Fax = @Fax , ");
sqlcust.AppendLine("OnLine = @OnLine , ");
sqlcust.AppendLine("TakeType = @TakeType , ");
sqlcust.AppendLine("CarryType = @CarryType , ");
sqlcust.AppendLine("BusiType = @BusiType , ");
sqlcust.AppendLine("BillType = @BillType , ");
sqlcust.AppendLine("PayType = @PayType , ");
sqlcust.AppendLine("MoneyType = @MoneyType , ");
sqlcust.AppendLine("CurrencyType = @CurrencyType , ");
sqlcust.AppendLine("CreditManage = @CreditManage , ");
sqlcust.AppendLine("MaxCredit = @MaxCredit , ");
sqlcust.AppendLine("MaxCreditDate = @MaxCreditDate , ");
//sqlcust.AppendLine("UpdateCredit = @UpdateCredit , ");
sqlcust.AppendLine("UsedStatus = @UsedStatus , ");
sqlcust.AppendLine("Creator = @Creator , ");
sqlcust.AppendLine("CreatedDate = @CreatedDate , ");
sqlcust.AppendLine("OpenBank = @OpenBank , ");
sqlcust.AppendLine("AccountMan = @AccountMan , ");
sqlcust.AppendLine("AccountNum = @AccountNum , ");
sqlcust.AppendLine("Remark = @Remark, ");
sqlcust.AppendLine("CustBig = @CustBig, ");
sqlcust.AppendLine("CustNum = @CustNum, ");
sqlcust.AppendLine("ModifiedDate = @ModifiedDate, ");
sqlcust.AppendLine("ModifiedUserID = @ModifiedUserID ");
sqlcust.AppendLine(" WHERE ");
sqlcust.AppendLine("CustNo = @CustNo ");
#endregion
#region 设置修改客户信息参数
SqlParameter[] param = new SqlParameter[69];
param[0] = SqlHelper.GetParameter("@CompanyCD", CustInfoModel.CompanyCD);
param[1] = SqlHelper.GetParameter("@CustType", CustInfoModel.CustType);
param[2] = SqlHelper.GetParameter("@CustClass", CustInfoModel.CustClass);
param[3] = SqlHelper.GetParameter("@CustNo", CustInfoModel.CustNo);
param[4] = SqlHelper.GetParameter("@CustName", CustInfoModel.CustName);
param[5] = SqlHelper.GetParameter("@CustNam", CustInfoModel.CustNam);
param[6] = SqlHelper.GetParameter("@CustShort", CustInfoModel.CustShort);
param[7] = SqlHelper.GetParameter("@CreditGrade", CustInfoModel.CreditGrade);
param[8] = SqlHelper.GetParameter("@Manager", CustInfoModel.Seller);
param[9] = SqlHelper.GetParameter("@AreaID", CustInfoModel.AreaID);
param[10] = SqlHelper.GetParameter("@CustNote", CustInfoModel.CustNote);
param[11] = SqlHelper.GetParameter("@LinkCycle", CustInfoModel.LinkCycle);
param[12] = SqlHelper.GetParameter("@HotIs", CustInfoModel.HotIs);
param[13] = SqlHelper.GetParameter("@HotHow", CustInfoModel.HotHow);
param[14] = SqlHelper.GetParameter("@HotType", CustInfoModel.HotType);
param[15] = SqlHelper.GetParameter("@MeritGrade", CustInfoModel.MeritGrade);
param[16] = SqlHelper.GetParameter("@RelaGrade", CustInfoModel.RelaGrade);
param[17] = SqlHelper.GetParameter("@Relation", CustInfoModel.Relation);
param[18] = SqlHelper.GetParameter("@CompanyType", CustInfoModel.CompanyType);
param[19] = SqlHelper.GetParameter("@StaffCount", CustInfoModel.StaffCount);
param[20] = SqlHelper.GetParameter("@Source", CustInfoModel.Source);
param[21] = SqlHelper.GetParameter("@Phase", CustInfoModel.Phase);
param[22] = SqlHelper.GetParameter("@CustSupe", CustInfoModel.CustSupe);
param[23] = SqlHelper.GetParameter("@Trade", CustInfoModel.Trade);
param[24] = SqlHelper.GetParameter("@SetupDate", CustInfoModel.SetupDate == null
? SqlDateTime.Null
: SqlDateTime.Parse(CustInfoModel.SetupDate.ToString()));
param[25] = SqlHelper.GetParameter("@ArtiPerson", CustInfoModel.ArtiPerson);
param[26] = SqlHelper.GetParameter("@SetupMoney", CustInfoModel.SetupMoney);
param[27] = SqlHelper.GetParameter("@SetupAddress", CustInfoModel.SetupAddress);
param[28] = SqlHelper.GetParameter("@CapitalScale", CustInfoModel.CapitalScale);
param[29] = SqlHelper.GetParameter("@SaleroomY", CustInfoModel.SaleroomY);
param[30] = SqlHelper.GetParameter("@ProfitY", CustInfoModel.ProfitY);
param[31] = SqlHelper.GetParameter("@TaxCD", CustInfoModel.TaxCD);
param[32] = SqlHelper.GetParameter("@BusiNumber", CustInfoModel.BusiNumber);
param[33] = SqlHelper.GetParameter("@IsTax", CustInfoModel.IsTax);
param[34] = SqlHelper.GetParameter("@SellMode", CustInfoModel.SellMode);
param[35] = SqlHelper.GetParameter("@SellArea", CustInfoModel.SellArea);
param[36] = SqlHelper.GetParameter("@CountryID", CustInfoModel.CountryID);
param[37] = SqlHelper.GetParameter("@Province", CustInfoModel.Province);
param[38] = SqlHelper.GetParameter("@City", CustInfoModel.City);
param[39] = SqlHelper.GetParameter("@Tel", CustInfoModel.Tel);
param[40] = SqlHelper.GetParameter("@ContactName", CustInfoModel.ContactName);
param[41] = SqlHelper.GetParameter("@Mobile", CustInfoModel.Mobile);
param[42] = SqlHelper.GetParameter("@ReceiveAddress", CustInfoModel.ReceiveAddress);
param[43] = SqlHelper.GetParameter("@WebSite", CustInfoModel.WebSite);
param[44] = SqlHelper.GetParameter("@Post", CustInfoModel.Post);
param[45] = SqlHelper.GetParameter("@email", CustInfoModel.email);
param[46] = SqlHelper.GetParameter("@Fax", CustInfoModel.Fax);
param[47] = SqlHelper.GetParameter("@OnLine", CustInfoModel.OnLine);
param[48] = SqlHelper.GetParameter("@TakeType", CustInfoModel.TakeType);
param[49] = SqlHelper.GetParameter("@CarryType", CustInfoModel.CarryType);
param[50] = SqlHelper.GetParameter("@BusiType", CustInfoModel.BusiType);
param[51] = SqlHelper.GetParameter("@BillType", CustInfoModel.BillType);
param[52] = SqlHelper.GetParameter("@PayType", CustInfoModel.PayType);
param[53] = SqlHelper.GetParameter("@MoneyType", CustInfoModel.MoneyType);
param[54] = SqlHelper.GetParameter("@CurrencyType", CustInfoModel.CurrencyType);
param[55] = SqlHelper.GetParameter("@CreditManage", CustInfoModel.CreditManage);
param[56] = SqlHelper.GetParameter("@MaxCredit", CustInfoModel.MaxCredit);
param[57] = SqlHelper.GetParameter("@MaxCreditDate", CustInfoModel.MaxCreditDate);
param[58] = SqlHelper.GetParameter("@UsedStatus", CustInfoModel.UsedStatus);
param[59] = SqlHelper.GetParameter("@Creator", CustInfoModel.Creator);
param[60] = SqlHelper.GetParameter("@CreatedDate", CustInfoModel.CreatedDate == null
? SqlDateTime.Null
: SqlDateTime.Parse(CustInfoModel.CreatedDate.ToString()));
param[61] = SqlHelper.GetParameter("@OpenBank", CustInfoModel.OpenBank);
param[62] = SqlHelper.GetParameter("@AccountMan", CustInfoModel.AccountMan);
param[63] = SqlHelper.GetParameter("@AccountNum", CustInfoModel.AccountNum);
param[64] = SqlHelper.GetParameter("@Remark", CustInfoModel.Remark);
param[65] = SqlHelper.GetParameter("@ModifiedDate", DateTime.Now);
param[66] = SqlHelper.GetParameter("@ModifiedUserID", ((UserInfoUtil)SessionUtil.Session["UserInfo"]).UserID);
param[67] = SqlHelper.GetParameter("@CustBig", CustInfoModel.CustBig);
param[68] = SqlHelper.GetParameter("@CustNum", CustInfoModel.CustNum);
#endregion
LinkManModel LinkManM = new LinkManModel();
string[] strlinkman = LinkManlist.Split('|'); //把联系人列表流分隔成数组
SqlCommand[] comms = new SqlCommand[strlinkman.Length + 1]; ; //申明cmd数组
SqlCommand cmdcust = new SqlCommand(sqlcust.ToString()); //未执行的客户信息修改命令
cmdcust.Parameters.AddRange(param);
comms[0] = cmdcust; //把未执行的客户信息修改命令给cmd数组第一项
//如果联系人信息不为空，执行删除及从表修改
if (LinkManlist != "")
{
//对于从表联系人信息先删除再添加
SqlCommand cmdlinkmandelete = new SqlCommand("delete officedba.CustLinkMan where CustNo = '" + CustInfoModel.CustNo + "'");
comms[1] = cmdlinkmandelete;
string recorditems = "";
string[] linkmanfield = null;
for (int i = 1; i < strlinkman.Length; i++) //循环数组
{
recorditems = strlinkman[i].ToString();//取到每一条记录:[序号,联系人姓名,手机,工作电话,职位,负责业务]
linkmanfield = recorditems.Split(','); //把每条记录分隔到字段
string fieldxh = linkmanfield[0].ToString();//序号
string fieldname = linkmanfield[1].ToString();//联系人姓名
string fieldhandset = linkmanfield[2].ToString();//手机
string fieldworktel = linkmanfield[3].ToString();//工作电话
string fieldposition = linkmanfield[4].ToString();//职务
string fieldoperation = linkmanfield[5].ToString();//负责业务
LinkManM.CompanyCD = CustInfoModel.CompanyCD; //联系人信息赋予一个LinkManM(联系人Model对象实例)
LinkManM.CustNo = CustInfoModel.CustNo;
LinkManM.LinkManName = fieldname;
LinkManM.Handset = fieldhandset;
LinkManM.WorkTel = fieldworktel;
LinkManM.Position = fieldposition;
LinkManM.Operation = fieldoperation;
LinkManM.ModifiedDate = DateTime.Now;
LinkManM.ModifiedUserID = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).UserID;//Session读取
#region 拼写添加联系人信息sql语句
StringBuilder sqllinkman = new StringBuilder();
sqllinkman.AppendLine("INSERT INTO officedba.CustLinkMan");
sqllinkman.AppendLine("(CompanyCD");
sqllinkman.AppendLine(",CustNo ");
sqllinkman.AppendLine(",LinkManName");
sqllinkman.AppendLine(",Position ");
sqllinkman.AppendLine(",Operation ");
sqllinkman.AppendLine(",WorkTel ");
sqllinkman.AppendLine(",Handset ");
sqllinkman.AppendLine(",ModifiedDate");
sqllinkman.AppendLine(",ModifiedUserID)");
sqllinkman.AppendLine(" values ");
sqllinkman.AppendLine("(@CompanyCD");
sqllinkman.AppendLine(",@CustNo ");
sqllinkman.AppendLine(",@LinkManName");
sqllinkman.AppendLine(",@Position ");
sqllinkman.AppendLine(",@Operation ");
sqllinkman.AppendLine(",@WorkTel ");
sqllinkman.AppendLine(",@Handset ");
sqllinkman.AppendLine(",@ModifiedDate");
sqllinkman.AppendLine(",@ModifiedUserID)");
SqlParameter[] paramlinkman = new SqlParameter[9];
paramlinkman[0] = SqlHelper.GetParameter("@CompanyCD", CustInfoModel.CompanyCD);
paramlinkman[1] = SqlHelper.GetParameter("@CustNo", CustInfoModel.CustNo);
paramlinkman[2] = SqlHelper.GetParameter("@LinkManName", LinkManM.LinkManName);
paramlinkman[3] = SqlHelper.GetParameter("@Position", LinkManM.Position);
paramlinkman[4] = SqlHelper.GetParameter("@Operation", LinkManM.Operation);
paramlinkman[5] = SqlHelper.GetParameter("@WorkTel", LinkManM.WorkTel);
paramlinkman[6] = SqlHelper.GetParameter("@Handset", LinkManM.Handset);
paramlinkman[7] = SqlHelper.GetParameter("@ModifiedDate", LinkManM.ModifiedDate);
paramlinkman[8] = SqlHelper.GetParameter("@ModifiedUserID", LinkManM.ModifiedUserID);
#endregion
SqlCommand cmdlinkman = new SqlCommand(sqllinkman.ToString()); //未执行的联系人信息添加命令
cmdlinkman.Parameters.AddRange(paramlinkman);
comms[i + 1] = cmdlinkman; //把未执行的联系人信息添加命令给cmd数组
}
}
//执行
SqlHelper.ExecuteTransForList(comms);
return SqlHelper.Result.OprateCount > 0 ? true : false;
}
catch
{
return false;
}
}
/// <summary>
/// 根据客户编号修改客户信息的方法
/// </summary>
/// <param name="CustInfoModel">客户信息Model</param>
/// <returns>bool值</returns>
public static bool UpdateCustInfo(CustInfoModel CustInfoModel, LinkManModel LinkManM, Hashtable htExtAttr)
{
try
{
#region 拼写修改客户信息SQL语句
StringBuilder sqlcust = new StringBuilder();
sqlcust.AppendLine("UPDATE officedba.CustInfo set ");
//sqlcust.AppendLine("CompanyCD= @CompanyCD, ");
sqlcust.AppendLine("CustTypeManage = @CustTypeManage, ");
sqlcust.AppendLine("CustTypeSell = @CustTypeSell, ");
sqlcust.AppendLine("CustTypeTime = @CustTypeTime, ");
sqlcust.AppendLine("CustType= @CustType, ");
sqlcust.AppendLine("CustClass = @CustClass , ");
sqlcust.AppendLine("CustName = @CustName , ");
sqlcust.AppendLine("CustNam = @CustNam , ");
sqlcust.AppendLine("CustShort = @CustShort , ");
sqlcust.AppendLine("CreditGrade = @CreditGrade , ");
sqlcust.AppendLine("Manager = @Manager , ");
sqlcust.AppendLine("AreaID = @AreaID , ");
sqlcust.AppendLine("CustNote = @CustNote , ");
sqlcust.AppendLine("LinkCycle = @LinkCycle , ");
sqlcust.AppendLine("HotIs = @HotIs , ");
sqlcust.AppendLine("HotHow = @HotHow , ");
sqlcust.AppendLine("MeritGrade = @MeritGrade , ");
sqlcust.AppendLine("RelaGrade = @RelaGrade , ");
sqlcust.AppendLine("Relation = @Relation , ");
sqlcust.AppendLine("CompanyType = @CompanyType , ");
sqlcust.AppendLine("StaffCount = @StaffCount , ");
sqlcust.AppendLine("Source = @Source , ");
sqlcust.AppendLine("Phase = @Phase , ");
sqlcust.AppendLine("CustSupe = @CustSupe , ");
sqlcust.AppendLine("Trade = @Trade , ");
sqlcust.AppendLine("SetupDate = @SetupDate , ");
sqlcust.AppendLine("ArtiPerson = @ArtiPerson , ");
sqlcust.AppendLine("SetupMoney = @SetupMoney , ");
sqlcust.AppendLine("SetupAddress = @SetupAddress , ");
sqlcust.AppendLine("CapitalScale = @CapitalScale , ");
sqlcust.AppendLine("SaleroomY = @SaleroomY , ");
sqlcust.AppendLine("ProfitY = @ProfitY , ");
sqlcust.AppendLine("TaxCD = @TaxCD , ");
sqlcust.AppendLine("BusiNumber = @BusiNumber , ");
sqlcust.AppendLine("IsTax = @IsTax , ");
sqlcust.AppendLine("SellMode = @SellMode , ");
sqlcust.AppendLine("SellArea = @SellArea , ");
sqlcust.AppendLine("CountryID = @CountryID , ");
sqlcust.AppendLine("Province = @Province , ");
sqlcust.AppendLine("City = @City , ");
sqlcust.AppendLine("Tel = @Tel , ");
sqlcust.AppendLine("ContactName = @ContactName , ");
sqlcust.AppendLine("Mobile = @Mobile , ");
sqlcust.AppendLine("ReceiveAddress = @ReceiveAddress , ");
sqlcust.AppendLine("WebSite = @WebSite , ");
sqlcust.AppendLine("Post = @Post , ");
sqlcust.AppendLine("email = @email , ");
sqlcust.AppendLine("Fax = @Fax , ");
sqlcust.AppendLine("OnLine = @OnLine , ");
sqlcust.AppendLine("TakeType = @TakeType , ");
sqlcust.AppendLine("CarryType = @CarryType , ");
sqlcust.AppendLine("BusiType = @BusiType , ");
sqlcust.AppendLine("BillType = @BillType , ");
sqlcust.AppendLine("PayType = @PayType , ");
sqlcust.AppendLine("MoneyType = @MoneyType , ");
sqlcust.AppendLine("CurrencyType = @CurrencyType , ");
sqlcust.AppendLine("CreditManage = @CreditManage , ");
sqlcust.AppendLine("MaxCredit = @MaxCredit , ");
sqlcust.AppendLine("MaxCreditDate = @MaxCreditDate , ");
sqlcust.AppendLine("UsedStatus = @UsedStatus , ");
sqlcust.AppendLine("CanViewUser = @CanViewUser , ");
sqlcust.AppendLine("CanViewUserName = @CanViewUserName , ");
sqlcust.AppendLine("FirstBuyDate = @FirstBuyDate , ");
sqlcust.AppendLine("CreatedDate = @CreatedDate , ");
sqlcust.AppendLine("OpenBank = @OpenBank, ");
sqlcust.AppendLine("AccountMan = @AccountMan, ");
sqlcust.AppendLine("AccountNum = @AccountNum, ");
sqlcust.AppendLine("CustBig = @CustBig, ");
sqlcust.AppendLine("CustNum = @CustNum, ");
sqlcust.AppendLine("Remark = @Remark, ");
sqlcust.AppendLine("ModifiedDate = @ModifiedDate, ");
sqlcust.AppendLine("CompanyValues = @CompanyValues , ");
sqlcust.AppendLine("CatchWord = @CatchWord , ");
sqlcust.AppendLine("ManageValues = @ManageValues , ");
sqlcust.AppendLine("Potential = @Potential , ");
sqlcust.AppendLine("Problem = @Problem , ");
sqlcust.AppendLine("Advantages = @Advantages , ");
sqlcust.AppendLine("TradePosition = @TradePosition, ");
sqlcust.AppendLine("Competition = @Competition, ");
sqlcust.AppendLine("Collaborator = @Collaborator, ");
sqlcust.AppendLine("ManagePlan = @ManagePlan, ");
sqlcust.AppendLine("Collaborate = @Collaborate, ");
sqlcust.AppendLine("ModifiedUserID = @ModifiedUserID ");
sqlcust.AppendLine(" WHERE ");
sqlcust.AppendLine("CustNo = @CustNo and CompanyCD = @CompanyCD");
#endregion
#region 设置修改客户信息参数
SqlCommand mycomm = new SqlCommand();
mycomm.Parameters.Add(SqlHelper.GetParameter("@CompanyCD", CustInfoModel.CompanyCD));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CustType", CustInfoModel.CustType));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CustClass", CustInfoModel.CustClass));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CustNo", CustInfoModel.CustNo));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CustName", CustInfoModel.CustName));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CustNam", CustInfoModel.CustNam));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CustShort", CustInfoModel.CustShort));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CreditGrade", CustInfoModel.CreditGrade));
mycomm.Parameters.Add(SqlHelper.GetParameter("@Manager", CustInfoModel.Seller));
mycomm.Parameters.Add(SqlHelper.GetParameter("@AreaID", CustInfoModel.AreaID));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CustNote", CustInfoModel.CustNote));
mycomm.Parameters.Add(SqlHelper.GetParameter("@LinkCycle", CustInfoModel.LinkCycle));
mycomm.Parameters.Add(SqlHelper.GetParameter("@HotIs", CustInfoModel.HotIs));
mycomm.Parameters.Add(SqlHelper.GetParameter("@HotHow", CustInfoModel.HotHow));
mycomm.Parameters.Add(SqlHelper.GetParameter("@MeritGrade", CustInfoModel.MeritGrade));
mycomm.Parameters.Add(SqlHelper.GetParameter("@RelaGrade", CustInfoModel.RelaGrade));
mycomm.Parameters.Add(SqlHelper.GetParameter("@Relation", CustInfoModel.Relation));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CompanyType", CustInfoModel.CompanyType));
mycomm.Parameters.Add(SqlHelper.GetParameter("@StaffCount", CustInfoModel.StaffCount));
mycomm.Parameters.Add(SqlHelper.GetParameter("@Source", CustInfoModel.Source));
mycomm.Parameters.Add(SqlHelper.GetParameter("@Phase", CustInfoModel.Phase));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CustSupe", CustInfoModel.CustSupe));
mycomm.Parameters.Add(SqlHelper.GetParameter("@Trade", CustInfoModel.Trade));
mycomm.Parameters.Add(SqlHelper.GetParameter("@SetupDate", CustInfoModel.SetupDate == null
? SqlDateTime.Null
: SqlDateTime.Parse(CustInfoModel.SetupDate.ToString())));
mycomm.Parameters.Add(SqlHelper.GetParameter("@ArtiPerson", CustInfoModel.ArtiPerson));
mycomm.Parameters.Add(SqlHelper.GetParameter("@SetupMoney", CustInfoModel.SetupMoney));
mycomm.Parameters.Add(SqlHelper.GetParameter("@SetupAddress", CustInfoModel.SetupAddress));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CapitalScale", CustInfoModel.CapitalScale));
mycomm.Parameters.Add(SqlHelper.GetParameter("@SaleroomY", CustInfoModel.SaleroomY));
mycomm.Parameters.Add(SqlHelper.GetParameter("@ProfitY", CustInfoModel.ProfitY));
mycomm.Parameters.Add(SqlHelper.GetParameter("@TaxCD", CustInfoModel.TaxCD));
mycomm.Parameters.Add(SqlHelper.GetParameter("@BusiNumber", CustInfoModel.BusiNumber));
mycomm.Parameters.Add(SqlHelper.GetParameter("@IsTax", CustInfoModel.IsTax));
mycomm.Parameters.Add(SqlHelper.GetParameter("@SellMode", CustInfoModel.SellMode));
mycomm.Parameters.Add(SqlHelper.GetParameter("@SellArea", CustInfoModel.SellArea));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CountryID", CustInfoModel.CountryID));
mycomm.Parameters.Add(SqlHelper.GetParameter("@Province", CustInfoModel.Province));
mycomm.Parameters.Add(SqlHelper.GetParameter("@City", CustInfoModel.City));
mycomm.Parameters.Add(SqlHelper.GetParameter("@Tel", CustInfoModel.Tel));
mycomm.Parameters.Add(SqlHelper.GetParameter("@ContactName", CustInfoModel.ContactName));
mycomm.Parameters.Add(SqlHelper.GetParameter("@Mobile", CustInfoModel.Mobile));
mycomm.Parameters.Add(SqlHelper.GetParameter("@ReceiveAddress", CustInfoModel.ReceiveAddress));
mycomm.Parameters.Add(SqlHelper.GetParameter("@WebSite", CustInfoModel.WebSite));
mycomm.Parameters.Add(SqlHelper.GetParameter("@Post", CustInfoModel.Post));
mycomm.Parameters.Add(SqlHelper.GetParameter("@email", CustInfoModel.email));
mycomm.Parameters.Add(SqlHelper.GetParameter("@Fax", CustInfoModel.Fax));
mycomm.Parameters.Add(SqlHelper.GetParameter("@OnLine", CustInfoModel.OnLine));
mycomm.Parameters.Add(SqlHelper.GetParameter("@TakeType", CustInfoModel.TakeType));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CarryType", CustInfoModel.CarryType));
mycomm.Parameters.Add(SqlHelper.GetParameter("@BusiType", CustInfoModel.BusiType));
mycomm.Parameters.Add(SqlHelper.GetParameter("@BillType", CustInfoModel.BillType));
mycomm.Parameters.Add(SqlHelper.GetParameter("@PayType", CustInfoModel.PayType));
mycomm.Parameters.Add(SqlHelper.GetParameter("@MoneyType", CustInfoModel.MoneyType));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CurrencyType", CustInfoModel.CurrencyType));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CreditManage", CustInfoModel.CreditManage));
mycomm.Parameters.Add(SqlHelper.GetParameter("@MaxCredit", CustInfoModel.MaxCredit));
mycomm.Parameters.Add(SqlHelper.GetParameter("@MaxCreditDate", CustInfoModel.MaxCreditDate));
mycomm.Parameters.Add(SqlHelper.GetParameter("@UsedStatus", CustInfoModel.UsedStatus));
mycomm.Parameters.Add(SqlHelper.GetParameter("@Creator", CustInfoModel.Creator));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CreatedDate", CustInfoModel.CreatedDate == null
? SqlDateTime.Null
: SqlDateTime.Parse(CustInfoModel.CreatedDate.ToString())));
mycomm.Parameters.Add(SqlHelper.GetParameter("@OpenBank", CustInfoModel.OpenBank));
mycomm.Parameters.Add(SqlHelper.GetParameter("@AccountMan", CustInfoModel.AccountMan));
mycomm.Parameters.Add(SqlHelper.GetParameter("@AccountNum", CustInfoModel.AccountNum));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CustBig", CustInfoModel.CustBig));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CustNum", CustInfoModel.CustNum));
mycomm.Parameters.Add(SqlHelper.GetParameter("@Remark", CustInfoModel.Remark));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CustTypeManage", CustInfoModel.CustTypeManage));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CustTypeSell", CustInfoModel.CustTypeSell));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CustTypeTime", CustInfoModel.CustTypeTime));
mycomm.Parameters.Add(SqlHelper.GetParameter("@FirstBuyDate", CustInfoModel.FirstBuyDate == null
? SqlDateTime.Null
: SqlDateTime.Parse(CustInfoModel.FirstBuyDate.ToString())));
mycomm.Parameters.Add(SqlHelper.GetParameter("@ModifiedDate", DateTime.Now));
mycomm.Parameters.Add(SqlHelper.GetParameter("@ModifiedUserID", ((UserInfoUtil)SessionUtil.Session["UserInfo"]).UserID));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CanViewUser", CustInfoModel.CanViewUser));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CanViewUserName", CustInfoModel.CanViewUserName));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CompanyValues", CustInfoModel.CompanyValues));
mycomm.Parameters.Add(SqlHelper.GetParameter("@CatchWord", CustInfoModel.CatchWord));
mycomm.Parameters.Add(SqlHelper.GetParameter("@ManageValues", CustInfoModel.ManageValues));
mycomm.Parameters.Add(SqlHelper.GetParameter("@Potential", CustInfoModel.Potential));
mycomm.Parameters.Add(SqlHelper.GetParameter("@Problem", CustInfoModel.Problem));
mycomm.Parameters.Add(SqlHelper.GetParameter("@Advantages", CustInfoModel.Advantages));
mycomm.Parameters.Add(SqlHelper.GetParameter("@TradePosition", CustInfoModel.TradePosition));
mycomm.Parameters.Add(SqlHelper.GetParameter("@Competition", CustInfoModel.Competition));
mycomm.Parameters.Add(SqlHelper.GetParameter("@Collaborator", CustInfoModel.Collaborator));
mycomm.Parameters.Add(SqlHelper.GetParameter("@ManagePlan", CustInfoModel.ManagePlan));
mycomm.Parameters.Add(SqlHelper.GetParameter("@Collaborate", CustInfoModel.Collaborate));
mycomm.CommandText = sqlcust.ToString();
#endregion
ArrayList lstCmd = new ArrayList();
SqlCommand cmd = new SqlCommand();
GetExtAttrCmd(CustInfoModel, htExtAttr, cmd);
lstCmd.Add(mycomm);//修改客户基本信息
if (htExtAttr != null)
lstCmd.Add(cmd);//修改客户扩展信息
if (CustInfoModel.CustBig == "2")//当选择会员客户时,修改信息到联系人表
{
SqlCommand cmdLinkMan = new SqlCommand();
StringBuilder sqlLinkMan = new StringBuilder();
sqlLinkMan.AppendLine(" update officedba.CustLinkMan ");
sqlLinkMan.AppendLine(" set LinkManName=@LinkManName,Sex=@Sex,LinkType=@LinkType,PaperNum=@PaperNum,");
sqlLinkMan.AppendLine(" Birthday=@Birthday,WorkTel=@WorkTel,Handset=@Handset,Fax=@Fax,Position=@Position, ");
sqlLinkMan.AppendLine(" Age= @Age,Post=@Post,MailAddress=@MailAddress,HomeTown=@HomeTown,NationalID=@NationalID,CultureLevel=@CultureLevel,");
sqlLinkMan.AppendLine(" Professional=@Professional,IncomeYear=@IncomeYear,FuoodDrink=@FuoodDrink, ");
sqlLinkMan.AppendLine(" LoveMusic=@LoveMusic,LoveColor=@LoveColor,LoveSmoke=@LoveSmoke,LoveDrink=@LoveDrink,LoveTea=@LoveTea,");
sqlLinkMan.AppendLine(" LoveBook=@LoveBook,LoveSport=@LoveSport,LoveClothes=@LoveClothes,Cosmetic=@Cosmetic, ");
sqlLinkMan.AppendLine(" Nature=@Nature,Appearance=@Appearance,AdoutBody=@AdoutBody,AboutFamily=@AboutFamily,Car=@Car,");
sqlLinkMan.AppendLine(" CanViewUser=@CanViewUser,CanViewUserName=@CanViewUserName ");
sqlLinkMan.AppendLine(" WHERE ");
sqlLinkMan.AppendLine(" CustNo = @CustNo and CompanyCD = @CompanyCD ");
sqlLinkMan.AppendLine(" and id=(select min(c.id)id from officedba.CustLinkMan c ");
sqlLinkMan.AppendLine(" where c.CompanyCD = @CompanyCD and c.custno = @CustNo ) ");
#region 设置联系人参数
SqlCommand commLinkMan = new SqlCommand();
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@CompanyCD", CustInfoModel.CompanyCD));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@CustNo", CustInfoModel.CustNo));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@LinkManName", CustInfoModel.CustName));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@Sex", LinkManM.Sex));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@LinkType", LinkManM.LinkType));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@PaperNum", LinkManM.PaperNum));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@Birthday", LinkManM.Birthday == null ? SqlDateTime.Null : SqlDateTime.Parse(LinkManM.Birthday.ToString())));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@WorkTel", LinkManM.WorkTel));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@Handset", LinkManM.Handset));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@Fax", LinkManM.Fax));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@Position", LinkManM.Position));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@Age", LinkManM.Age));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@Post", LinkManM.Post));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@MailAddress", LinkManM.MailAddress));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@HomeTown", LinkManM.HomeTown));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@NationalID", LinkManM.NationalID));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@CultureLevel", LinkManM.CultureLevel));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@Professional", LinkManM.Professional));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@IncomeYear", LinkManM.IncomeYear));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@FuoodDrink", LinkManM.FuoodDrink));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@LoveMusic", LinkManM.LoveMusic));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@LoveColor", LinkManM.LoveColor));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@LoveSmoke", LinkManM.LoveSmoke));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@LoveDrink", LinkManM.LoveDrink));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@LoveTea", LinkManM.LoveTea));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@LoveBook", LinkManM.LoveBook));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@LoveSport", LinkManM.LoveSport));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@LoveClothes", LinkManM.LoveClothes));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@Cosmetic", LinkManM.Cosmetic));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@Nature", LinkManM.Nature));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@Appearance", LinkManM.Appearance));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@AdoutBody", LinkManM.AdoutBody));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@AboutFamily", LinkManM.AboutFamily));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@Car", LinkManM.Car));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@CanViewUser", CustInfoModel.CanViewUser));
commLinkMan.Parameters.Add(SqlHelper.GetParameter("@CanViewUserName", CustInfoModel.CanViewUserName));
commLinkMan.CommandText = sqlLinkMan.ToString();
#endregion
lstCmd.Add(commLinkMan);
}
//执行登陆操作
bool isSucc = SqlHelper.ExecuteTransWithArrayList(lstCmd);
return isSucc;
}
catch
{
return false;
}
}
/// <summary>
/// 导出联系人列表
/// </summary>
/// <param name="CustNam"></param>
/// <param name="LinkManM"></param>
/// <param name="BeginDate"></param>
/// <param name="EndDate"></param>
/// <param name="ord"></param>
/// <returns></returns>
public static DataTable ExportLinkManInfo(string CustNam, LinkManModel LinkManM, string BeginDate, string EndDate, string ord)
{
try
{
string sql = "select " +
"link.id,isnull(cust.id,'-1') custid,isnull(link.linkmanname,'') linkmanname,isnull(link.Appellation,'') Appellation," +
"(case link.Important when '1' then '不重要' when '2' then '普通' when '3' then '重要' when '4' then '关键' else '' end) Important," +
"isnull(cust.CustName,'') CustName,isnull(link.WorkTel,'') WorkTel,isnull(link.Handset,'') Handset," +
"isnull(link.QQ,'') QQ,isnull(cp.TypeName,'') TypeName,Convert(varchar(100),link.Birthday,23) Birthday " +
" from " +
" officedba.custlinkman link" +
" left join officedba.custinfo cust on cust.custno = link.custno " +
" left join officedba.CodePublicType cp on cp.id = link.LinkType " +
" where link.companycd = '" + LinkManM.CompanyCD + "'" +
" and (link.CanViewUser like '%" + "," + LinkManM.CanViewUser + "," + "%' or '" + LinkManM.CanViewUser + "' = link.Creator or link.CanViewUser = '******')";
if (CustNam != "")
sql += " and cust.id = '" + CustNam + "'";
if (LinkManM.LinkManName != "")
sql += " and LinkManName like '%" + LinkManM.LinkManName + "%'";
if (LinkManM.Handset != "")
sql += " and Handset like '%" + LinkManM.Handset + "%'";
if (LinkManM.WorkTel != "")
sql += " and WorkTel like '%" + LinkManM.WorkTel + "%'";
if (LinkManM.Important != "0")
sql += " and Important = '" + LinkManM.Important + "'";
if (LinkManM.LinkType != 0)
sql += " and link.LinkType = '" + LinkManM.LinkType + "'";
if (BeginDate.ToString() != "")
sql += " and link.Birthday >= '" + BeginDate.ToString() + "'";//sql += " and (link.Birthday >= '" + BeginDate.ToString() + "' or link.Birthday is null)";
if (EndDate.ToString() != "")
sql += " and link.Birthday <= '" + EndDate.ToString() + "'";//sql += " and (link.Birthday <= '" + EndDate.ToString() + "' or link.Birthday is null)";
return SqlHelper.ExecuteSql(sql);
}
catch (Exception ex)
{
string sss = ex.Message;
return null;
}
}
/// <summary>
/// 添加客户联系人的方法
/// </summary>
/// <param name="LinkManModel">联系人信息</param>
/// <returns>bool值</returns>
public static int LinkManAdd(LinkManModel LinkManModel)
{
try
{
#region 拼写SQL语句
StringBuilder sql = new StringBuilder();
sql.AppendLine("INSERT INTO officedba.CustLinkMan");
sql.AppendLine("(CompanyCD");
sql.AppendLine(",CustNo ");
sql.AppendLine(",LinkManName");
sql.AppendLine(",Sex ");
sql.AppendLine(",Important ");
sql.AppendLine(",Company ");
sql.AppendLine(",Appellation");
sql.AppendLine(",Department ");
sql.AppendLine(",Position ");
sql.AppendLine(",Operation ");
sql.AppendLine(",WorkTel ");
sql.AppendLine(",Fax ");
sql.AppendLine(",Handset ");
sql.AppendLine(",MailAddress");
sql.AppendLine(",HomeTel ");
sql.AppendLine(",MSN ");
sql.AppendLine(",QQ ");
sql.AppendLine(",Post ");
sql.AppendLine(",HomeAddress");
sql.AppendLine(",Remark ");
sql.AppendLine(",Age ");
sql.AppendLine(",Likes ");
sql.AppendLine(",LinkType ");
sql.AppendLine(",Birthday ");
sql.AppendLine(",PaperType ");
sql.AppendLine(",PaperNum ");
sql.AppendLine(",Photo");
sql.AppendLine(",Creator ");
sql.AppendLine(",CreatedDate ");
sql.AppendLine(",CanViewUser ");
sql.AppendLine(",CanViewUserName ");
sql.AppendLine(",ModifiedDate");
sql.AppendLine(",HomeTown");
if (!string.IsNullOrEmpty(LinkManModel.NationalID))
{
sql.AppendLine(",NationalID");
}
sql.AppendLine(",Birthcity");
if (!string.IsNullOrEmpty(LinkManModel.CultureLevel))
{
sql.AppendLine(",CultureLevel");
}
if (!string.IsNullOrEmpty(LinkManModel.Professional))
{
sql.AppendLine(",Professional");
}
sql.AppendLine(",GraduateSchool");
sql.AppendLine(",IncomeYear");
sql.AppendLine(",FuoodDrink");
sql.AppendLine(",LoveMusic");
sql.AppendLine(",LoveColor");
sql.AppendLine(",LoveSmoke");
sql.AppendLine(",LoveDrink");
sql.AppendLine(",LoveTea");
sql.AppendLine(",LoveBook");
sql.AppendLine(",LoveSport");
sql.AppendLine(",LoveClothes");
sql.AppendLine(",Cosmetic");
sql.AppendLine(",Nature");
sql.AppendLine(",Appearance");
sql.AppendLine(",AdoutBody");
sql.AppendLine(",AboutFamily");
sql.AppendLine(",Car");
sql.AppendLine(",LiveHouse");
sql.AppendLine(",ProfessionalDes");
sql.AppendLine(",ModifiedUserID)");
sql.AppendLine(" values ");
sql.AppendLine("(@CompanyCD");
sql.AppendLine(",@CustNo ");
sql.AppendLine(",@LinkManName");
sql.AppendLine(",@Sex ");
sql.AppendLine(",@Important ");
sql.AppendLine(",@Company ");
sql.AppendLine(",@Appellation");
sql.AppendLine(",@Department ");
sql.AppendLine(",@Position ");
sql.AppendLine(",@Operation ");
sql.AppendLine(",@WorkTel ");
sql.AppendLine(",@Fax ");
sql.AppendLine(",@Handset ");
sql.AppendLine(",@MailAddress");
sql.AppendLine(",@HomeTel ");
sql.AppendLine(",@MSN ");
sql.AppendLine(",@QQ ");
sql.AppendLine(",@Post ");
sql.AppendLine(",@HomeAddress");
sql.AppendLine(",@Remark ");
sql.AppendLine(",@Age ");
sql.AppendLine(",@Likes ");
sql.AppendLine(",@LinkType ");
sql.AppendLine(",@Birthday ");
sql.AppendLine(",@PaperType ");
sql.AppendLine(",@PaperNum ");
sql.AppendLine(",@Photo");
sql.AppendLine(",@Creator ");
sql.AppendLine(",@CreatedDate ");
sql.AppendLine(",@CanViewUser ");
sql.AppendLine(",@CanViewUserName ");
sql.AppendLine(",@ModifiedDate");
sql.AppendLine(",@HomeTown");
if (!string.IsNullOrEmpty(LinkManModel.NationalID))
{
sql.AppendLine(",@NationalID");
}
sql.AppendLine(",@Birthcity");
if (!string.IsNullOrEmpty(LinkManModel.CultureLevel))
{
sql.AppendLine(",@CultureLevel");
}
if (!string.IsNullOrEmpty(LinkManModel.Professional))
{
sql.AppendLine(",@Professional");
}
sql.AppendLine(",@GraduateSchool");
sql.AppendLine(",@IncomeYear");
sql.AppendLine(",@FuoodDrink");
sql.AppendLine(",@LoveMusic");
sql.AppendLine(",@LoveColor");
sql.AppendLine(",@LoveSmoke");
sql.AppendLine(",@LoveDrink");
sql.AppendLine(",@LoveTea");
sql.AppendLine(",@LoveBook");
sql.AppendLine(",@LoveSport");
sql.AppendLine(",@LoveClothes");
sql.AppendLine(",@Cosmetic");
sql.AppendLine(",@Nature");
sql.AppendLine(",@Appearance");
sql.AppendLine(",@AdoutBody");
sql.AppendLine(",@AboutFamily");
sql.AppendLine(",@Car");
sql.AppendLine(",@LiveHouse");
sql.AppendLine(",@ProfessionalDes");
sql.AppendLine(",@ModifiedUserID)");
#endregion
#region 设置参数
SqlParameter[] param = new SqlParameter[58];
param[0] = SqlHelper.GetParameter("@CompanyCD", LinkManModel.CompanyCD);
param[1] = SqlHelper.GetParameter("@CustNo", LinkManModel.CustNo);
param[2] = SqlHelper.GetParameter("@LinkManName", LinkManModel.LinkManName);
param[3] = SqlHelper.GetParameter("@Sex", LinkManModel.Sex);
param[4] = SqlHelper.GetParameter("@Important", LinkManModel.Important);
param[5] = SqlHelper.GetParameter("@Company", LinkManModel.Company);
param[6] = SqlHelper.GetParameter("@Appellation", LinkManModel.Appellation);
param[7] = SqlHelper.GetParameter("@Department", LinkManModel.Department);
param[8] = SqlHelper.GetParameter("@Position", LinkManModel.Position);
param[9] = SqlHelper.GetParameter("@Operation", LinkManModel.Operation);
param[10] = SqlHelper.GetParameter("@WorkTel", LinkManModel.WorkTel);
param[11] = SqlHelper.GetParameter("@Fax", LinkManModel.Fax);
param[12] = SqlHelper.GetParameter("@Handset", LinkManModel.Handset);
param[13] = SqlHelper.GetParameter("@MailAddress", LinkManModel.MailAddress);
param[14] = SqlHelper.GetParameter("@HomeTel", LinkManModel.HomeTel);
param[15] = SqlHelper.GetParameter("@MSN", LinkManModel.MSN);
param[16] = SqlHelper.GetParameter("@QQ", LinkManModel.QQ);
param[17] = SqlHelper.GetParameter("@Post", LinkManModel.Post);
param[18] = SqlHelper.GetParameter("@HomeAddress", LinkManModel.HomeAddress);
param[19] = SqlHelper.GetParameter("@Remark", LinkManModel.Remark);
param[20] = SqlHelper.GetParameter("@Age", LinkManModel.Age);
param[21] = SqlHelper.GetParameter("@Likes", LinkManModel.Likes);
param[22] = SqlHelper.GetParameter("@LinkType", LinkManModel.LinkType);
param[23] = SqlHelper.GetParameter("@Birthday", LinkManModel.Birthday == null
? SqlDateTime.Null
: SqlDateTime.Parse(LinkManModel.Birthday.ToString()));
param[24] = SqlHelper.GetParameter("@PaperType", LinkManModel.PaperType);
param[25] = SqlHelper.GetParameter("@PaperNum", LinkManModel.PaperNum);
param[26] = SqlHelper.GetParameter("@Photo", LinkManModel.Photo);
param[27] = SqlHelper.GetParameter("@ModifiedDate", LinkManModel.ModifiedDate);
param[28] = SqlHelper.GetParameter("@ModifiedUserID", LinkManModel.ModifiedUserID);
param[29] = SqlHelper.GetParameter("@CanViewUser", LinkManModel.CanViewUser);
param[30] = SqlHelper.GetParameter("@CanViewUserName", LinkManModel.CanViewUserName);
param[31] = SqlHelper.GetParameter("@Creator", LinkManModel.Creator);
param[32] = SqlHelper.GetParameter("@CreatedDate", LinkManModel.CreatedDate);
param[33] = SqlHelper.GetParameter("@HomeTown", LinkManModel.HomeTown);
param[34] = SqlHelper.GetParameter("@NationalID", LinkManModel.NationalID == null ? SqlInt32.Null : int.Parse(LinkManModel.NationalID));
param[35] = SqlHelper.GetParameter("@Birthcity", LinkManModel.birthcity);
param[36] = SqlHelper.GetParameter("@CultureLevel", LinkManModel.CultureLevel == null ? SqlInt32.Null : int.Parse(LinkManModel.CultureLevel));
param[37] = SqlHelper.GetParameter("@Professional", LinkManModel.Professional == null ? SqlInt32.Null : int.Parse(LinkManModel.Professional));
param[38] = SqlHelper.GetParameter("@GraduateSchool", LinkManModel.GraduateSchool);
param[39] = SqlHelper.GetParameter("@IncomeYear", LinkManModel.IncomeYear);
param[40] = SqlHelper.GetParameter("@FuoodDrink", LinkManModel.FuoodDrink);
param[41] = SqlHelper.GetParameter("@LoveMusic", LinkManModel.LoveMusic);
param[42] = SqlHelper.GetParameter("@LoveColor", LinkManModel.LoveColor);
param[43] = SqlHelper.GetParameter("@LoveSmoke", LinkManModel.LoveSmoke);
param[44] = SqlHelper.GetParameter("@LoveDrink", LinkManModel.LoveDrink);
param[45] = SqlHelper.GetParameter("@LoveTea", LinkManModel.LoveTea);
param[46] = SqlHelper.GetParameter("@LoveBook", LinkManModel.LoveBook);
param[47] = SqlHelper.GetParameter("@LoveSport", LinkManModel.LoveSport);
param[48] = SqlHelper.GetParameter("@LoveClothes", LinkManModel.LoveClothes);
param[49] = SqlHelper.GetParameter("@Cosmetic", LinkManModel.Cosmetic);
param[50] = SqlHelper.GetParameter("@Nature", LinkManModel.Nature);
param[51] = SqlHelper.GetParameter("@Appearance", LinkManModel.Appearance);
param[52] = SqlHelper.GetParameter("@AdoutBody", LinkManModel.AdoutBody);
param[53] = SqlHelper.GetParameter("@AboutFamily", LinkManModel.AboutFamily);
param[54] = SqlHelper.GetParameter("@Car", LinkManModel.Car);
param[55] = SqlHelper.GetParameter("@LiveHouse", LinkManModel.LiveHouse);
param[56] = SqlHelper.GetParameter("@ProfessionalDes", LinkManModel.ProfessionalDes);
#endregion
SqlParameter paramid = new SqlParameter("@id", SqlDbType.Int);
paramid.Direction = ParameterDirection.Output;
param[57] = paramid;
//创建命令
SqlCommand comm = new SqlCommand();
SqlHelper.ExecuteTransStoredProcedure("officedba.insertCustLinkMan", comm, param);
int contantid = Convert.ToInt32(comm.Parameters["@id"].Value);
return contantid;
}
catch (Exception ex)
{
string sss = ex.Message;
return 0;
}
}
/// <summary>
/// 根据客户编号修改联系人信息的方法
/// </summary>
/// <param name="LinkManM">联系人信息Model</param>
/// <param name="CustNo">联系人对应客户编号</param>
/// <returns>bool值</returns>
public static bool UpdateLinkMan(LinkManModel LinkManM)
{
try
{
#region 拼写修改联系人信息SQL语句
StringBuilder sqllink = new StringBuilder();
sqllink.AppendLine("UPDATE officedba.CustLinkMan set ");
sqllink.AppendLine("CompanyCD = @CompanyCD, ");
sqllink.AppendLine("LinkManName = @LinkManName, ");
sqllink.AppendLine("Sex = @Sex, ");
sqllink.AppendLine("Important = @Important, ");
sqllink.AppendLine("Company = @Company, ");
sqllink.AppendLine("Appellation = @Appellation, ");
sqllink.AppendLine("Department = @Department, ");
sqllink.AppendLine("Position = @Position, ");
sqllink.AppendLine("Operation = @Operation, ");
sqllink.AppendLine("WorkTel = @WorkTel, ");
sqllink.AppendLine("Fax = @Fax, ");
sqllink.AppendLine("Handset = @Handset, ");
sqllink.AppendLine("MailAddress = @MailAddress, ");
sqllink.AppendLine("HomeTel = @HomeTel, ");
sqllink.AppendLine("MSN = @MSN, ");
sqllink.AppendLine("QQ = @QQ, ");
sqllink.AppendLine("Post = @Post, ");
sqllink.AppendLine("HomeAddress = @HomeAddress, ");
sqllink.AppendLine("Remark = @Remark, ");
sqllink.AppendLine("Age = @Age, ");
sqllink.AppendLine("Likes = @Likes, ");
sqllink.AppendLine("LinkType = @LinkType, ");
sqllink.AppendLine("Birthday =@Birthday,");
sqllink.AppendLine("PaperType = @PaperType, ");
sqllink.AppendLine("PaperNum = @PaperNum, ");
sqllink.AppendLine("Photo = @Photo, ");
sqllink.AppendLine("CanViewUser = @CanViewUser, ");
sqllink.AppendLine("CanViewUserName = @CanViewUserName, ");
sqllink.AppendLine("ModifiedDate = @ModifiedDate, ");
sqllink.AppendLine("HomeTown=@HomeTown,");
if (!string.IsNullOrEmpty(LinkManM.NationalID))
{
sqllink.AppendLine("NationalID=@NationalID,");
}
sqllink.AppendLine("Birthcity=@Birthcity,");
if (!string.IsNullOrEmpty(LinkManM.CultureLevel))
{
sqllink.AppendLine("CultureLevel=@CultureLevel,");
}
if (!string.IsNullOrEmpty(LinkManM.Professional))
{
sqllink.AppendLine("Professional=@Professional,");
}
sqllink.AppendLine("GraduateSchool=@GraduateSchool,");
sqllink.AppendLine("IncomeYear=@IncomeYear,");
sqllink.AppendLine("FuoodDrink=@FuoodDrink,");
sqllink.AppendLine("LoveMusic=@LoveMusic,");
sqllink.AppendLine("LoveColor=@LoveColor,");
sqllink.AppendLine("LoveSmoke=@LoveSmoke,");
sqllink.AppendLine("LoveDrink=@LoveDrink,");
sqllink.AppendLine("LoveTea=@LoveTea,");
sqllink.AppendLine("LoveBook=@LoveBook,");
sqllink.AppendLine("LoveSport=@LoveSport,");
sqllink.AppendLine("LoveClothes=@LoveClothes,");
sqllink.AppendLine("Cosmetic=@Cosmetic,");
sqllink.AppendLine("Nature=@Nature,");
sqllink.AppendLine("Appearance=@Appearance,");
sqllink.AppendLine("AdoutBody=@AdoutBody,");
sqllink.AppendLine("AboutFamily=@AboutFamily,");
sqllink.AppendLine("Car=@Car,");
sqllink.AppendLine("LiveHouse=@LiveHouse,");
sqllink.AppendLine(" ProfessionalDes=@ProfessionalDes ");
sqllink.AppendLine(" WHERE ");
sqllink.AppendLine("ID = @ID ");
sqllink.AppendLine("and CompanyCD = @CompanyCD ");
#endregion
#region 设置修改联系人信息参数
SqlParameter[] param = new SqlParameter[55];
param[0] = SqlHelper.GetParameter("@CompanyCD", LinkManM.CompanyCD);
param[1] = SqlHelper.GetParameter("@ID", LinkManM.ID);
param[2] = SqlHelper.GetParameter("@LinkManName", LinkManM.LinkManName);
param[3] = SqlHelper.GetParameter("@Sex", LinkManM.Sex);
param[4] = SqlHelper.GetParameter("@Important", LinkManM.Important);
param[5] = SqlHelper.GetParameter("@Company", LinkManM.Company);
param[6] = SqlHelper.GetParameter("@Appellation", LinkManM.Appellation);
param[7] = SqlHelper.GetParameter("@Department", LinkManM.Department);
param[8] = SqlHelper.GetParameter("@Position", LinkManM.Position);
param[9] = SqlHelper.GetParameter("@Operation", LinkManM.Operation);
param[10] = SqlHelper.GetParameter("@WorkTel", LinkManM.WorkTel);
param[11] = SqlHelper.GetParameter("@Fax", LinkManM.Fax);
param[12] = SqlHelper.GetParameter("@Handset", LinkManM.Handset);
param[13] = SqlHelper.GetParameter("@MailAddress", LinkManM.MailAddress);
param[14] = SqlHelper.GetParameter("@HomeTel", LinkManM.HomeTel);
param[15] = SqlHelper.GetParameter("@MSN", LinkManM.MSN);
param[16] = SqlHelper.GetParameter("@QQ", LinkManM.QQ);
param[17] = SqlHelper.GetParameter("@Post", LinkManM.Post);
param[18] = SqlHelper.GetParameter("@HomeAddress", LinkManM.HomeAddress);
param[19] = SqlHelper.GetParameter("@Remark", LinkManM.Remark);
param[20] = SqlHelper.GetParameter("@Age", LinkManM.Age);
param[21] = SqlHelper.GetParameter("@Likes", LinkManM.Likes);
param[22] = SqlHelper.GetParameter("@LinkType", LinkManM.LinkType);
param[23] = SqlHelper.GetParameter("@Birthday", LinkManM.Birthday == null ? SqlDateTime.Null : SqlDateTime.Parse(LinkManM.Birthday.ToString()));
//param[23] = SqlHelper.GetParameter("@Birthday", LinkManM.Birthday = DateTime.Now);
param[24] = SqlHelper.GetParameter("@PaperType", LinkManM.PaperType);
param[25] = SqlHelper.GetParameter("@PaperNum", LinkManM.PaperNum);
param[26] = SqlHelper.GetParameter("@Photo", LinkManM.Photo);
param[27] = SqlHelper.GetParameter("@ModifiedDate", LinkManM.ModifiedDate);
param[28] = SqlHelper.GetParameter("@ModifiedUserID", LinkManM.ModifiedUserID);
param[29] = SqlHelper.GetParameter("@CanViewUser", LinkManM.CanViewUser);
param[30] = SqlHelper.GetParameter("@CanViewUserName", LinkManM.CanViewUserName);
param[31] = SqlHelper.GetParameter("@HomeTown", LinkManM.HomeTown);
param[32] = SqlHelper.GetParameter("@NationalID", LinkManM.NationalID == null ? SqlInt32.Null : int.Parse(LinkManM.NationalID));
param[33] = SqlHelper.GetParameter("@Birthcity", LinkManM.birthcity == "" ? "" : LinkManM.birthcity);
param[34] = SqlHelper.GetParameter("@CultureLevel", LinkManM.CultureLevel == null ? SqlInt32.Null : int.Parse(LinkManM.CultureLevel));
param[35] = SqlHelper.GetParameter("@Professional", LinkManM.Professional == null ? SqlInt32.Null : int.Parse(LinkManM.Professional));
param[36] = SqlHelper.GetParameter("@GraduateSchool", LinkManM.GraduateSchool);
param[37] = SqlHelper.GetParameter("@IncomeYear", LinkManM.IncomeYear);
param[38] = SqlHelper.GetParameter("@FuoodDrink", LinkManM.FuoodDrink);
param[39] = SqlHelper.GetParameter("@LoveMusic", LinkManM.LoveMusic);
param[40] = SqlHelper.GetParameter("@LoveColor", LinkManM.LoveColor);
param[41] = SqlHelper.GetParameter("@LoveSmoke", LinkManM.LoveSmoke);
param[42] = SqlHelper.GetParameter("@LoveDrink", LinkManM.LoveDrink);
param[43] = SqlHelper.GetParameter("@LoveTea", LinkManM.LoveTea);
param[44] = SqlHelper.GetParameter("@LoveBook", LinkManM.LoveBook);
param[45] = SqlHelper.GetParameter("@LoveSport", LinkManM.LoveSport);
param[46] = SqlHelper.GetParameter("@LoveClothes", LinkManM.LoveClothes);
param[47] = SqlHelper.GetParameter("@Cosmetic", LinkManM.Cosmetic);
param[48] = SqlHelper.GetParameter("@Nature", LinkManM.Nature);
param[49] = SqlHelper.GetParameter("@Appearance", LinkManM.Appearance);
param[50] = SqlHelper.GetParameter("@AdoutBody", LinkManM.AdoutBody);
param[51] = SqlHelper.GetParameter("@AboutFamily", LinkManM.AboutFamily);
param[52] = SqlHelper.GetParameter("@Car", LinkManM.Car);
param[53] = SqlHelper.GetParameter("@LiveHouse", LinkManM.LiveHouse);
param[54] = SqlHelper.GetParameter("@ProfessionalDes", LinkManM.ProfessionalDes);
#endregion
SqlHelper.ExecuteTransSql(sqllink.ToString(), param);
return SqlHelper.Result.OprateCount > 0 ? true : false;
}
catch
{
return false;
}
}
/// <summary>
/// 导出联系人列表
/// </summary>
/// <param name="CustNam"></param>
/// <param name="LinkManM"></param>
/// <param name="BeginDate"></param>
/// <param name="EndDate"></param>
/// <param name="ord"></param>
/// <returns></returns>
public static DataTable ExportLinkManInfo(string CustNam, LinkManModel LinkManM, string BeginDate, string EndDate, string ord)
{
return LinkManDBHelper.ExportLinkManInfo(CustNam, LinkManM, BeginDate, EndDate, ord);
}
/// <summary>
/// 增加客户联系人的方法
/// </summary>
/// <param name="CustModel">客户联系人Model</param>
/// <returns>bool值</returns>
public static int LinkManAdd(LinkManModel LinkManModel)
{
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
LogInfoModel logModel = new LogInfoModel(); //操作日志
int isSucc = 0;//定义返回变量
#region 设置操作日志内容
//设置公司代码
logModel.CompanyCD = userInfo.CompanyCD;
//设置登陆用户ID
logModel.UserID = userInfo.UserID;
//设置模块ID 模块ID在ConstUtil中定义，以便维护
logModel.ModuleID = ConstUtil.MODULE_ID_CUST_LINK_ADD;
//操作单据编号 联系人姓名
logModel.ObjectID = LinkManModel.LinkManName;
//操作对象 操作的表信息
logModel.ObjectName = ConstUtil.TABLE_NAME_LISIMAN;
//涉及关键元素 涉及其他业务、表关系
logModel.Element = string.Empty;
//备注 操作类型
logModel.Remark = ConstUtil.LOG_PROCESS_INSERT;
#endregion
try
{
isSucc = LinkManDBHelper.LinkManAdd(LinkManModel);
}
catch (System.Exception ex)
{
#region 操作失败时记录日志到文件
//定义变量
LogInfo logSys = new LogInfo();
//设置日志类型 需要指定为系统日志
logSys.Type = LogInfo.LogType.SYSTEM;
//指定系统日志类型 出错信息
logSys.SystemKind = LogInfo.SystemLogKind.SYSTEM_ERROR;
//指定登陆用户信息
logSys.UserInfo = userInfo;
//设定模块ID
logSys.ModuleID = ConstUtil.MODULE_ID_CUST_LINK_ADD;
//描述
logSys.Description = ex.ToString();
//输出日志
LogUtil.WriteLog(logSys);
#endregion
}
if (isSucc >0 )//操作成功
{
logModel.Remark += "成功";
}
else//操作失败
{
logModel.Remark += "失败";
}
//记录日志
LogDBHelper.InsertLog(logModel);
return isSucc;
}
/// <summary>
/// 根据查询条件获取联系人列表信息的方法
/// </summary>
/// <param name="LinkManM">查询条件</param>
/// <param name="Manager">登陆人</param>
/// <returns>联系人列表结果集</returns>
public static DataTable GetLinkManInfoBycondition(string CustNam, LinkManModel LinkManM, string BeginDate, string EndDate, int pageIndex, int pageCount, string ord, ref int TotalCount)
{
try
{
return LinkManDBHelper.GetLinkManInfoBycondition(CustNam, LinkManM,BeginDate,EndDate, pageIndex, pageCount, ord, ref TotalCount);
}
catch
{
return null;
}
}
