public ActionResult EditCase(string caseId)
{
LinkMan model = IRegisterInfo.GetLinManModelById(caseId);
if (model == null)
{
return(View());
}
else
{
LinkManModel viewModel = new LinkManModel()
{
Address = model.Address,
Birthday = model.Birthday,
Career = model.Career,
Email = model.Email,
IdCardNo = model.IdCardNo,
LinkManName = model.LinkManName,
OtherLink = model.OtherLink,
Phone = model.Phone,
QQ = model.QQ,
Relationship = model.Relationship,
Remark = model.Remark,
Sex = model.Sex,
TelPhone = model.TelPhone,
WeiXin = model.WeiXin,
LinkManID = model.LinkManID
};
return(View(viewModel));
}
}
/// <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
{
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, " +
" cust.CustBig,cust.CustNo,cust.CanViewUser,cust.Manager,cust.Creator " +
" from " +
" officedba.custlinkman link" +
" left join officedba.custinfo cust on cust.custno = link.custno and cust.companycd = link.companycd" +
" 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 = '******')";
//" and cust.Manager = '"+ Manager +"'";
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.CreateSqlByPageExcuteSql(sql.ToString(), pageIndex, pageCount, ord, null, ref TotalCount));
}
catch (Exception ex)
{
string sss = ex.Message;
return(null);
}
}
/// <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);
}
}
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>");
}
}
public ActionResult EditLinManInfo(LinkManModel model)
{
try
{
if (ModelState.IsValid)
{
LinkMan LinManmodel = IRegisterInfo.GetLinManModelById(model.RegisterInfoId);
if (LinManmodel == null)
{
// 新建
LinkMan linkMan = new LinkMan()
{
Address = model.Address,
Birthday = model.Birthday,
Career = model.Career,
CreateDateTime = DateTime.Now,
Email = model.Email,
IdCardNo = model.IdCardNo,
LinkManID = System.Guid.NewGuid().ToString(),
LinkManName = model.LinkManName,
OtherLink = model.OtherLink,
Phone = model.Phone,
QQ = model.QQ,
RegisterInfoId = model.RegisterInfoId,
Relationship = model.Relationship,
Remark = model.Remark,
Sex = model.Sex,
TelPhone = model.TelPhone,
WeiXin = model.WeiXin
};
if (IRegisterInfo.CreateLinkMan(linkMan))
{
ViewBag.Message = "添加联系人成功";
return(View("EditLinManInfo"));
}
}
else
{
// 编辑信息
LinManmodel.Address = model.Address;
LinManmodel.Birthday = model.Birthday;
LinManmodel.Career = model.Career;
LinManmodel.CreateDateTime = DateTime.Now;
LinManmodel.Email = model.Email;
LinManmodel.IdCardNo = model.IdCardNo;
LinManmodel.LinkManID = model.LinkManID;
LinManmodel.LinkManName = model.LinkManName;
LinManmodel.OtherLink = model.OtherLink;
LinManmodel.Phone = model.Phone;
LinManmodel.QQ = model.QQ;
LinManmodel.RegisterInfoId = model.RegisterInfoId;
LinManmodel.Relationship = model.Relationship;
LinManmodel.Remark = model.Remark;
LinManmodel.Sex = model.Sex;
LinManmodel.TelPhone = model.TelPhone;
LinManmodel.WeiXin = model.WeiXin;
if (IRegisterInfo.UpdateLinkMan(LinManmodel))
{
ViewBag.Message = "修改联系人成功";
return(View("EditLinManInfo"));
}
}
}
ViewBag.Message = "修改联系人失败";
return(View(model));
}
catch (Exception e)
{
ViewBag.Message = e.Message;
return(View(model));
}
}
/// <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="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);
}
}
