//---------------保存CRMCountry--------------------------- public CRMProvince Save(CRMProvince entity) { if (this.dataCtx.Connection != null) { this.dataCtx.Connection.Open(); } if (this.dataCtx.Connection != null) { if (this.dataCtx.Connection.State == ConnectionState.Closed) { this.dataCtx.Connection.Open(); } } DbTransaction tran = this.dataCtx.Connection.BeginTransaction(); dataCtx.Transaction = tran; try { var qry = from t in CRMProvinces where t.ProvinceID == entity.ProvinceID select t; var obj = qry.SingleOrDefault(); if (obj != null) { this.CopyEntity(obj, entity); } else { this.CRMProvinces.InsertOnSubmit(entity); } this.dataCtx.SubmitChanges(); tran.Commit(); return(entity); } catch (Exception ex) { tran.Rollback(); throw ex; } finally { dataCtx.Connection.Close(); } }
private CRMProvince GetSaveEntity() { var entity = new CRMProvince(); if (string.IsNullOrEmpty(txtProvinceID.Text.Trim()) == false) { entity.ProvinceID = int.Parse(txtProvinceID.Text.Trim()); } if (string.IsNullOrEmpty(txtProvince.Text.Trim()) == false) { entity.Province = txtProvince.Text.Trim(); } if (string.IsNullOrEmpty(txtRegion.Text.Trim()) == false) { entity.Region = txtRegion.Text.Trim(); } return(entity); }
private CRMProvince GetSaveEntity() { var entity = new CRMProvince(); if (string.IsNullOrEmpty(txtProvinceID.Text.Trim()) == false) entity.ProvinceID = int.Parse(txtProvinceID.Text.Trim()); if (string.IsNullOrEmpty(txtProvince.Text.Trim()) == false) entity.Province = txtProvince.Text.Trim(); if (string.IsNullOrEmpty(txtRegion.Text.Trim()) == false) entity.Region = txtRegion.Text.Trim(); return entity; }
//---------------保存CRMCountry--------------------------- public CRMProvince Save(CRMProvince entity) { if (this.dataCtx.Connection != null) this.dataCtx.Connection.Open(); if (this.dataCtx.Connection != null) if (this.dataCtx.Connection.State == ConnectionState.Closed) this.dataCtx.Connection.Open(); DbTransaction tran = this.dataCtx.Connection.BeginTransaction(); dataCtx.Transaction = tran; try { var qry = from t in CRMProvinces where t.ProvinceID == entity.ProvinceID select t; var obj = qry.SingleOrDefault(); if (obj != null) this.CopyEntity(obj, entity); else this.CRMProvinces.InsertOnSubmit(entity); this.dataCtx.SubmitChanges(); tran.Commit(); return entity; } catch (Exception ex) { tran.Rollback(); throw ex; } finally { dataCtx.Connection.Close(); } }
//Click Save Button protected void btnSave_Click(object sender, EventArgs e) { try { var entity = GetSaveEntity(); //角色对应部门权限 List<CRMDepartment> DepList = new List<CRMDepartment>(); string[] arrD = DDCLDep.SelectedValuesToString().Split(','); foreach (var ID in arrD) { if (!string.IsNullOrEmpty(ID)) { var d = new CRMDepartment(); d.DepID = long.Parse(ID); DepList.Add(d); } } //角色对应产品权限 List<CRMProduct> ProdList = new List<CRMProduct>(); string[] arrP = DDCLProduct.SelectedValuesToString().Split(','); foreach (var ID in arrP) { if (!string.IsNullOrEmpty(ID)) { var p = new CRMProduct(); p.ProdID = long.Parse(ID); ProdList.Add(p); } } //角色对应区域省份权限 List<CRMProvince> ProvinceList = new List<CRMProvince>(); string[] arrPv = DDCLProvince.SelectedValuesToString().Split(','); foreach (var ID in arrPv) { if (!string.IsNullOrEmpty(ID)) { var p = new CRMProvince(); p.ProvinceID = int.Parse(ID); ProvinceList.Add(p); } } //角色对应模块权限 //string[] arrM = DDCLModule.SelectedValuesToString().Split(','); List<CRMRoleModule> ModList = new List<CRMRoleModule>(); foreach (RepeaterItem item in rptMod.Items) { var p = new CRMRoleModule(); p.ModuleID = long.Parse(((HiddenField)item.FindControl("HidID")).Value); var cb = (CheckBoxList)item.FindControl("cblRight"); p.ReadOnly = cb.Items[0].Selected ; p.New = cb.Items[1].Selected ; p.Edit = cb.Items[2].Selected; p.Del =cb.Items[3].Selected ; ModList.Add(p); } entity = svr.Save(entity, ProdList, ModList, DepList, ProvinceList); hidID.Value = entity.RoleID.ToString(); this.ShowSaveOK(); } catch (Exception ex) { this.ShowMessage(ex.Message); } }
//Click Save Button protected void btnSave_Click(object sender, EventArgs e) { try { var entity = GetSaveEntity(); //角色对应部门权限 List <CRMDepartment> DepList = new List <CRMDepartment>(); string[] arrD = DDCLDep.SelectedValuesToString().Split(','); foreach (var ID in arrD) { if (!string.IsNullOrEmpty(ID)) { var d = new CRMDepartment(); d.DepID = long.Parse(ID); DepList.Add(d); } } //角色对应产品权限 List <CRMProduct> ProdList = new List <CRMProduct>(); string[] arrP = DDCLProduct.SelectedValuesToString().Split(','); foreach (var ID in arrP) { if (!string.IsNullOrEmpty(ID)) { var p = new CRMProduct(); p.ProdID = long.Parse(ID); ProdList.Add(p); } } //角色对应区域省份权限 List <CRMProvince> ProvinceList = new List <CRMProvince>(); string[] arrPv = DDCLProvince.SelectedValuesToString().Split(','); foreach (var ID in arrPv) { if (!string.IsNullOrEmpty(ID)) { var p = new CRMProvince(); p.ProvinceID = int.Parse(ID); ProvinceList.Add(p); } } //角色对应模块权限 //string[] arrM = DDCLModule.SelectedValuesToString().Split(','); List <CRMRoleModule> ModList = new List <CRMRoleModule>(); foreach (RepeaterItem item in rptMod.Items) { var p = new CRMRoleModule(); p.ModuleID = long.Parse(((HiddenField)item.FindControl("HidID")).Value); var cb = (CheckBoxList)item.FindControl("cblRight"); p.ReadOnly = cb.Items[0].Selected; p.New = cb.Items[1].Selected; p.Edit = cb.Items[2].Selected; p.Del = cb.Items[3].Selected; ModList.Add(p); } entity = svr.Save(entity, ProdList, ModList, DepList, ProvinceList); hidID.Value = entity.RoleID.ToString(); this.ShowSaveOK(); } catch (Exception ex) { this.ShowMessage(ex.Message); } }