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