/// <summary> /// 共享名录 /// </summary> private void Share() { string ciids = nv["ids"]; if (!MLMGC.COMP.StringUtil.IsStringArrayList(ciids))//判断格式是否正确 格式:1,21,321 { HttpContext.Current.Response.Write("参数错误"); return; } E_ClientInfo data = new E_ClientInfo(); data.EnterpriseID = bp.EnterpriceID; data.EPUserTMRID = bp.EPUserTMRID; data.Mode = EnumClientMode.共享; data.Status = EnumClientStatus.共享; data.ClientInfoIDs = ciids; bool b = new T_ClientInfo().UpdateMode(data); //添加操作日志 new MLMGC.BLL.Enterprise.T_Log().Add(new MLMGC.DataEntity.Enterprise.E_Log() { EnterpriseID = bp.EnterpriceID, UserID = bp.UserID, LogTitle = "共享名录", IP = MLMGC.COMP.Requests.GetRealIP() }); HttpContext.Current.Response.Write(b ? "1" : "0"); }
/// <summary> /// 删除某状态下所有名录 /// </summary> private void DeleteAll() { int mode, status; if (!int.TryParse(nv["mode"], out mode) || !int.TryParse(nv["status"], out status)) { HttpContext.Current.Response.Write("参数错误"); return; } E_ClientInfo data = new E_ClientInfo(); data.EnterpriseID = bp.EnterpriceID; data.EPUserTMRID = bp.EPUserTMRID; data.TeamID = bp.TeamID; data.SetMode = mode; data.SetStatus = status; bool flag = new T_ClientInfo().DeleteAll(data); //添加操作日志 new MLMGC.BLL.Enterprise.T_Log().Add(new MLMGC.DataEntity.Enterprise.E_Log() { EnterpriseID = bp.EnterpriceID, UserID = bp.UserID, LogTitle = "删除名录", IP = MLMGC.COMP.Requests.GetRealIP() }); HttpContext.Current.Response.Write(flag ? "1" : "0"); }
/// <summary> /// 修改状态 /// </summary> private void UpdateStatus() { E_ClientInfo data = new E_ClientInfo(); data.PersonalID = bp.PersonalID; data.ClientInfoID = Convert.ToInt32(nv["id"]); data.SetStatus = Convert.ToInt32(nv["status"]); if (data.Status == EnumClientStatus.所有状态)//判断是否是可用状态 { HttpContext.Current.Response.Write("参数错误啦"); return; } if (data.Status == EnumClientStatus.意向客户) { data.WishID = Convert.ToInt32(nv["wishid"]); } else if (data.Status == EnumClientStatus.成交客户) { data.TradedMoney = float.Parse(nv["money"]); } else if (data.Status == EnumClientStatus.失败客户) { data.NotTradedID = Convert.ToInt32(nv["nottradedid"]); } else if (data.Status == EnumClientStatus.报废客户) { data.ScrapID = Convert.ToInt32(nv["scrapid"]); } bool b = new T_ClientInfo().UpdateStatus(data); HttpContext.Current.Response.Write(b ? "1" : "0"); }
/* * /// <summary> * /// 初始化配置信息 * /// </summary> * private static void InitConfig() * { * enterprisecode = ConfigurationManager.AppSettings["EnterpriseCode"]; * enterprisename = ConfigurationManager.AppSettings["EnterpriseName"]; * itemname = ConfigurationManager.AppSettings["ItemName"]; * useramount = Convert.ToInt32(ConfigurationManager.AppSettings["UserAmount"]); * startdate = Convert.ToDateTime(ConfigurationManager.AppSettings["StartDate"]); * expiredate = Convert.ToDateTime(ConfigurationManager.AppSettings["ExpireDate"]); * adminusername = ConfigurationManager.AppSettings["AdminUserName"]; * adminpassword = ConfigurationManager.AppSettings["AdminPassword"]; * * teammodelid = Convert.ToInt32(ConfigurationManager.AppSettings["TeamModelID"]); * teamscalexml = ConfigurationManager.AppSettings["TeamScaleXml"]; * } * * /// <summary> * /// 开始添加测试数据 * /// </summary> * private static void StartProgram() * { * Console.WriteLine("请输入要添加的企业数量:"); * string content = Console.ReadLine(); * int num; * while(!int.TryParse(content, out num)) * { * Console.WriteLine("输入错误请继续:"); * content = Console.ReadLine(); * } * * string code=enterprisecode; * string name=enterprisename; * //InsertData(code, name); * for (int i = 0; i < num; i++) * { * //Console.WriteLine(string .Format("第{0}个企业",i+1)); * code = code.Substring(0, 4) + (Convert.ToInt32(code.Substring(4)) + 1).ToString(); * name = name.Substring(0, 2) + (Convert.ToInt32(name.Substring(2)) + 1).ToString(); * if (!InsertData(code, name)) * { * Console.WriteLine("出错"); * new Log().WriteLog("出错"); * break; * } * } * //然后把最后的企业号修改到配置文件中,为了下次可直接运行。 * Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None); * AppSettingsSection appsection = (AppSettingsSection)config.GetSection("appSettings"); * appsection.Settings["EnterpriseCode"].Value = code; * appsection.Settings["EnterpriseName"].Value = name; * config.Save(); * } * * /// <summary> * /// 插入数据 * /// </summary> * /// <returns></returns> * private static bool InsertData(string code,string name) * { * bool flag; * int EnterpriseID = new Program().AddEnterprise(code,name); * if (EnterpriseID <= 0) * { * new Log().WriteLog("添加企业基本信息失败"); * Console.WriteLine("添加企业基本信息失败"); * return false; * } * * flag = new Program().AddUser(EnterpriseID); * if (!flag) * { * new Log().WriteLog("添加用户失败"); * Console.WriteLine("添加用户失败"); * return false; * } * * flag = new Program().AddClientInfo(EnterpriseID, name); * if (!flag) * { * new Log().WriteLog("添加名录失败"); * Console.WriteLine("添加名录失败"); * return false; * } * return true; * } * * /// <summary> * /// 添加企业 * /// </summary> * /// <returns></returns> * private int AddEnterprise(string code,string name) * { * int EnterpriseID = 0; * //---添加企业---- * E_Enterprise EPdata = new E_Enterprise(); * EPdata.EnterpriseCode = code; * EPdata.EnterpriseNames = name; * EPdata.ItemName = itemname; * EPdata.UserAmount = useramount; * EPdata.StartDate = startdate; * EPdata.ExpireDate = expiredate; * EPdata.AdminUserName = adminusername; * EPdata.AdminPassword = MLMGC.COMP.EncryptString.EncryptPassword(adminpassword); * * DateTime now = DateTime.Now; * EnterpriseID = new DataSql().Add(EPdata); * Console.WriteLine("添加企业时间:" + (DateTime.Now - now).TotalMilliseconds.ToString()); * if (EnterpriseID == 0) * { * //new Log().WriteLog("添加企业出错"); * //Console.WriteLine("添加企业出错"); * return 0; * } * * new Log().WriteLog("添加企业成功,企业号:" + EnterpriseID.ToString()); * Console.WriteLine("添加企业成功,企业号:" + EnterpriseID.ToString()); * //------------------- * * //------------设置企业团队模型------------ * E_TeamModel TMdata = new E_TeamModel(); * TMdata.EnterpriseID = EnterpriseID; * TMdata.TeamModelID = teammodelid; * now = DateTime.Now; * int result = new DataSql().SetTeamModel(TMdata); * Console.WriteLine("设置团队模型时间:" + (DateTime.Now - now).TotalMilliseconds.ToString()); * if (result <= 0) * { * //new Log().WriteLog("设置团队模型出错"); * //Console.WriteLine("设置团队模型出错"); * return 0; * } * //new Log().WriteLog("设置团队模型成功"); * //Console.WriteLine("设置团队模型成功"); * //--------------------------------------- * * //----------设置企业团队规模--------- * E_TeamModel data = new E_TeamModel(); * data.EnterpriseID = EnterpriseID; * data.TeamScaleXml = teamscalexml; * data.Child_RoleID = "3,4";//经理roleid 3,组长roleid 4; * data.Child_RoleAmount = "2,4";//经理 2,组长 3; * result = new DataSql().UpdateTeamScale(data); * if (result < 0) * { * //new Log().WriteLog("设置企业团队规模出错"); * //Console.WriteLine("设置企业团队规模出错"); * return 0; * } * //new Log().WriteLog("设置企业团队规模成功"); * //Console.WriteLine("设置企业团队规模成功"); * //---------------------------------- * * //---------修改团队信息(指定上级)---------- * string sql = string.Format("UPDATE dbo.EP_B_Team SET pid= 3 WHERE EnterpriseID={0} AND TeamType=2 AND TeamModelRoleID =9;UPDATE t SET t.pid = 2 FROM (SELECT TOP 2 * FROM dbo.EP_B_Team WHERE EnterpriseID={0} AND TeamType=2 AND TeamModelRoleID =9) t;", EnterpriseID); * //new Log().WriteLog(sql); * //Console.WriteLine(sql); * now = DateTime.Now; * DbHelperSQL.ExecuteSql(sql); * Console.WriteLine("修改团队上级时间:" + (DateTime.Now - now).TotalMilliseconds.ToString()); * //new Log().WriteLog("修改团队信息完成"); * //Console.WriteLine("修改团队信息完成"); * //----------------------------------------- * * //new Log().WriteLog("添加企业完成"); * //Console.WriteLine("添加企业完成"); * return EnterpriseID; * } * * /// <summary> * /// 添加企业用户 * /// </summary> * /// <returns></returns> * private bool AddUser(int EnterpriseID) * { * if (EnterpriseID == 0) * { * new Log().WriteLog("没有企业号"); * Console.WriteLine("没有企业号"); * return false; * } * E_User data = new E_User(); * data.EnterpriseID = EnterpriseID; * data.UserName = "******"; * data.Password = MLMGC.COMP.EncryptString.EncryptPassword("123456"); * data.UserType = (int)UserType.企业用户; * data.TrueName = "总监"; * data.RoleSetting = "7:1"; * if (new DataSql().AddEnterpriseUser(data) < 1) * { * new Log().WriteLog("添加总监失败"); * Console.WriteLine("添加总监失败"); * return false ; * } * //new Log().WriteLog("添加总监成功"); * //Console.WriteLine("添加总监成功"); * * //经理 * for (int i = 0; i < 2; i++) * { * data.UserName = string.Format("jili{0}", i + 1); * data.TrueName = string.Format("经理{0}", i + 1); * data.RoleSetting = string.Format("8:{0}", i + 2); * if (new DataSql().AddEnterpriseUser(data) < 1) * { * new Log().WriteLog(string.Format("添加经理{0}失败",i+1)); * Console.WriteLine(string.Format("添加经理{0}失败", i + 1)); * return false; * } * //new Log().WriteLog(string.Format("添加经理{0}成功", i + 1)); * //Console.WriteLine(string.Format("添加经理{0}成功", i + 1)); * } * * //组长 * * for (int i = 0; i < 4; i++) * { * data.UserName = string.Format("zuzhang{0}", i + 1); * data.TrueName = string.Format("组长{0}", i + 1); * data.RoleSetting = string.Format("9:{0}", i+4); * if (new DataSql().AddEnterpriseUser(data) < 1) * { * new Log().WriteLog(string.Format("添加组长{0}失败", i + 1)); * Console.WriteLine(string.Format("添加组长{0}失败", i + 1)); * return false; * } * //new Log().WriteLog(string.Format("添加组长{0}成功", i + 1)); * //Console.WriteLine(string.Format("添加组长{0}成功", i + 1)); * } * * //业务员 * for (int i = 0; i < 100; i++) * { * data.UserName = string.Format("yewuyuan{0}", i + 1); * data.TrueName = string.Format("业务员{0}", i + 1); * data.RoleSetting = string.Format("10:{0}", i/25 + 4); * DateTime now = DateTime.Now; * if (new DataSql().AddEnterpriseUser(data) < 1) * { * new Log().WriteLog(string.Format("添加业务员{0}失败", i + 1)); * Console.WriteLine(string.Format("添加业务员{0}失败", i + 1)); * return false; * } * double d =(DateTime.Now - now).TotalMilliseconds; * if(d>=250) * Console.WriteLine("添加一个业务员时间:" + d.ToString ()); * //new Log().WriteLog(string.Format("添加业务员{0}成功", i + 1)); * //Console.WriteLine(string.Format("添加业务员{0}成功", i + 1)); * } * //new Log().WriteLog("添加用户完成"); * //Console.WriteLine("添加用户完成"); * return true; * } * * /// <summary> * /// 添加名录 * /// </summary> * /// <returns></returns> * private bool AddClientInfo(int EnterpriseID, string name) * { * if (EnterpriseID == 0) * { * new Log().WriteLog("没有企业号"); * Console.WriteLine("没有企业号"); * return false; * } * bool flag; * //查询所有业务员 * string sql = string.Format("select EPUserTMRID from EP_R_EPUserTMR where EnterpriseID ={0} and TeamModelRoleID =10", EnterpriseID); * DataTable dt = DbHelperSQL.Query(sql).Tables[0]; * if (dt == null) * { * new Log().WriteLog("没有找到业务员"); * Console.WriteLine("没有找到业务员"); * return false; * } * int EPUserTMRID = 0; * * E_ClientInfo data = new E_ClientInfo(); * data.EnterpriseID = EnterpriseID; * foreach (DataRow row in dt.Rows) * { * EPUserTMRID = Convert.ToInt32(row["EPUserTMRID"]); * data.EPUserTMRID = EPUserTMRID; * Console.WriteLine(data.EPUserTMRID); * DateTime now = DateTime.Now; * for (int i = 0; i < 40000; i++) //每个人5条名录 * { * data.ClientName = string.Format("{0}{1}{2}", name, EPUserTMRID, i); * flag = new DataSql().Add(data); * if (!flag) * { * new Log().WriteLog(string.Format("添加{0}的第{1}个名录出错", EPUserTMRID, i)); * Console.WriteLine(string.Format("添加{0}的第{1}个名录出错", EPUserTMRID, i)); * return false; * } * } * Console.WriteLine((DateTime.Now - now).TotalSeconds.ToString()); * } * //Console.WriteLine("添加名录完成"); * //new Log().WriteLog("添加名录完成"); * return true; * } * */ #endregion #region 个人 /// <summary> /// 添加名录 /// </summary> /// <returns></returns> public static bool AddClientInfo(string name, int num) { E_ClientInfo data = new E_ClientInfo(); T_ClientInfo bll = new T_ClientInfo(); data.PersonalID = 9; Console.WriteLine("开始添加:" + DateTime.Now.ToShortTimeString()); new Log().WriteLog("开始添加:" + DateTime.Now.ToShortTimeString()); bool flag = false; for (int i = 1; i <= num; i++) { data.ClientName = string.Format("{0}{1}", name, i); flag = bll.Add(data); if (!flag) { Console.WriteLine("添加出错!"); new Log().WriteLog("添加出错!"); break; } if (i % 1000 == 0) { Console.WriteLine(string.Format("已经添加{0}条,时间:{1}", i, DateTime.Now.ToShortTimeString())); } } Console.WriteLine("添加完成:" + DateTime.Now.ToShortTimeString()); new Log().WriteLog("添加完成:" + DateTime.Now.ToShortTimeString()); return(flag); }
/// <summary> /// 导入名录信息 /// </summary> /// <param name="shtClient"></param> /// <returns></returns> private bool ImportClient(HSSFSheet shtClient) { int count = shtClient.LastRowNum; int succNum = 0, errorNum = 0; HSSFRow row; T_ClientInfo bll = new T_ClientInfo(); E_ClientInfo data; for (int i = 1; i <= count; ++i) { if (ISCheckRowStrNullOrEmpty(i, shtClient)) { continue; } row = shtClient.GetRow(i); data = new E_ClientInfo(); data.PersonalID = _personalid; data.ClientName = GetCellValue(row.GetCell(0)); //名称 data.Address = GetCellValue(row.GetCell(1)); //地址 data.ZipCode = GetCellValue(row.GetCell(2)); //邮编 data.Linkman = GetCellValue(row.GetCell(3)); //联系人 data.Position = GetCellValue(row.GetCell(4)); //职务 data.Tel = GetCellValue(row.GetCell(5)); //电话 data.Mobile = GetCellValue(row.GetCell(6)); //手机 data.Fax = GetCellValue(row.GetCell(7)); //传真 data.Website = GetCellValue(row.GetCell(8)); //网址 data.Email = GetCellValue(row.GetCell(9)); //邮箱 data.QQ = GetCellValue(row.GetCell(10)); //QQ data.MSN = GetCellValue(row.GetCell(11)); //MSN data.SourceName = GetCellValue(row.GetCell(12)); //来源编码 data.TradeName = GetCellValue(row.GetCell(13)); //行业编码 data.AreaName = GetCellValue(row.GetCell(14)); //地区编码 data.Remark = GetCellValue(row.GetCell(15)); //备注 //判断名录名是否存在 bool flag = bll.Exists(new E_ClientInfo() { PersonalID = _personalid, ClientName = data.ClientName, ClientInfoID = 0 }); if (flag) { _result.Add(string.Format("[{0}]已经导入数据库! 位置[{1}]中,第{2}行", data.ClientName, strClientName, i)); ++errorNum; continue; } //名录写入数据库 if (bll.Add(data))//判断名录写入成功与失败 { ++succNum; } else { ++errorNum; } } _result.Add(string.Format("成功导入{0}条,失败{1}条。", succNum, errorNum)); return(errorNum == 0); }
/// <summary> /// 绑定页面数据 /// </summary> protected void databind() { int ciid = Requests.GetQueryInt("ciid", 0); //-----------------绑定基本信息------------------------------ E_ClientInfo data = new T_ClientInfo().GetModel(new E_ClientInfo() { EnterpriseID = EnterpriceID, ClientInfoID = ciid, EPUserTMRID = 0 }); if (data == null) { Jscript.AlertAndRedirect(this, "信息不存在", "ClientInfoSearch.aspx"); return; } ltClientName.Text = data.ClientName; ltAddress.Text = data.Address; ltZipCode.Text = data.ZipCode; ltLinkman.Text = data.Linkman; ltPosition.Text = data.Position; ltEmail.Text = data.Email; ltTel.Text = data.Tel; ltMobile.Text = data.Mobile; hlWebsite.NavigateUrl = data.Website.IndexOf("http://") == -1?"http://" + data.Website:data.Website; hlWebsite.Text = data.Website; ltFax.Text = data.Fax; ltRemark.Text = data.Remark; //-----------------绑定名录属性------------------------------ Property1.SourceID = data.SourceID; Property1.TradeID = data.TradeID; Property1.AreaID = data.AreaID; //-----------------绑定状态------------------------------ ltStatus.Text = data.Status.ToString(); //hdStatus.Value = ((int)data.Status).ToString(); ////----------------绑定沟通记录--------------------- //rpExchangeList.DataSource = new T_Exchange().GetList(new E_Exchange() { EnterpriseID = EnterpriceID, ClientItemID = ciid }); //rpExchangeList.DataBind(); //----------------调查问卷---------------- DataSet ds = new T_Question().List(new MLMGC.DataEntity.Enterprise.Material.E_Question() { EnterpriseID = EnterpriceID, ClientInfoID = ciid }); if (ds != null && ds.Tables.Count == 2) { dtItem = ds.Tables[1]; rpList.DataSource = ds.Tables[0]; rpList.DataBind(); } //----------------获取当前用户角色信息---------------- int roleid = new T_User().GetEPRoleID(new E_EnterpriseUser() { EnterpriseID = EnterpriceID, EPUserTMRID = EPUserTMRID }); btnMyGet.Visible = (roleid == (int)EnumRole.销售人员); IsShowExchange = !(roleid == (int)EnumRole.销售人员);//销售人员不能查看沟通记录 }
/// <summary> /// 判断手机或电话号码是否存在 /// </summary> private void ExistsContact() { string type = nv["type"]; string value = nv["value"].Trim(); bool b = false; if (type == "1") { Regex m = new Regex(@"^1(3|5|8)+\d{9}$");//验证手机号 b = m.IsMatch(value); } else { Regex t = new Regex(@"^(0[0-9]{2,3}\-)?([2-9][0-9]{6,7})+(\-[0-9]{1,4})?$");//验证电话 b = t.IsMatch(value); } if (!b || string.IsNullOrWhiteSpace(type)) { HttpContext.Current.Response.Write("参数错误"); return; } int ciid = 0; int.TryParse(nv["ciid"], out ciid); E_ClientInfo data = new E_ClientInfo(); data.PersonalID = bp.PersonalID; data.ClientInfoID = ciid; data.Type = Convert.ToInt32(type); data.Value = value; DataTable dt = new T_ClientInfo().ExistsContact(data); string result = string.Empty; bool flag = false; if (dt != null && dt.Rows.Count == 1) { int mode = Convert.ToInt32(dt.Rows[0]["Flag"]); switch (mode) { case -1: flag = true; result = "这个号码可以使用!"; break; case 1: result = string.Format("该{0}号码已存在,所在名录:{1}", type == "1" ? "手机" : "电话", dt.Rows[0]["Name"].ToString()); break; } } JsonObjectCollection colDR = new JsonObjectCollection(); colDR.Add(new JsonStringValue("flag", flag ? "1" : "0")); colDR.Add(new JsonStringValue("detail", result)); HttpContext.Current.Response.Write(colDR.ToString()); }
/// <summary> /// 页面初始化加载数据 /// </summary> protected void databind() { E_ClientInfo data = new E_ClientInfo(); data.EnterpriseID = EnterpriceID; data.TeamID = TeamID; data.ClientName = Requests.GetQueryString("keyword"); txtKeyword.Text = data.ClientName; //分页参数 data.Page = new MLMGC.DataEntity.E_Page(); data.Page.PageSize = pageSize; data.Page.PageIndex = pageIndex; DataSet ds = new T_ClientInfo().LeaderList(data); if (ds != null && ds.Tables.Count > 1)//判断是否有数据返回 { //绑定列表 rpList.DataSource = ds.Tables[0]; rpList.DataBind(); //绑定统计 DataTable dt = MLMGC.COMP.EnumUtil.ToTable <EnumClientStatus>(); //过虑 “所有状态”,"共享" 二项 dt.Rows.Remove(dt.Select("name='" + EnumClientStatus.所有状态 + "'")[0]); dt.Rows.Remove(dt.Select("name='" + EnumClientStatus.共享 + "'")[0]); dt.Columns.Add("Amount", typeof(int)); dt.Columns.Add("Percentage", typeof(string)); foreach (DataRow dr in dt.Rows) { if (ds.Tables[1].Select("Status=" + dr["id"]).Count() > 0) { dr["Amount"] = ds.Tables[1].Select("[Status]=" + dr["id"])[0]["Amount"]; dr["Percentage"] = ds.Tables[1].Select("[Status]=" + dr["id"])[0]["Percentage"]; } else { dr["Amount"] = "0"; dr["Percentage"] = "0.00"; } } //绑定列表 rpStatistics.DataSource = dt; rpStatistics.DataBind(); } //设置分页样式 pageList1.PageSize = pageSize; pageList1.CurrentPageIndex = pageIndex; pageList1.RecordCount = data.Page.TotalCount; pageList1.CustomInfoHTML = string.Format("共有记录 <span class='red_font'>{0}</span> 条", pageList1.RecordCount); pageList1.TextAfterPageIndexBox = " 页/" + pageList1.PageCount + " "; }
/// <summary> /// 判断名录是否存在 /// </summary> private void Exists() { E_ClientInfo data = new E_ClientInfo(); data.PersonalID = bp.PersonalID; data.ClientName = nv["clientname"]; string clientinfoid = nv["clientinfoid"]; data.ClientInfoID = Convert.ToInt32(clientinfoid ?? "0"); bool flag = new T_ClientInfo().Exists(data); HttpContext.Current.Response.Write(flag ? "1" : "0"); }
protected void btnExport_Click(object sender, EventArgs e) { bool b = false; T_ClientInfo bll = new T_ClientInfo(); E_ClientInfo data = new E_ClientInfo(); data.PersonalID = PersonalID; data.SetStatus = int.Parse(rblStatus.SelectedValue.ToString()); DataSet ds = bll.DataExport(data); Jscript.ShowMsg(b ? "导出成功" : "操作失败", this); ExportDataSet(ds, "导出——" + DateTime.Now.ToString("yyyyMMddHHss") + "(" + data.Status.ToString() + ")", new List <string>() { "名录信息", "来源信息", "行业信息", "地区信息" }); }
/// <summary> /// 批量删除名录 /// </summary> private void Delete() { string ids = nv["ids"]; if (MLMGC.COMP.StringUtil.IsStringArrayList(ids)) { E_ClientInfo data = new E_ClientInfo(); data.PersonalID = bp.PersonalID; data.ClientInfoIDs = ids; bool b = new T_ClientInfo().BatchDelete(data); HttpContext.Current.Response.Write(b ? "1" : "0"); } else { HttpContext.Current.Response.Write("参数错误"); } }
/// <summary> /// 绑定页面数据 /// </summary> protected void databind() { int clientinfoid = Requests.GetQueryInt("id", 0); //Operate1.ClientItemID = ciid; //-----------------绑定基本信息------------------------------ E_ClientInfo data = new T_ClientInfo().GetModel(new E_ClientInfo() { PersonalID = PersonalID, ClientInfoID = clientinfoid }); if (data == null) { Jscript.AlertAndRedirect(this, "无权限查看信息", "Search.aspx"); return; } #region info的绑定 lblClientName.Text = data.ClientName; lblAddress.Text = data.Address; lblZipCode.Text = data.ZipCode; lblLinkman.Text = data.Linkman; lblPosition.Text = data.Position; lblEmail.Text = data.Email; lblTel.Text = data.Tel; lblMobile.Text = data.Mobile; hlWebsite.NavigateUrl = data.Website.IndexOf("http://") == -1 ? "http://" + data.Website : data.Website; hlWebsite.Text = data.Website; lblFax.Text = data.Fax; lblQQ.Text = data.QQ; lblMSN.Text = data.MSN; lblRemark.Text = data.Remark; #endregion txtClientName.Text = data.ClientName; txtAddress.Text = data.Address; txtZipCode.Text = data.ZipCode; txtLinkman.Text = data.Linkman; txtPosition.Text = data.Position; txtEmail.Text = data.Email; txtTel.Text = data.Tel; txtMobile.Text = data.Mobile; txtFax.Text = data.Fax; txtWebsite.Text = data.Website; txtQQ.Text = data.QQ; txtMSN.Text = data.MSN; txtRemark.Text = data.Remark; //-----------------绑定名录属性------------------------------ Property1.SourceID = data.SourceID; Property1.TradeID = data.TradeID; Property1.AreaID = data.AreaID; Property2.SourceID = data.SourceID; Property2.TradeID = data.TradeID; Property2.AreaID = data.AreaID; //-----------------绑定状态列表------------------------------ //绑定意向程度 ddlWish.DataSource = new T_Wish().GetList(new E_Wish() { PersonalID = PersonalID }); ddlWish.DataTextField = "WishName"; ddlWish.DataValueField = "WishID"; ddlWish.DataBind(); //添加一个“空” ddlWish.Items.Insert(0, new ListItem() { Text = "", Value = "0" }); //绑定失败理由 ddlNotTraded.DataSource = new T_NotTraded().GetList(new E_NotTraded() { PersonalID = PersonalID }); ddlNotTraded.DataTextField = "NotTradedName"; ddlNotTraded.DataValueField = "NotTradedID"; ddlNotTraded.DataBind(); //绑定报废理由 ddlScrap.DataSource = new T_Scrap().GetList(new E_Scrap() { PersonalID = PersonalID }); ddlScrap.DataTextField = "ScrapName"; ddlScrap.DataValueField = "ScrapID"; ddlScrap.DataBind(); ////-----------------绑定名录状态------------------------------ hdStatus.Value = ((int)data.Status).ToString(); hdWish.Value = data.WishID.ToString(); hdNotTraded.Value = data.NotTradedID.ToString(); hdScarp.Value = data.ScrapID.ToString(); ddlWish.SelectedValue = data.WishID.ToString(); txtMoney.Text = data.TradedMoney.ToString(); ddlNotTraded.SelectedValue = data.NotTradedID.ToString(); ddlScrap.SelectedValue = data.ScrapID.ToString(); Operate1.ClientInfoID = clientinfoid; //----------------绑定沟通记录--------------------- rpExchangeList.DataSource = new T_Exchange().GetList(new E_Exchange() { PersonalID = PersonalID, ClientInfoID = clientinfoid }); rpExchangeList.DataBind(); }
/// <summary> /// 导入数据库 /// </summary> /// <returns></returns> public E_ImportingResult ImportingDB() { E_ImportingResult result = new E_ImportingResult(); XmlDocument xmldoc = new XmlDocument(); //加载文件 try { xmldoc.Load(_filename); } catch { //加载文件失败 result.ErrorNumber = 1; return(result); } //读取配置 E_ImportingClientInfo data = new E_ImportingClientInfo(); data.PersonalID = _personalid; //data.EPUserTMRID = _epuserid; XmlNodeList xnlConfig = xmldoc.SelectNodes("root/CorreField/Field"); for (int i = 0; i < xnlConfig.Count; i++) { XmlElement xe = (XmlElement)xnlConfig[i]; if (string.IsNullOrEmpty(xe.GetAttribute("Source"))) { continue; } switch (xe.GetAttribute("Name").ToLower()) { case "clientname": data.ClientNameFiled = xe.GetAttribute("Source"); break; case "address": data.AddressFiled = xe.GetAttribute("Source"); break; case "zipcode": data.ZipCodeFiled = xe.GetAttribute("Source"); break; case "linkman": data.LinkmanFiled = xe.GetAttribute("Source"); break; case "position": data.PositionFiled = xe.GetAttribute("Source"); break; case "tel": data.TelFiled = xe.GetAttribute("Source"); break; case "mobile": data.MobileFiled = xe.GetAttribute("Source"); break; case "fax": data.FaxFiled = xe.GetAttribute("Source"); break; case "website": data.WebsiteFiled = xe.GetAttribute("Source"); break; case "email": data.EmailFiled = xe.GetAttribute("Source"); break; case "qq": data.QQFiled = xe.GetAttribute("Source"); break; case "msn": data.MSNFiled = xe.GetAttribute("Source"); break; case "remark": data.RemarkFiled = xe.GetAttribute("Source"); break; case "sourcecode": data.SourceCodeFiled = xe.GetAttribute("Source"); break; case "tradecode": data.TradeCodeFiled = xe.GetAttribute("Source"); break; case "areacode": data.AreaCodeFiled = xe.GetAttribute("Source"); break; default: break; } } //读取数据 XmlNodeList xnlList = xmldoc.SelectNodes("root/List/Item"); int len = xnlList.Count; T_ClientInfo bll = new T_ClientInfo(); DataTable dt; for (int i = 0; i < len; i++) { data.ClientName = GetData(xnlList[i], data.ClientNameFiled); data.AddressFiled = GetData(xnlList[i], data.AddressFiled); data.ZipCode = GetData(xnlList[i], data.ZipCodeFiled); data.Linkman = GetData(xnlList[i], data.LinkmanFiled); data.Position = GetData(xnlList[i], data.PositionFiled); data.Tel = GetData(xnlList[i], data.TelFiled); data.Mobile = GetData(xnlList[i], data.MobileFiled); data.Fax = GetData(xnlList[i], data.FaxFiled); data.Website = GetData(xnlList[i], data.WebsiteFiled); data.Email = GetData(xnlList[i], data.EmailFiled); data.QQ = GetData(xnlList[i], data.QQFiled); data.MSN = GetData(xnlList[i], data.MSNFiled); data.Remark = GetData(xnlList[i], data.RemarkFiled); data.SourceName = GetData(xnlList[i], data.SourceCodeFiled); data.TradeName = GetData(xnlList[i], data.TradeCodeFiled); data.AreaName = GetData(xnlList[i], data.AreaCodeFiled); //判断名录名是否存在 bool bb = bll.Exists(new E_ClientInfo() { PersonalID = _personalid, ClientName = data.ClientName, ClientInfoID = 0 }); if (bb) { result.FailList.Add(string.Format("[{0}]已经导入数据库! 第{1}行", data.ClientName, i)); ++result.FailNum; continue; } //判断手机是否存在 if (!string.IsNullOrEmpty(data.Mobile)) { dt = new T_ClientInfo().ExistsContact(new E_ClientInfo { PersonalID = _personalid, ClientInfoID = 0, Type = 1, Value = data.Mobile }); if (dt == null || dt.Rows.Count == 0) { result.FailList.Add("出错了!"); ++result.FailNum; continue; } if (dt.Rows[0]["Flag"].ToString() != "-1") { result.FailList.Add(string.Format("手机号码[{0}]已经存在于数据库! 第{1}行", data.Mobile, i)); ++result.FailNum; continue; } } //判断电话是否存在 if (!string.IsNullOrEmpty(data.Tel)) { dt = new T_ClientInfo().ExistsContact(new E_ClientInfo { PersonalID = _personalid, ClientInfoID = 0, Type = 2, Value = data.Tel }); if (dt == null || dt.Rows.Count == 0) { result.FailList.Add("出错了!"); ++result.FailNum; continue; } if (dt.Rows[0]["Flag"].ToString() != "-1") { result.FailList.Add(string.Format("电话号码[{0}]已经存在于数据库! 第{1}行", data.Tel, i)); ++result.FailNum; continue; } } bool b = bll.Add(data); if (b) { ++result.SuccNum; } else { ++result.FailNum; result.FailList.Add(data.ClientName); } } //删除文件 try { System.IO.File.Delete(_filename); } catch { } return(result); }
/// <summary> /// 绑定页面数据 /// </summary> protected void databind() { int ciid = Requests.GetQueryInt("ciid", 0); Operate1.ClientInfoID = ciid; //-----------------绑定基本信息------------------------------ E_ClientInfo data = new T_ClientInfo().GetModel(new E_ClientInfo() { EnterpriseID = EnterpriceID, ClientInfoID = ciid, EPUserTMRID = EPUserTMRID }); if (data == null) { Jscript.AlertAndRedirect(this, "无权限查看信息", "/enterprise/clientinfosearch.aspx"); return; } #region info的绑定 lblClientName.Text = data.ClientName; lblAddress.Text = data.Address; lblZipCode.Text = data.ZipCode; lblLinkman.Text = data.Linkman; lblPosition.Text = data.Position; lblEmail.Text = data.Email; lblTel.Text = data.Tel; lblMobile.Text = data.Mobile; hlWebsite.NavigateUrl = data.Website.IndexOf("http://") == -1 ? "http://" + data.Website : data.Website; hlWebsite.Text = data.Website; lblFax.Text = data.Fax; lblQQ.Text = data.QQ; lblMSN.Text = data.MSN; lblRemark.Text = data.Remark; #endregion txtClientName.Text = data.ClientName; txtAddress.Text = data.Address; txtZipCode.Text = data.ZipCode; txtLinkman.Text = data.Linkman; txtPosition.Text = data.Position; txtEmail.Text = data.Email; txtTel.Text = data.Tel; txtWebsite.Text = data.Website; txtMobile.Text = data.Mobile; txtFax.Text = data.Fax; txtQQ.Text = data.QQ; txtMSN.Text = data.MSN; txtRemark.Text = data.Remark; //-----------------绑定名录属性------------------------------ Property1.SourceID = data.SourceID; Property1.TradeID = data.TradeID; Property1.AreaID = data.AreaID; Property2.SourceID = data.SourceID; Property2.TradeID = data.TradeID; Property2.AreaID = data.AreaID; //-----------------绑定状态列表------------------------------ //绑定意向程度 ddlWish.DataSource = new T_Wish().GetList(new E_Wish() { EnterpriseID = EnterpriceID }); ddlWish.DataTextField = "WishName"; ddlWish.DataValueField = "WishID"; ddlWish.DataBind(); //绑定失败理由 ddlNotTraded.DataSource = new T_NotTraded().GetList(new E_NotTraded() { EnterpriseID = EnterpriceID }); ddlNotTraded.DataTextField = "NotTradedName"; ddlNotTraded.DataValueField = "NotTradedID"; ddlNotTraded.DataBind(); //绑定报废理由 ddlScrap.DataSource = new T_Scrap().GetList(new E_Scrap() { EnterpriseID = EnterpriceID }); ddlScrap.DataTextField = "ScrapName"; ddlScrap.DataValueField = "ScrapID"; ddlScrap.DataBind(); //-----------------绑定名录状态------------------------------ hdStatus.Value = ((int)data.Status).ToString(); hdWish.Value = data.WishID.ToString(); ddlWish.SelectedValue = data.WishID.ToString(); txtMoney.Text = data.TradedMoney.ToString(); ddlNotTraded.SelectedValue = data.NotTradedID.ToString(); ddlScrap.SelectedValue = data.ScrapID.ToString(); //----------------绑定沟通记录--------------------- rpExchangeList.DataSource = new T_Exchange().GetList(new E_Exchange() { EnterpriseID = EnterpriceID, ClientInfoID = ciid }); rpExchangeList.DataBind(); txtWdate.Value = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); //----------------绑定 上一个/下一个--------------------- _reservation = MLMGC.COMP.Requests.GetQueryString("s"); DataTable dt = new T_ClientInfoHelper().PrevNext(new E_ClientInfoHelper() { EnterpriseID = EnterpriceID, EPUserTMRID = EPUserTMRID, ClientInfoID = ciid, Status = (ushort)data.Status, IsReservation = _reservation == ""?false:true }); if (dt != null && dt.Rows.Count == 1) { _previousid = Convert.ToInt32(dt.Rows[0]["PrevID"].ToString()); _nextid = Convert.ToInt32(dt.Rows[0]["NextID"].ToString()); } if (_previousid == 0) { btnPrevious.Disabled = true; } if (_nextid == 0) { btnNext.Disabled = true; } Operate1.ClientInfoID = ciid; //----------------绑定预约类型----------------------- MLMGC.COMP.EnumUtil.BindList <EnumReservationType>(ddlReType); }
/// <summary> /// 修改基本信息 /// </summary> private void UpdateBaseInfo() { E_ClientInfo data = new E_ClientInfo(); data.PersonalID = bp.PersonalID; data.ClientInfoID = Convert.ToInt32(nv["id"].Trim()); data.ClientName = nv["clientname"].Trim(); data.Address = nv["address"]; data.AreaID = Convert.ToInt32(nv["areaid"].Trim()); data.Email = nv["email"].Trim(); data.Fax = nv["fax"].Trim(); data.Linkman = nv["linkman"].Trim(); data.Mobile = nv["mobile"].Trim(); data.Position = nv["position"].Trim(); data.Website = nv["website"].Trim(); data.QQ = nv["qq"].Trim(); data.MSN = nv["msn"].Trim(); data.Remark = nv["remark"].Trim(); data.SourceID = Convert.ToInt32(nv["sourceid"].Trim()); data.Tel = nv["tel"].Trim(); data.TradeID = Convert.ToInt32(nv["tradeid"].Trim()); data.ZipCode = nv["zipcode"].Trim(); //添加之前再次确认名录名称、电话、手机是否唯一 bool flag = true; //判断名录名是否存在 bool bl = new T_ClientInfo().Exists(new E_ClientInfo() { PersonalID = bp.PersonalID, ClientName = data.ClientName, ClientInfoID = data.ClientInfoID }); if (bl) { flag = false; } DataTable dt; //判断手机是否存在 if (!string.IsNullOrWhiteSpace(data.Mobile)) { dt = new T_ClientInfo().ExistsContact(new E_ClientInfo { PersonalID = bp.PersonalID, ClientInfoID = data.ClientInfoID, Type = 1, Value = data.Mobile }); if (dt != null && Convert.ToInt32(dt.Rows[0]["Flag"]) > -1) { flag = false; } } //判断电话是否存在 if (!string.IsNullOrEmpty(data.Tel)) { dt = new T_ClientInfo().ExistsContact(new E_ClientInfo { PersonalID = bp.PersonalID, ClientInfoID = data.ClientInfoID, Type = 2, Value = data.Tel }); if (dt != null && Convert.ToInt32(dt.Rows[0]["Flag"]) > -1) { flag = false; } } if (!flag) { return; } bool b = new T_ClientInfo().Update(data); HttpContext.Current.Response.Write(b ? "1" : "0"); }
/// <summary> /// 检查数据是否合法 /// </summary> /// <param name="shtClient">名录信息</param> /// <param name="shtSource">来源信息</param> /// <param name="shtTrade">行业信息</param> /// <param name="shtArea">地区信息</param> /// <returns></returns> protected bool Check(HSSFSheet shtClient, HSSFSheet shtSource, HSSFSheet shtTrade, HSSFSheet shtArea) { string name, sourcecode, tradecode, areacode; MLMGC.BLL.Personal.Config.T_Area bllArea = new MLMGC.BLL.Personal.Config.T_Area(); MLMGC.BLL.Personal.Config.T_Source bllSource = new MLMGC.BLL.Personal.Config.T_Source(); MLMGC.BLL.Personal.Config.T_Trade bllTrade = new MLMGC.BLL.Personal.Config.T_Trade(); MLMGC.BLL.Personal.T_ClientInfo bll = new T_ClientInfo(); bool b = true; int count = 0; //------检查名录属性是否合法 List <string> arySource = new List <string>(), aryTrade = new List <string>(), aryArea = new List <string>(); //--来源 count = shtSource.LastRowNum; for (int i = 1; i <= count; ++i) { if (ISCheckRowStrNullOrEmpty(i, shtSource)) { continue; } sourcecode = GetCellValue(shtSource.GetRow(i).GetCell(0));//来源编码 if (arySource.Contains(sourcecode)) { _result.Add("[" + strSourceName + "]中编码[" + sourcecode + "]有重复!第" + i.ToString() + "行"); b = false; } else if (bllSource.Exists(new E_Source() { PersonalID = _personalid, SourceCode = sourcecode })) { _result.Add(string.Format("来源编码[{0}]已经存在 [1]中第{2}行", sourcecode, strAreaName, i)); b = false; } else { arySource.Add(sourcecode); } } //--行业 count = shtTrade.LastRowNum; for (int i = 1; i <= count; ++i) { if (ISCheckRowStrNullOrEmpty(i, shtTrade)) { continue; } tradecode = GetCellValue(shtTrade.GetRow(i).GetCell(0));//来源编码 if (aryTrade.Contains(tradecode)) { _result.Add("[" + strTradeName + "]中编码[" + tradecode + "]有重复!第" + i.ToString() + "行"); } else if (bllTrade.Exists(new E_Trade() { PersonalID = _personalid, TradeCode = tradecode })) { _result.Add(string.Format("行业编码[{0}]数据库中已经存在 [{1}]中第{2}行", tradecode, strTradeName, i)); b = false; } else { aryTrade.Add(tradecode); } } //--地区 count = shtArea.LastRowNum; for (int i = 1; i <= count; ++i) { if (ISCheckRowStrNullOrEmpty(i, shtArea)) { continue; } areacode = GetCellValue(shtArea.GetRow(i).GetCell(0));//来源编码 if (aryArea.Contains(areacode)) { _result.Add("[" + strAreaName + "]中编码[" + areacode + "]有重复!第" + i.ToString() + "行"); } else if (bllArea.Exists(new E_Area() { PersonalID = _personalid, AreaCode = areacode })) { _result.Add(string.Format("地区编码[{0}]已经存在 [{1}]中,第{2}行", areacode, strAreaName, i)); b = false; } else { aryArea.Add(areacode); } } //------检查名录信息是否合法 if (b && CheckSheet(shtClient, strClientName, 16))//判断名录信息表是否合法 { //-----检查名称是否已经存在 count = shtClient.LastRowNum; for (int i = 1; i <= count; ++i)//从第2行开始 { if (ISCheckRowStrNullOrEmpty(i, shtClient)) { continue; } name = GetCellValue(shtClient.GetRow(i).GetCell(0)); //名称 sourcecode = GetCellValue(shtClient.GetRow(i).GetCell(12)); //来源 tradecode = GetCellValue(shtClient.GetRow(i).GetCell(13)); //行业 areacode = GetCellValue(shtClient.GetRow(i).GetCell(14)); //地区 if (bll.Exists(new E_ClientInfo() { PersonalID = _personalid, ClientName = name, ClientInfoID = 0 })) { _result.Add(string.Format("[{0}]已经在数据库中存在! 位置[{1}]中,第{2}行", name, strClientName, i)); b = false; } //--------判断属性是否完成-------- //判断来源 if (!string.IsNullOrEmpty(sourcecode) && !arySource.Contains(sourcecode) && !bllSource.Exists(new E_Source() { PersonalID = _personalid, SourceCode = sourcecode })) { _result.Add("无来源编码:" + sourcecode); b = false; } //判断行业 if (!string.IsNullOrEmpty(tradecode) && !aryTrade.Contains(tradecode) && !bllTrade.Exists(new E_Trade() { PersonalID = _personalid, TradeCode = tradecode })) { _result.Add("无行业编码:" + tradecode); b = false; } //判断地区 if (!string.IsNullOrEmpty(areacode) && !aryArea.Contains(areacode) && !bllArea.Exists(new E_Area() { PersonalID = _personalid, AreaCode = areacode })) { _result.Add("无地区编码:" + areacode); b = false; } } } else { return(false); } return(b); }
/// <summary> /// 点击确定按钮处理事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSubmit_Click(object sender, EventArgs e) { E_ClientInfo data = new E_ClientInfo(); data.PersonalID = PersonalID; //data.UserID = UserID; //data.EPUserTMRID = EPUserTMRID; data.ClientName = txtName.Text.Trim(); data.Address = txtAddress.Text; data.ZipCode = txtZipCode.Text; data.Position = txtPosition.Text; data.Linkman = txtLinkman.Text; data.Position = txtPosition.Text; data.Tel = txtTel.Text.Trim(); data.Mobile = txtMobile.Text.Trim(); data.Fax = txtFax.Text; data.Email = txtEmail.Text; data.QQ = txtQQ.Text; data.MSN = txtMSN.Text; data.Website = txtWebsite.Text; data.SourceName = trSource.Visible ? ddlSource.SelectedItem.Text.Trim() : string.Empty; data.TradeName = trTrade.Visible ? ddlTrade.SelectedItem.Text.Trim() : string.Empty; data.AreaName = trArea.Visible ? ddlArea.SelectedItem.Text.Trim() : string.Empty; data.Remark = txtRemark.Text; if (string.IsNullOrWhiteSpace(data.ClientName))//判断是否输入名录名称 { Jscript.ShowMsg("请输入名称", this); txtName.Focus(); return; } //添加之前再次确认名录名称、电话、手机是否唯一 bool b = true; //判断名录名是否存在 b = new T_ClientInfo().Exists(new E_ClientInfo() { PersonalID = PersonalID, ClientName = data.ClientName, ClientInfoID = 0 }); if (b) { Jscript.ShowMsg("名录名称已存在!", this); return; } DataTable dt; b = true; //判断手机是否存在 if (!string.IsNullOrEmpty(data.Mobile)) { dt = new T_ClientInfo().ExistsContact(new E_ClientInfo { PersonalID = PersonalID, ClientInfoID = 0, Type = 1, Value = data.Mobile }); if (dt == null && Convert.ToInt32(dt.Rows[0]["Flag"]) > -1) { b = false; } } //判断电话是否存在 if (!string.IsNullOrEmpty(data.Tel)) { dt = new T_ClientInfo().ExistsContact(new E_ClientInfo { PersonalID = PersonalID, ClientInfoID = 0, Type = 2, Value = data.Tel }); if (dt == null && Convert.ToInt32(dt.Rows[0]["Flag"]) > -1) { b = false; } } if (!b) { Jscript.ShowMsg("录入失败", this); return; } T_ClientInfo bll = new T_ClientInfo(); bool flag = bll.Add(data); if (flag) { Jscript.AlertAndRedirect(this, "录入成功", Request.Url.ToString()); } else { Jscript.ShowMsg("录入失败", this); } }
/// <summary> /// 检查数据是否合法 /// </summary> /// <param name="shtClient">名录信息</param> /// <param name="shtSource">来源信息</param> /// <param name="shtTrade">行业信息</param> /// <param name="shtArea">地区信息</param> /// <returns></returns> protected bool Check(HSSFSheet shtClient) { string name, sourcecode, tradecode, areacode; T_Area bllArea = new T_Area(); T_Source bllSource = new T_Source(); T_Trade bllTrade = new T_Trade(); T_ClientInfo bll = new T_ClientInfo(); bool b = true; int count = 0; DataTable dt = null; //------检查名录信息是否合法 if (b && CheckSheet(shtClient, strClientName, 16))//判断名录信息表是否合法 { //-----检查名称是否已经存在 count = shtClient.LastRowNum; for (int i = 1; i <= count; ++i)//从第2行开始 { if (ISCheckRowStrNullOrEmpty(i, shtClient)) { continue; } name = GetCellValue(shtClient.GetRow(i).GetCell(0)); //名称 sourcecode = GetCellValue(shtClient.GetRow(i).GetCell(12)); //来源 tradecode = GetCellValue(shtClient.GetRow(i).GetCell(13)); //行业 areacode = GetCellValue(shtClient.GetRow(i).GetCell(14)); //地区 if (string.IsNullOrWhiteSpace(name)) { _result.Add(string.Format("名录名录为空! 位置[{0}]中,第{1}行", strClientName, i)); b = false; continue; } dt = bll.Exists(new E_ClientInfo() { EnterpriseID = _enterpriseid, ClientName = name, ClientInfoID = 0 }); if (dt == null || dt.Rows.Count == 0) { _result.Add("出错了!"); b = false; continue; } if (dt.Rows[0]["Flag"].ToString() != "-1") { _result.Add(string.Format("[{0}]已经在数据库中存在! 位置[{1}]中,第{2}行", name, strClientName, i)); b = false; } //--------判断属性是否完成-------- //判断来源 if (!string.IsNullOrEmpty(sourcecode) && !bllSource.Exists(new E_Source() { EnterpriseID = _enterpriseid, SourceCode = sourcecode, SourceID = 0 })) { _result.Add("无来源编码:" + sourcecode); b = false; } //判断行业 if (!string.IsNullOrEmpty(tradecode) && !bllTrade.Exists(new E_Trade() { EnterpriseID = _enterpriseid, TradeCode = tradecode, TradeID = 0 })) { _result.Add("无行业编码:" + tradecode); b = false; } //判断地区 if (!string.IsNullOrEmpty(areacode) && !bllArea.Exists(new E_Area() { EnterpriseID = _enterpriseid, AreaCode = areacode, AreaID = 0 })) { _result.Add("无地区编码:" + areacode); b = false; } } } else { return(false); } return(b); }
/// <summary> /// 导入名录信息 /// </summary> /// <param name="shtClient"></param> /// <returns></returns> private bool ImportClient(HSSFSheet shtClient) { int count = shtClient.LastRowNum; int succNum = 0, errorNum = 0; HSSFRow row; T_ClientInfo bll = new T_ClientInfo(); E_ClientInfo data; DataTable dt; for (int i = 1; i <= count; ++i) { if (ISCheckRowStrNullOrEmpty(i, shtClient)) { continue; } row = shtClient.GetRow(i); data = new E_ClientInfo(); data.EnterpriseID = _enterpriseid; data.EPUserTMRID = _epusertmrid; data.UserID = _userid; data.ClientName = GetCellValue(row.GetCell(0)); //名称 data.Address = GetCellValue(row.GetCell(1)); //地址 data.ZipCode = GetCellValue(row.GetCell(2)); //邮编 data.Linkman = GetCellValue(row.GetCell(3)); //联系人 data.Position = GetCellValue(row.GetCell(4)); //职务 data.Tel = GetCellValue(row.GetCell(5)); //电话 data.Mobile = GetCellValue(row.GetCell(6)); //手机 data.Fax = GetCellValue(row.GetCell(7)); //传真 data.Website = GetCellValue(row.GetCell(8)); //网址 data.Email = GetCellValue(row.GetCell(9)); //邮箱 data.QQ = GetCellValue(row.GetCell(10)); //QQ data.MSN = GetCellValue(row.GetCell(11)); //MSN data.SourceCode = GetCellValue(row.GetCell(12)); //来源编码 data.TradeCode = GetCellValue(row.GetCell(13)); //行业编码 data.AreaCode = GetCellValue(row.GetCell(14)); //地区编码 data.Remark = GetCellValue(row.GetCell(15)); //备注 //判断名录名是否存在 dt = bll.Exists(new E_ClientInfo() { EnterpriseID = _enterpriseid, ClientName = data.ClientName, ClientInfoID = 0 }); if (dt == null || dt.Rows.Count == 0) { _result.Add("出错了!"); ++errorNum; continue; } if (dt.Rows[0]["Flag"].ToString() != "-1") { _result.Add(string.Format("[{0}]已经导入数据库! 位置[{1}]中,第{2}行", data.ClientName, strClientName, i)); ++errorNum; continue; } //判断手机是否存在 if (!string.IsNullOrEmpty(data.Mobile)) { dt = new T_ClientInfoHelper().ExistsContact(new E_ClientInfoHelper { EnterpriseID = _enterpriseid, ClientInfoID = 0, Type = 1, Value = data.Mobile }); if (dt == null || dt.Rows.Count == 0) { _result.Add("出错了!"); ++errorNum; continue; } if (dt.Rows[0]["Flag"].ToString() != "-1") { _result.Add(string.Format("手机号码[{0}]已经存在于数据库! 位置[{1}]中,第{2}行", data.Mobile, strClientName, i)); ++errorNum; continue; } } //判断电话是否存在 if (!string.IsNullOrEmpty(data.Tel)) { dt = new T_ClientInfoHelper().ExistsContact(new E_ClientInfoHelper { EnterpriseID = _enterpriseid, ClientInfoID = 0, Type = 2, Value = data.Tel }); if (dt == null || dt.Rows.Count == 0) { _result.Add("出错了!"); ++errorNum; continue; } if (dt.Rows[0]["Flag"].ToString() != "-1") { _result.Add(string.Format("电话号码[{0}]已经存在于数据库! 位置[{1}]中,第{2}行", data.Tel, strClientName, i)); ++errorNum; continue; } } //名录写入数据库 if (bll.Add(data))//判断名录写入成功与失败 { ++succNum; } else { ++errorNum; } } _result.Add(string.Format("成功导入{0}条,失败{1}条。", succNum, errorNum)); return(errorNum == 0); }
protected void btnSubmit_Click(object sender, EventArgs e) { E_ClientInfo data = new E_ClientInfo(); data.EnterpriseID = EnterpriceID; data.UserID = UserID; data.EPUserTMRID = EPUserTMRID; data.ClientName = txtName.Text.Trim(); data.Address = txtAddress.Text.Trim(); data.ZipCode = txtZipCode.Text.Trim(); data.Position = txtPosition.Text.Trim(); data.Linkman = txtLinkman.Text.Trim(); data.Position = txtPosition.Text.Trim(); data.Tel = txtTel.Text.Trim(); data.Mobile = txtMobile.Text.Trim(); data.Fax = txtFax.Text.Trim(); data.Website = txtWebsite.Text.Trim(); data.QQ = txtQQ.Text.Trim(); data.MSN = txtMSN.Text.Trim(); data.Email = txtEmail.Text.Trim(); data.SourceCode = trSource.Visible?txtSourceCode.Text:string.Empty; data.TradeCode = trTrade.Visible ? txtTradeCode.Text : string.Empty; data.AreaCode = trArea.Visible ? txtAreaCode.Text : string.Empty; data.Remark = txtRemark.Text.Trim(); if (string.IsNullOrWhiteSpace(data.ClientName))//判断是否输入名录名称 { Jscript.ShowMsg("请输入名称", this); txtName.Focus(); return; } //添加之前再次确认名录名称、电话、手机是否唯一 bool flag = true; DataTable dt = new T_ClientInfo().Exists(new E_ClientInfo { EnterpriseID = data.EnterpriseID, ClientInfoID = data.ClientInfoID, ClientName = data.ClientName }); if (dt != null && Convert.ToInt32(dt.Rows[0]["Flag"]) > 0) { flag = false; } //如果手机不为空 if (!string.IsNullOrEmpty(data.Mobile.Trim())) { dt = new T_ClientInfoHelper().ExistsContact(new E_ClientInfoHelper { EnterpriseID = data.EnterpriseID, ClientInfoID = data.ClientInfoID, Type = 1, Value = data.Mobile }); if (dt != null && Convert.ToInt32(dt.Rows[0]["Flag"]) > 0) { flag = false; } } //如果电话不为空 if (!string.IsNullOrEmpty(data.Tel.Trim())) { dt = new T_ClientInfoHelper().ExistsContact(new E_ClientInfoHelper { EnterpriseID = data.EnterpriseID, ClientInfoID = data.ClientInfoID, Type = 2, Value = data.Tel }); if (dt != null && Convert.ToInt32(dt.Rows[0]["Flag"]) > 0) { flag = false; } } if (!flag) { Jscript.ShowMsg("录入失败", this); return; } T_ClientInfo bll = new T_ClientInfo(); bool b = bll.Add(data); if (b) { //添加操作日志 new MLMGC.BLL.Enterprise.T_Log().Add(new MLMGC.DataEntity.Enterprise.E_Log() { EnterpriseID = EnterpriceID, UserID = UserID, LogTitle = "添加名录", IP = MLMGC.COMP.Requests.GetRealIP() }); Jscript.AlertAndRedirect(this, "录入成功", Request.Url.ToString()); } else { Jscript.ShowMsg("录入失败", this); } }
protected void databind() { //获取待分配名录数量 E_ClientInfo data = new E_ClientInfo(); data.EnterpriseID = EnterpriceID; data.TeamID = TeamID; data.Mode = EnumClientMode.团队; data.Status = EnumClientStatus.待分配名录; int count = new T_ClientInfo().WaitCount(data); ltSumAmount.Text = count.ToString(); txtAllotAmount.Attributes.Add("maxNum", count.ToString()); //获取名录属性信息 E_Property dataProperty = new T_Property().Get(new E_Property() { EnterpriseID = EnterpriceID }); TradeFlag = Convert.ToBoolean((int)dataProperty.TradeFlag); AreaFlag = Convert.ToBoolean((int)dataProperty.AreaFlag); SourceFlag = Convert.ToBoolean((int)dataProperty.SourceFlag); //获取配置信息 DataSet ds = new T_Allot().Select(new E_Allot() { EnterpriseID = EnterpriceID, TeamID = TeamID }); if (ds == null || ds.Tables.Count != 5) { return; } SettingFlag = true; //----------读取自行分配配置信息--------------- E_Allot config = new T_Allot().GetModelConfig(new E_Allot() { EnterpriseID = EnterpriceID, TeamID = TeamID }); if (config != null) { rblEnabledState.SelectedValue = config.Available.ToString(); txtAllotAmount.Text = config.AllotAmount.ToString(); txtDay.Text = config.Cycle.ToString(); if (config.AllotTime != null && config.AllotTime.IndexOf(":") > -1) { txtHour.Text = config.AllotTime.Substring(0, 2); txtMinute.Text = config.AllotTime.Substring(3, 2); } lbCurExecDate.Text = config.LastDate == null ? "----" :string.Format("{0:yyyy-MM-dd HH:mm:ss}", config.LastDate); lbNextDate.Text = string.Format("{0:yyyy-MM-dd HH:mm:ss}", config.NextDate); //排序方式 if (config.AllotSort == "asc") { rdOrderbyAsc.Checked = true; } else { rdOrderbyDesc.Checked = true; } //分配类型 switch (config.Mode) { case EnumMode.平均分配: cbTypeAvg.Checked = true; break; case EnumMode.补差分配: if (SettingFlag) { cbTypeMakeup.Checked = true; } break; case EnumMode.行业分配: if (SettingFlag && TradeFlag) { cbTypeTrade.Checked = true; } break; case EnumMode.地区分配: if (SettingFlag && AreaFlag) { cbTypeArea.Checked = true; } break; case EnumMode.来源分配: if (SettingFlag && SourceFlag) { cbTypeSource.Checked = true; } break; } } }