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>"); } }
/// <summary> /// �õ�һ������ʵ�� /// </summary> public SYCRM.Model.Area GetModel(Guid Id) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 * from Area "); strSql.Append(" where Id=@Id "); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.UniqueIdentifier)}; parameters[0].Value = Id; SYCRM.Model.Area model=new SYCRM.Model.Area(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { if(ds.Tables[0].Rows[0]["Id"].ToString()!="") { model.Id=new Guid(ds.Tables[0].Rows[0]["Id"].ToString()); } model.Name=ds.Tables[0].Rows[0]["Name"].ToString(); if(ds.Tables[0].Rows[0]["Type"].ToString()!="") { model.Type=new Guid(ds.Tables[0].Rows[0]["Type"].ToString()); } model.WBS=ds.Tables[0].Rows[0]["WBS"].ToString(); model.Des=ds.Tables[0].Rows[0]["Des"].ToString(); if(ds.Tables[0].Rows[0]["status"].ToString()!="") { model.status=int.Parse(ds.Tables[0].Rows[0]["status"].ToString()); } if (ds.Tables[0].Rows[0]["Code"].ToString() != "") { model.Code = int.Parse(ds.Tables[0].Rows[0]["Code"].ToString()); } return model; } else { return null; } }
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; }
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; }
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>"); } }