private Dictionary <string, SqlParameter[]> GetDivisionSaveDictionary() { Dictionary <string, SqlParameter[]> param = new Dictionary <string, SqlParameter[]>(); LPWeb.Model.Divisions model = new LPWeb.Model.Divisions(); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Divisions("); strSql.Append("Name,[Desc],Enabled)"); strSql.Append(" values ("); strSql.Append("@Name,@Desc,@Enabled)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Name", SqlDbType.NVarChar, 50), new SqlParameter("@Desc", SqlDbType.NVarChar, 500), new SqlParameter("@Enabled", SqlDbType.Bit, 1) }; parameters[0].Value = model; parameters[1].Value = model.Desc; parameters[2].Value = model.Enabled; param.Add(strSql.ToString(), parameters); return(param); }
private void FillControls() { LPWeb.Model.Divisions model = null; try { model = divManager.GetModel(iDivisionID); if (model == null) { return; } ckbEnabled.Checked = model.Enabled; txbDescription.Text = model.Desc; BindExecutives(iDivisionID); if (model.GroupID.HasValue && ddlGroupAccess.Items.FindByValue(model.GroupID.Value.ToString()) != null) { ddlGroupAccess.SelectedValue = model.GroupID.Value.ToString();//设置选中项 } else { ddlGroupAccess.SelectedValue = "0"; } } catch { } }
protected void btnSave_Click(object sender, EventArgs e) { bool bEnabled = this.ckbEnabled.Checked; string sDesc = this.txbDescription.Text.Trim(); string sBranchMemberIDs = this.hdnBranchMemberIDs.Value; string sExectives = this.hdnExecutiveIDs.Value; StringBuilder sbOldGroupMemberIDs = new StringBuilder(); int iGroupID = 0; if (this.ddlGroupAccess.SelectedIndex >= 0) { iGroupID = Convert.ToInt32(this.ddlGroupAccess.SelectedValue); } LPWeb.Model.Divisions model = this.divManager.GetModel(this.iDivisionID); int iOldGroupID = Convert.ToInt32(model.GroupID); try { this.divManager.SaveDivisionAndMembersBase(this.iDivisionID, bEnabled, sDesc, iGroupID, sBranchMemberIDs, sExectives); //Save group folder info GroupFolder groupFolder = new GroupFolder(); if (iGroupID != 0) { groupFolder.DoSaveGroupFolder(Convert.ToInt32(iGroupID), this.iDivisionID, "division", iOldGroupID); } model = this.divManager.GetModel(this.iDivisionID); if (model.RegionID != 0 && model.RegionID != null) { Regions regMgr = new Regions(); LPWeb.Model.Regions regionModel = regMgr.GetModel(Convert.ToInt32(model.RegionID)); if (regionModel.GroupID != null && regionModel.GroupID != 0) { groupFolder.DoSaveGroupFolder(Convert.ToInt32(regionModel.GroupID), Convert.ToInt32(model.RegionID), "region", Convert.ToInt32(regionModel.GroupID)); } } PageCommon.WriteJsEnd(this, "Division saved successfully.", PageCommon.Js_RefreshSelf); } catch (Exception ex) { LPLog.LogMessage(ex.Message); PageCommon.WriteJsEnd(this, "Failed to save the record.", PageCommon.Js_RefreshSelf); } }
/// <summary> /// 获得数据列表 /// </summary> public List <LPWeb.Model.Divisions> DataTableToList(DataTable dt) { List <LPWeb.Model.Divisions> modelList = new List <LPWeb.Model.Divisions>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { LPWeb.Model.Divisions model; for (int n = 0; n < rowsCount; n++) { model = new LPWeb.Model.Divisions(); if (dt.Rows[n]["DivisionId"].ToString() != "") { model.DivisionId = int.Parse(dt.Rows[n]["DivisionId"].ToString()); } model.Name = dt.Rows[n]["Name"].ToString(); model.Desc = dt.Rows[n]["Desc"].ToString(); if (dt.Rows[n]["Enabled"].ToString() != "") { if ((dt.Rows[n]["Enabled"].ToString() == "1") || (dt.Rows[n]["Enabled"].ToString().ToLower() == "true")) { model.Enabled = true; } else { model.Enabled = false; } } if (dt.Rows[n]["RegionID"].ToString() != "") { model.RegionID = int.Parse(dt.Rows[n]["RegionID"].ToString()); } if (dt.Rows[n]["GroupID"].ToString() != "") { model.GroupID = int.Parse(dt.Rows[n]["GroupID"].ToString()); } modelList.Add(model); } } return(modelList); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(LPWeb.Model.Divisions model) { dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(LPWeb.Model.Divisions model) { return(dal.Add(model)); }