/// <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;
}
}
}
