protected void btnSave_Click(object sender, EventArgs e)
{
string strId = editid.Text.Trim();
try
{
Guid id = new Guid(strId);
SYCRM.Model.Area MF = new SYCRM.Model.Area();
SYCRM.BLL.Area BF = new SYCRM.BLL.Area();
MF = BF.GetModel(id);
MF.Name = tbShowName.Text.Trim();
MF.Des = tb_ShowDes.Text.Trim();
string strOldWBS = MF.WBS;
MF.WBS = DDLLayer.SelectedValue + "." + MF.Id.ToString();
MF.status = 1;
BF.Update(MF);
List<SYCRM.Model.Area> listMA = BF.GetModelList("WBS like '%" + strOldWBS + ".%'");
foreach (SYCRM.Model.Area a in listMA)
{
a.WBS = MF.WBS + "." + a.Id.ToString();
BF.Update(a);
}
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "修改成功!", "<script>alert('修改成功!');window.location.href='Area.aspx'</script>");
}
catch
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "修改失败!", "<script>alert('修改失败!');window.location.href='Area.aspx'</script>");
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
SYCRM.Model.Area MF = new SYCRM.Model.Area();
SYCRM.BLL.Area BF = new SYCRM.BLL.Area();
//if (DateTime.TryParse(tbFDate.Text.Trim(), out temp))
{
MF.Name = tbShowName.Text.Trim();
MF.Des = tb_ShowDes.Text.Trim();
//MF.WBS = DDLLayer.SelectedValue
MF.status = 1;
BF.Add(MF);
if (MF.Id == null)
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "添加失败!", "<script>alert('添加失败!');window.location.href='Area.aspx'</script>");
return;
}
else
{
MF.WBS = DDLLayer.SelectedValue + "." + MF.Id;
BF.Update(MF);
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "添加成功!", "<script>alert('添加成功!');window.location.href='Area.aspx'</script>");
}
}
}
protected void btnDel_Click(object sender, EventArgs e)
{
string strId = editid.Text.Trim();
try
{
Guid id = new Guid(strId);
SYCRM.BLL.Area BF = new SYCRM.BLL.Area();
SYCRM.Model.Area MF = new SYCRM.Model.Area();
MF = BF.GetModel(id);
List<SYCRM.Model.Area> listMA = BF.GetModelList("WBS like '%" + MF.WBS + "%'");
foreach (SYCRM.Model.Area a in listMA)
{
BF.Delete(a.Id);
}
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "删除成功!", "<script>alert('删除成功!');window.location.href='Area.aspx'</script>");
}
catch
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "删除失败!", "<script>alert('删除失败!');window.location.href='Area.aspx'</script>");
}
}
List<SYCRM.Model.Area> GetOwnArea(Guid areaid)
{
List<SYCRM.Model.Area> listMF = new List<SYCRM.Model.Area>();
SYCRM.BLL.Area BF = new SYCRM.BLL.Area();
SYCRM.Model.Area pRoot = BF.GetModel(areaid);
if (pRoot == null)
{
labErr.Visible = true;
labErr.Text = "账户数据错误!请联系系统管理员!";
return null;
}
string strWhere = " status=1 and WBS like'" + pRoot.WBS + "%'";
strWhere += " order by WBS";
listMF = BF.GetModelList(strWhere);
return listMF;
}
List<SYCRM.Model.Customer> handleAList(List<SYCRM.Model.Customer> listMA)
{
foreach (SYCRM.Model.Customer a in listMA)
{
SYCRM.Model.Area MArea = new SYCRM.Model.Area();
SYCRM.BLL.Area BArea = new SYCRM.BLL.Area();
MArea = BArea.GetModel(a.Area);
if (MArea != null)
{
a.AreaName = MArea.Name;
}
else
{
a.AreaName = "区域已删除";
}
}
return listMA;
}
private void BindData()
{
List<SYCRM.Model.Area> listMF = new List<SYCRM.Model.Area>();
SYCRM.BLL.Area BF = new SYCRM.BLL.Area();
string strWhere = " status=1 ";
if (!tb_KeyWords.Text.Trim().Equals(""))
{
strWhere += " and [Name] like '%" + tb_KeyWords.Text.Trim() + "%'";
}
strWhere += " order by WBS";
listMF = BF.GetModelList(strWhere);
RpArea.DataSource = handleList(listMF);
RpArea.DataBind();
DDLLayer.DataSource = handleList(listMF);
DDLLayer.DataBind();
}
private void bindPage()
{
SYCRM.Model.Customer cus = new SYCRM.Model.Customer();
SYCRM.BLL.Customer cusBll = new SYCRM.BLL.Customer();
cus = cusBll.GetModel(cusId);
lbName.Text = cus.Name;
lbage.Text = cus.UserAge.ToString();
if (cus.UserSex == 1)
{
lbsex.Text = "男";
}
else
{
lbsex.Text = "女";
}
if (cus.Area != null)
{
SYCRM.BLL.Area areaBll = new SYCRM.BLL.Area();
SYCRM.Model.Area area = areaBll.GetModel(cus.Area);
if (area != null)
{
lbarea.Text = area.Name;
}
}
SYCRM.Model.Agent a = Session["User"] as SYCRM.Model.Agent;
if (a.AreaId != null)
{
List<SYCRM.Model.Area> listA = GetOwnArea(a.AreaId);
if (listA == null)
{
NoP();
return;
}
if (cus.Area == a.AreaId)
{
hdP.Value = "2";
}
else if (listA.Where(Items => Items.Id == cus.Area).ToList().Count > 0)
{
hdP.Value = "1";
}
else
{
NoP();
}
}
else
{
NoP();
return;
}
lbbabayname.Text = cus.BabyName;
lbbabysex.Text = cus.BabySexName;
lbbrithday.Text = cus.BadyBirthday.ToString();
lbtel.Text = cus.Phone.ToString();
lbaddress.Text = cus.Address;
if (cus.AgentId != null)
{
SYCRM.BLL.Agent agentBll = new SYCRM.BLL.Agent();
SYCRM.Model.Agent agent = agentBll.GetModel(cus.AgentId);
if (agent != null)
{
lbagent.Text = agent.Name;
}
}
lbdes.Text = cus.Des;
lbAddTime.Text = cus.AddTime.Value.ToShortDateString().ToString();
if (cus.AddUserId != null)
{
SYCRM.BLL.Agent agentBll = new SYCRM.BLL.Agent();
SYCRM.Model.Agent agent = agentBll.GetModel(cus.AddUserId);
if (agent != null)
{
lbAaddUser.Text = agent.Name;
}
}
List<SYCRM.Model.CustomerProduct> listAllCP = new List<SYCRM.Model.CustomerProduct>();
SYCRM.BLL.CustomerProduct bcp = new SYCRM.BLL.CustomerProduct();
listAllCP = bcp.GetModelList("");
List<SYCRM.Model.Product> listAllP = new List<SYCRM.Model.Product>();
SYCRM.BLL.Product bp = new SYCRM.BLL.Product();
listAllP = bp.GetModelList("");
List<SYCRM.Model.CustomerProduct> listtempCP =
listAllCP.Where(Item => Item.CustomerId == cus.Id && Item.Status == 1).ToList();
List<SYCRM.Model.Product> listtempP = new List<SYCRM.Model.Product>();
if (listtempCP.Count > 0)
{
listtempP = listAllP.Where(Item => listtempCP.Where(b => b.ProductId == Item.Id).Count() > 0
&& Item.status == 1).ToList();
if (listtempP.Count > 0)
{
foreach (SYCRM.Model.Product p in listtempP)
{
cus.ProductName += p.Code.ToString()+" "+p.Name +" ";
}
}
else
{
cus.ProductName = "无";
}
}
lbproduct.Text = cus.ProductName;
}
List<SYCRM.Model.Area> GetOwnArea(Guid areaid)
{
List<SYCRM.Model.Area> listMF = new List<SYCRM.Model.Area>();
SYCRM.BLL.Area BF = new SYCRM.BLL.Area();
SYCRM.Model.Area pRoot = BF.GetModel(areaid);
if (pRoot == null)
{
return null;
}
string strWhere = " status=1 and WBS like'" + pRoot.WBS + "%'";
strWhere += " order by WBS";
listMF = BF.GetModelList(strWhere);
return listMF;
}
List<SYCRM.Model.Agent> handleAList(List<SYCRM.Model.Agent> listMA)
{
foreach (SYCRM.Model.Agent a in listMA)
{
SYCRM.Model.Area MArea = new SYCRM.Model.Area();
SYCRM.BLL.Area BArea = new SYCRM.BLL.Area();
MArea = BArea.GetModel(a.AreaId);
if (MArea != null)
{
a.AreaName = MArea.Name;
}
else
{
a.AreaName = "区域已删除";
}
SYCRM.Model.Position MPosition = new SYCRM.Model.Position();
SYCRM.BLL.Position BPosition = new SYCRM.BLL.Position();
MPosition = BPosition.GetModel(a.Position);
if (MPosition != null)
{
a.PostName = MPosition.Name;
}
else
{
a.PostName = "职位已删除";
}
}
return listMA;
}
List<SYCRM.Model.Customer> HandleList(List<SYCRM.Model.Customer> list)
{
List<SYCRM.Model.CustomerProduct> listAllCP = new List<SYCRM.Model.CustomerProduct>();
SYCRM.BLL.CustomerProduct bcp = new SYCRM.BLL.CustomerProduct();
listAllCP = bcp.GetModelList("");
List<SYCRM.Model.Product> listAllP = new List<SYCRM.Model.Product>();
SYCRM.BLL.Product bp = new SYCRM.BLL.Product();
listAllP = bp.GetModelList("");
List<SYCRM.Model.Agent> listAllA = new List<SYCRM.Model.Agent>();
SYCRM.BLL.Agent ba = new SYCRM.BLL.Agent();
listAllA = ba.GetModelList("");
List<SYCRM.Model.Area> listAllAA = new List<SYCRM.Model.Area>();
SYCRM.BLL.Area baa = new SYCRM.BLL.Area();
listAllAA = baa.GetModelList("");
foreach (SYCRM.Model.Customer c in list)
{
#region 产品
List<SYCRM.Model.CustomerProduct> listtempCP =
listAllCP.Where(Item => Item.CustomerId == c.Id && Item.Status==1).ToList();
List<SYCRM.Model.Product> listtempP = new List<SYCRM.Model.Product>();
if (listtempCP.Count > 0)
{
listtempP = listAllP.Where(Item => listtempCP.Where(b => b.ProductId == Item.Id).Count() > 0
&& Item.status == 1).ToList();
if (listtempP.Count > 0)
{
foreach(SYCRM.Model.Product p in listtempP)
{
c.ProductName += p.Name+ " ";
}
}
else
{
c.ProductName = "无";
}
}
else
{
c.ProductName = "无";
}
#endregion
#region 区域
List<SYCRM.Model.Area> listTempAA = new List<SYCRM.Model.Area>();
listTempAA = listAllAA.Where(item => item.Id == c.Area).ToList();
if (listTempAA.Count > 0)
{
string strName = listTempAA[0].Name;
if (listTempAA[0].status == 2)
{
strName = listTempAA[0].Name + "(已删除)";
}
c.AreaName = strName;
}
else
{
c.AreaName = "无";
}
#endregion
#region 服务人员
List<SYCRM.Model.Agent> listTempA = new List<SYCRM.Model.Agent>();
listTempA = listAllA.Where(item => item.Id == c.AgentId).ToList();
if (listTempA.Count > 0)
{
string strName = listTempA[0].Name;
if (listTempA[0].status == 2)
{
strName = listTempA[0].Name + "(已删除)";
}
c.ChargeName = strName;
}
else
{
c.ChargeName = "无";
}
#endregion
}
return list;
}
void bind(SYCRM.Model.Agent user)
{
hdId.Value = user.Id.ToString();
SYCRM.Model.Area ma = new SYCRM.Model.Area();
SYCRM.BLL.Area ba = new SYCRM.BLL.Area();
if (user.AreaId != null)
{
ma = ba.GetModel(user.AreaId);
if (ma == null)
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "数据错误!", "<script>alert('数据错误!');'</script>");
}
else
{
ddlUserType.SelectedValue = user.UserType.Value.ToString();
DDLLayer.SelectedValue = ma.WBS.ToString();
ddlSex.SelectedValue = user.Sex.Value.ToString();
ddlPost.SelectedValue = user.Position.ToString();
tbAddress.Text = user.Address;
tb_ShowDes.Text = user.Des;
tbMail.Text = user.Email;
tbIDCard.Text = user.IDCard;
tbPhone.Text = user.Phone;
tbLoginName.Text = user.UserName;
tbName.Text = user.Name;
}
}
else
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "数据错误!", "<script>alert('数据错误!');'</script>");
}
}
