/// <summary>
/// 更新一条数据
/// </summary>
public void Update(LPWeb.Model.Divisions model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Divisions set ");
strSql.Append("DivisionId=@DivisionId,");
strSql.Append("Name=@Name,");
strSql.Append("[Desc]=@Desc,");
strSql.Append("Enabled=@Enabled,");
strSql.Append("RegionID=@RegionID,");
strSql.Append("GroupID=@GroupID");
strSql.Append(" where DivisionId=@DivisionId ");
SqlParameter[] parameters =
{
new SqlParameter("@DivisionId", SqlDbType.Int, 4),
new SqlParameter("@Name", SqlDbType.NVarChar, 50),
new SqlParameter("@Desc", SqlDbType.NVarChar, 500),
new SqlParameter("@Enabled", SqlDbType.Bit, 1),
new SqlParameter("@RegionID", SqlDbType.Int, 4),
new SqlParameter("@GroupID", SqlDbType.Int, 4)
};
parameters[0].Value = model.DivisionId;
parameters[1].Value = model.Name;
parameters[2].Value = model.Desc;
parameters[3].Value = model.Enabled;
parameters[4].Value = model.RegionID;
parameters[5].Value = model.GroupID;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(LPWeb.Model.Divisions model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Divisions(");
strSql.Append("Name,[Desc],Enabled,RegionID,GroupID)");
strSql.Append(" values (");
strSql.Append("@Name,@Desc,@Enabled,@RegionID,@GroupID)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Name", SqlDbType.NVarChar, 50),
new SqlParameter("@Desc", SqlDbType.NVarChar, 500),
new SqlParameter("@Enabled", SqlDbType.Bit, 1),
new SqlParameter("@RegionID", SqlDbType.Int, 4),
new SqlParameter("@GroupID", SqlDbType.Int, 4)
};
parameters[0].Value = model.Name;
parameters[1].Value = model.Desc;
parameters[2].Value = model.Enabled;
parameters[3].Value = model.RegionID;
parameters[4].Value = model.GroupID;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public LPWeb.Model.Divisions GetModel(int DivisionId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 DivisionId,Name,[Desc],Enabled,RegionID,GroupID from Divisions ");
strSql.Append(" where DivisionId=@DivisionId ");
SqlParameter[] parameters =
{
new SqlParameter("@DivisionId", SqlDbType.Int, 4)
};
parameters[0].Value = DivisionId;
LPWeb.Model.Divisions model = new LPWeb.Model.Divisions();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["DivisionId"].ToString() != "")
{
model.DivisionId = int.Parse(ds.Tables[0].Rows[0]["DivisionId"].ToString());
}
model.Name = ds.Tables[0].Rows[0]["Name"].ToString();
model.Desc = ds.Tables[0].Rows[0]["Desc"].ToString();
if (ds.Tables[0].Rows[0]["Enabled"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["Enabled"].ToString() == "1") || (ds.Tables[0].Rows[0]["Enabled"].ToString().ToLower() == "true"))
{
model.Enabled = true;
}
else
{
model.Enabled = false;
}
}
if (ds.Tables[0].Rows[0]["RegionID"].ToString() != "")
{
model.RegionID = int.Parse(ds.Tables[0].Rows[0]["RegionID"].ToString());
}
if (ds.Tables[0].Rows[0]["GroupID"].ToString() != "")
{
model.GroupID = int.Parse(ds.Tables[0].Rows[0]["GroupID"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 保存Division和Members信息
/// </summary>
/// <param name="iGroupID"></param>
/// <param name="bEnabled"></param>
/// <param name="sGroupDesc"></param>
/// <param name="sOldGroupMemberIDs"></param>
/// <param name="sGroupMemberIDs"></param>
public void SaveDivisionAndMembersBase(int iDivisionID, bool bEnabled, string sDesc, int iGroupId, string sBranchMemberIDs, string sExectives)
{
Collection <SqlCommand> SqlCmdList = new Collection <SqlCommand>();
#region SQL for 更新Division信息
string sSql = "UPDATE Divisions set Enabled=@Enabled, [Desc]=@Desc, [GroupID]=@GroupID where DivisionID=" + iDivisionID;
SqlCommand SqlCmd = new SqlCommand(sSql);
DbHelperSQL.AddSqlParameter(SqlCmd, "@Enabled", SqlDbType.Bit, bEnabled);
DbHelperSQL.AddSqlParameter(SqlCmd, "@Desc", SqlDbType.NVarChar, sDesc);
DbHelperSQL.AddSqlParameter(SqlCmd, "@GroupID", SqlDbType.Int, iGroupId);
SqlCmdList.Add(SqlCmd);
#endregion
string sSql5 = "update Branches set RegionID=null,DivisionID=null where DivisionID = " + iDivisionID.ToString();
SqlCommand SqlCmd5 = new SqlCommand(sSql5);
SqlCmdList.Add(SqlCmd5);
LPWeb.Model.Divisions model = GetModel(iDivisionID);
if (sBranchMemberIDs != string.Empty)
{
// 清空新添加members的ID信息
string sSql5x = "update Branches set RegionID=null where BranchID in (" + sBranchMemberIDs + ")";
SqlCommand SqlCmd5x = new SqlCommand(sSql5x);
SqlCmdList.Add(SqlCmd5x);
#region
// 获取Group信息
string sRegionID = null;
string sSql6 = string.Empty;
if (model.RegionID != null)
{
sRegionID = model.RegionID.ToString();
sSql6 = "update Branches set RegionID=" + sRegionID + ",DivisionID= " + iDivisionID.ToString() + " where BranchID in (" + sBranchMemberIDs + ")";
}
else
{
sSql6 = "update Branches set RegionID=null,DivisionID= " + iDivisionID.ToString() + " where BranchID in (" + sBranchMemberIDs + ")";
}
SqlCommand SqlCmd6 = new SqlCommand(sSql6);
SqlCmdList.Add(SqlCmd6);
#endregion
}
#region 更新 group 表
string sSql9 = "EXEC GroupRelationInfoUpdate 'Division'," + iDivisionID.ToString() + "," + iGroupId.ToString();
SqlCommand sqlcmd9 = new SqlCommand(sSql9);
SqlCmdList.Add(sqlcmd9);
////Clear all group data
//string sSql9 = "UPDATE Groups SET RegionID=NULL,OrganizationType=NULL,DivisionID=NULL,BranchID=NULL WHERE DivisionID=" + iDivisionID.ToString();
//SqlCommand sqlcmd9 = new SqlCommand(sSql9);
//SqlCmdList.Add(sqlcmd9);
////设置新的group属于当前region DivisionID
//string sSql10 = string.Empty;
//string sSql11 = string.Empty;
//if (model.GroupID.HasValue)
//{
// if (model.RegionID.HasValue)
// {
// sSql10 = "UPDATE Groups SET RegionID=" + model.RegionID.ToString() + ",OrganizationType='Division',DivisionID=" + iDivisionID.ToString() + " WHERE GroupID=" + model.GroupID.ToString();
// //Update all branch and group relation data
// sSql11 = "UPDATE Groups SET RegionID=" + model.RegionID.ToString() + ",OrganizationType='Branch', DivisionID=" + iDivisionID.ToString() + ", BranchID=";
// }
// else
// {
// sSql10 = "UPDATE Groups SET OrganizationType='Division',DivisionID=" + iDivisionID.ToString() + " WHERE GroupID=" + model.GroupID.ToString();
// }
// SqlCommand sqlcmd10 = new SqlCommand(sSql10);
// SqlCmdList.Add(sqlcmd10);
//}
#endregion
string sSql4 = "DELETE DivisionExecutives WHERE [DivisionId] = @DivisionId ";
SqlCommand SqlCmd4 = new SqlCommand(sSql4);
DbHelperSQL.AddSqlParameter(SqlCmd4, "@DivisionId", SqlDbType.Int, iDivisionID);
SqlCmdList.Add(SqlCmd4);
if (sExectives != string.Empty)
{
string[] managers = sExectives.Split(",".ToCharArray());
foreach (string manager in managers)
{
string sSql5x = "INSERT INTO DivisionExecutives(DivisionId,ExecutiveId) values ( @DivisionId,@ExecutiveId)";
SqlCommand SqlCmd5x = new SqlCommand(sSql5x);
DbHelperSQL.AddSqlParameter(SqlCmd5x, "@DivisionId", SqlDbType.Int, iDivisionID);
DbHelperSQL.AddSqlParameter(SqlCmd5x, "@ExecutiveId", SqlDbType.Int, int.Parse(manager));
SqlCmdList.Add(SqlCmd5x);
}
}
#region 批量执行SQL
SqlConnection SqlConn = null;
SqlTransaction SqlTrans = null;
try
{
SqlConn = DbHelperSQL.GetOpenConnection();
SqlTrans = SqlConn.BeginTransaction();
foreach (SqlCommand xSqlCmd in SqlCmdList)
{
DbHelperSQL.ExecuteNonQuery(xSqlCmd, SqlTrans);
}
SqlTrans.Commit();
}
catch (Exception ex)
{
SqlTrans.Rollback();
throw ex;
}
finally
{
if (SqlConn != null)
{
SqlConn.Close();
}
}
#endregion
}
protected void btnSave_Click(object sender, EventArgs e)
{
#region set Default
if (!string.IsNullOrEmpty(hifId.Value))
{
bool IsCancel = false;
var val = hifId.Value.Split(':');
if (val.Count() != 2)
{
return;
}
IsCancel = Convert.ToBoolean(val[1]);
PointFolders folder = new PointFolders();
folder.SetDefaultPoint(val[0], this.iBranchID, IsCancel);
}
#endregion
bool bEnabled = this.ckbEnabled.Checked;
string sDesc = this.txbDescription.Text.Trim();
string sFolderIDs = this.hdnFolderIDs.Value;
string sManagers = this.hdnManagers.Value;
LPWeb.Model.Branches model = new LPWeb.Model.Branches();
model = branchManager.GetModel(iBranchID);
int iOldGroupID = Convert.ToInt32(model.GroupID);
model.BranchId = iBranchID;
model.Enabled = ckbEnabled.Checked;
model.Desc = txbDescription.Text.Trim();
model.Name = ddlBranchName.SelectedItem.Text;
if (ddlGroupAccess.Items.Count > 0)
{
model.GroupID = int.Parse(ddlGroupAccess.SelectedValue);
}
else
{
model.GroupID = 0;
}
model.BranchAddress = txbAddress.Text.Trim();
model.City = txbCity.Text.Trim();
model.Zip = txbZip.Text.Trim();
model.BranchState = ddlState.SelectedValue.Trim();
if (this.fuldWebLogo.HasFile && this.fuldWebLogo.FileName.ToUpper().IndexOf(".TIF") < 0)
{
model.WebsiteLogo = fuldWebLogo.FileBytes;
}
else
{
model.WebsiteLogo = null;
}
model.License1 = txbLicense1.Text.Trim();
model.License2 = txbLicense2.Text.Trim();
model.License3 = txbLicense3.Text.Trim();
model.License4 = txbLicense4.Text.Trim();
model.License5 = txbLicense5.Text.Trim();
model.Disclaimer = txbDisclaimer.Text.Trim();
model.Phone = txbPhone.Text.Trim();
model.Fax = txbFax.Text.Trim();
model.Email = txbEmail.Text.Trim();
model.WebURL = txbWebURL.Text.Trim();
var oldHomeBranch = model.HomeBranch;
model.HomeBranch = chkHomeBranch.Checked;
try
{
if (oldHomeBranch != model.HomeBranch)
{
branchManager.SetOtherHomeBranchFalse(model.BranchId);
}
branchManager.SaveBranchAndMembersBase(model, sFolderIDs, sManagers);
//Save point folder enable status
PointFolders pointFolderMgr = new PointFolders();
if (this.hdnDisableFolderIDs.Value.Trim() != "")
{
pointFolderMgr.UpdatePointFolderEnabled(this.hdnDisableFolderIDs.Value, false);
}
if (this.hdnEnableFolderIDs.Value.Trim() != "")
{
pointFolderMgr.UpdatePointFolderEnabled(this.hdnEnableFolderIDs.Value, true);
}
//this.divManager.SaveDivisionAndMembersBase(this.iDivisionID, bEnabled, sDesc, sBranchMemberIDs, sExectives);
//Save group folder info
model = branchManager.GetModel(model.BranchId);
GroupFolder groupFolder = new GroupFolder();
if (model.GroupID != 0)
{
groupFolder.DoSaveGroupFolder(Convert.ToInt32(model.GroupID), model.BranchId, "branch", iOldGroupID);
}
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));
}
}
if (model.DivisionID != 0 && model.DivisionID != null)
{
Divisions divMgr = new Divisions();
LPWeb.Model.Divisions divModel = divMgr.GetModel(Convert.ToInt32(model.DivisionID));
if (divModel.GroupID != null && divModel.GroupID != 0)
{
groupFolder.DoSaveGroupFolder(Convert.ToInt32(divModel.GroupID), Convert.ToInt32(model.DivisionID), "division", Convert.ToInt32(divModel.GroupID));
}
}
PageCommon.WriteJsEnd(this, "Branch saved successfully.", PageCommon.Js_RefreshSelf);
}
catch
{
PageCommon.WriteJsEnd(this, "Failed to save the record.", PageCommon.Js_RefreshSelf);
}
}
