/// <summary>
/// 增加一条数据
/// </summary>
public int Add(LPWeb.Model.Branches model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Branches(");
strSql.Append("Name,[Desc],Enabled,RegionID,DivisionID,GroupID,BranchAddress,City,BranchState,Zip,WebsiteLogo,Phone,Fax,Email,WebURL)");
strSql.Append(" values (");
strSql.Append("@Name,@Desc,@Enabled,@RegionID,@DivisionID,@GroupID,@BranchAddress,@City,@BranchState,@Zip,@WebsiteLogo,@Phone,@Fax,@Email,@WebURL)");
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("@DivisionID", SqlDbType.Int, 4),
new SqlParameter("@GroupID", SqlDbType.Int, 4),
new SqlParameter("@BranchAddress", SqlDbType.NVarChar, 255),
new SqlParameter("@City", SqlDbType.NVarChar, 50),
new SqlParameter("@BranchState", SqlDbType.NVarChar, 2),
new SqlParameter("@Zip", SqlDbType.NVarChar, 5),
new SqlParameter("@WebsiteLogo", SqlDbType.VarBinary),
new SqlParameter("@Phone", SqlDbType.NVarChar, 20),
new SqlParameter("@Fax", SqlDbType.NVarChar, 20),
new SqlParameter("@Email", SqlDbType.NVarChar, 255),
new SqlParameter("@WebURL", SqlDbType.NVarChar, 255)
};
parameters[0].Value = model.Name;
parameters[1].Value = model.Desc;
parameters[2].Value = model.Enabled;
parameters[3].Value = model.RegionID;
parameters[4].Value = model.DivisionID;
parameters[5].Value = model.GroupID;
parameters[6].Value = model.BranchAddress;
parameters[7].Value = model.City;
parameters[8].Value = model.BranchState;
parameters[9].Value = model.Zip;
parameters[10].Value = model.WebsiteLogo;
parameters[11].Value = model.Phone;
parameters[12].Value = model.Fax;
parameters[13].Value = model.Email;
parameters[14].Value = model.WebURL;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
LPWeb.Model.Branches model = new LPWeb.Model.Branches();
model.BranchId = BranchID;
model.EnableMailChimp = cbEnableMailChimp.Checked;
model.MailChimpAPIKey = txbMCKey.Text.Trim();
bllB.UpdateChimpAPIKey(model);
}
catch
{
}
}
private void FillControl()
{
LPWeb.Model.Branches model = new LPWeb.Model.Branches();
model = bllB.GetModel(BranchID);
cbEnableMailChimp.Checked = model.EnableMailChimp;
txbMCKey.Text = model.MailChimpAPIKey;
if (cbEnableMailChimp.Checked)
{
txbMCKey.Enabled = true;
}
else
{
txbMCKey.Enabled = false;
}
}
/// <summary>
/// UpdateChimpAPIKey
/// </summary>
public void UpdateChimpAPIKey(LPWeb.Model.Branches model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" update Branches set ");
strSql.Append(" EnableMailChimp=@EnableMailChimp,");
strSql.Append(" MailChimpAPIKey=@MailChimpAPIKey ");
strSql.Append(" where BranchId=@BranchId ");
SqlParameter[] parameters =
{
new SqlParameter("@BranchId", SqlDbType.Int, 4),
new SqlParameter("@EnableMailChimp", SqlDbType.Bit),
new SqlParameter("@MailChimpAPIKey", SqlDbType.NVarChar, 255)
};
parameters[0].Value = model.BranchId;
parameters[1].Value = model.EnableMailChimp;
parameters[2].Value = model.MailChimpAPIKey;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(LPWeb.Model.Branches model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Branches set ");
strSql.Append("BranchId=@BranchId,");
strSql.Append("Name=@Name,");
strSql.Append("[Desc]=@Desc,");
strSql.Append("Enabled=@Enabled,");
strSql.Append("RegionID=@RegionID,");
strSql.Append("DivisionID=@DivisionID,");
strSql.Append("GroupID=@GroupID,");
strSql.Append("BranchAddress=@BranchAddress,");
strSql.Append("City=@City,");
strSql.Append("BranchState=@BranchState,");
strSql.Append("Zip=@Zip,");
strSql.Append("WebsiteLogo=@WebsiteLogo,");
strSql.Append("Phone=@Phone,");
strSql.Append("Fax=@Fax,");
strSql.Append("Email=@Email,");
strSql.Append("WebURL=@WebURL,");
strSql.Append(" where BranchId=@BranchId ");
SqlParameter[] parameters =
{
new SqlParameter("@BranchId", 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("@DivisionID", SqlDbType.Int, 4),
new SqlParameter("@GroupID", SqlDbType.Int, 4),
new SqlParameter("@BranchAddress", SqlDbType.NVarChar, 255),
new SqlParameter("@City", SqlDbType.NVarChar, 50),
new SqlParameter("@BranchState", SqlDbType.NVarChar, 2),
new SqlParameter("@Zip", SqlDbType.NVarChar, 5),
new SqlParameter("@WebsiteLogo", SqlDbType.VarBinary),
new SqlParameter("@Phone", SqlDbType.NVarChar, 20),
new SqlParameter("@Fax", SqlDbType.NVarChar, 20),
new SqlParameter("@Email", SqlDbType.NVarChar, 255),
new SqlParameter("@WebURL", SqlDbType.NVarChar, 255)
};
parameters[0].Value = model.BranchId;
parameters[1].Value = model.Name;
parameters[2].Value = model.Desc;
parameters[3].Value = model.Enabled;
parameters[4].Value = model.RegionID;
parameters[5].Value = model.DivisionID;
parameters[6].Value = model.GroupID;
parameters[7].Value = model.BranchAddress;
parameters[8].Value = model.City;
parameters[9].Value = model.BranchState;
parameters[10].Value = model.Zip;
parameters[11].Value = model.WebsiteLogo;
parameters[12].Value = model.Phone;
parameters[13].Value = model.Fax;
parameters[14].Value = model.Email;
parameters[15].Value = model.WebURL;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
/// <summary>
/// 得到一个对象实体
/// </summary>
public LPWeb.Model.Branches GetModel(int BranchId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 BranchId,[Name],[Desc],Enabled,RegionID,DivisionID,GroupID,BranchAddress,City,BranchState,Zip,WebsiteLogo,GlobalId,License1,License2,License3,License4,Disclaimer,Phone,Fax,WebURL,Email,License5,Leadstar_Username,Leadstar_ID,Leadstar_Userid,HomeBranch,EnableMailChimp,MailChimpAPIKey from Branches ");
strSql.Append(" where BranchId=@BranchId");
SqlParameter[] parameters =
{
new SqlParameter("@BranchId", SqlDbType.Int, 4)
};
parameters[0].Value = BranchId;
LPWeb.Model.Branches model = new LPWeb.Model.Branches();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["BranchId"] != null && ds.Tables[0].Rows[0]["BranchId"].ToString() != "")
{
model.BranchId = int.Parse(ds.Tables[0].Rows[0]["BranchId"].ToString());
}
if (ds.Tables[0].Rows[0]["Name"] != null && ds.Tables[0].Rows[0]["Name"].ToString() != "")
{
model.Name = ds.Tables[0].Rows[0]["Name"].ToString();
}
if (ds.Tables[0].Rows[0]["Desc"] != null && ds.Tables[0].Rows[0]["Desc"].ToString() != "")
{
model.Desc = ds.Tables[0].Rows[0]["Desc"].ToString();
}
if (ds.Tables[0].Rows[0]["Enabled"] != null && 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"] != null && ds.Tables[0].Rows[0]["RegionID"].ToString() != "")
{
model.RegionID = int.Parse(ds.Tables[0].Rows[0]["RegionID"].ToString());
}
if (ds.Tables[0].Rows[0]["DivisionID"] != null && ds.Tables[0].Rows[0]["DivisionID"].ToString() != "")
{
model.DivisionID = int.Parse(ds.Tables[0].Rows[0]["DivisionID"].ToString());
}
if (ds.Tables[0].Rows[0]["GroupID"] != null && ds.Tables[0].Rows[0]["GroupID"].ToString() != "")
{
model.GroupID = int.Parse(ds.Tables[0].Rows[0]["GroupID"].ToString());
}
if (ds.Tables[0].Rows[0]["BranchAddress"] != null && ds.Tables[0].Rows[0]["BranchAddress"].ToString() != "")
{
model.BranchAddress = ds.Tables[0].Rows[0]["BranchAddress"].ToString();
}
if (ds.Tables[0].Rows[0]["City"] != null && ds.Tables[0].Rows[0]["City"].ToString() != "")
{
model.City = ds.Tables[0].Rows[0]["City"].ToString();
}
if (ds.Tables[0].Rows[0]["BranchState"] != null && ds.Tables[0].Rows[0]["BranchState"].ToString() != "")
{
model.BranchState = ds.Tables[0].Rows[0]["BranchState"].ToString();
}
if (ds.Tables[0].Rows[0]["Zip"] != null && ds.Tables[0].Rows[0]["Zip"].ToString() != "")
{
model.Zip = ds.Tables[0].Rows[0]["Zip"].ToString();
}
if (ds.Tables[0].Rows[0]["WebsiteLogo"] != null && ds.Tables[0].Rows[0]["WebsiteLogo"].ToString() != "")
{
model.WebsiteLogo = (byte[])ds.Tables[0].Rows[0]["WebsiteLogo"];
}
if (ds.Tables[0].Rows[0]["GlobalId"] != null && ds.Tables[0].Rows[0]["GlobalId"].ToString() != "")
{
model.GlobalId = ds.Tables[0].Rows[0]["GlobalId"].ToString();
}
if (ds.Tables[0].Rows[0]["License1"] != null && ds.Tables[0].Rows[0]["License1"].ToString() != "")
{
model.License1 = ds.Tables[0].Rows[0]["License1"].ToString();
}
if (ds.Tables[0].Rows[0]["License2"] != null && ds.Tables[0].Rows[0]["License2"].ToString() != "")
{
model.License2 = ds.Tables[0].Rows[0]["License2"].ToString();
}
if (ds.Tables[0].Rows[0]["License3"] != null && ds.Tables[0].Rows[0]["License3"].ToString() != "")
{
model.License3 = ds.Tables[0].Rows[0]["License3"].ToString();
}
if (ds.Tables[0].Rows[0]["License4"] != null && ds.Tables[0].Rows[0]["License4"].ToString() != "")
{
model.License4 = ds.Tables[0].Rows[0]["License4"].ToString();
}
if (ds.Tables[0].Rows[0]["Disclaimer"] != null && ds.Tables[0].Rows[0]["Disclaimer"].ToString() != "")
{
model.Disclaimer = ds.Tables[0].Rows[0]["Disclaimer"].ToString();
}
if (ds.Tables[0].Rows[0]["Phone"] != null && ds.Tables[0].Rows[0]["Phone"].ToString() != "")
{
model.Phone = ds.Tables[0].Rows[0]["Phone"].ToString();
}
if (ds.Tables[0].Rows[0]["Fax"] != null && ds.Tables[0].Rows[0]["Fax"].ToString() != "")
{
model.Fax = ds.Tables[0].Rows[0]["Fax"].ToString();
}
if (ds.Tables[0].Rows[0]["WebURL"] != null && ds.Tables[0].Rows[0]["WebURL"].ToString() != "")
{
model.WebURL = ds.Tables[0].Rows[0]["WebURL"].ToString();
}
if (ds.Tables[0].Rows[0]["Email"] != null && ds.Tables[0].Rows[0]["Email"].ToString() != "")
{
model.Email = ds.Tables[0].Rows[0]["Email"].ToString();
}
if (ds.Tables[0].Rows[0]["License5"] != null && ds.Tables[0].Rows[0]["License5"].ToString() != "")
{
model.License5 = ds.Tables[0].Rows[0]["License5"].ToString();
}
if (ds.Tables[0].Rows[0]["Leadstar_Username"] != null && ds.Tables[0].Rows[0]["Leadstar_Username"].ToString() != "")
{
model.Leadstar_Username = ds.Tables[0].Rows[0]["Leadstar_Username"].ToString();
}
if (ds.Tables[0].Rows[0]["Leadstar_ID"] != null && ds.Tables[0].Rows[0]["Leadstar_ID"].ToString() != "")
{
model.Leadstar_ID = ds.Tables[0].Rows[0]["Leadstar_ID"].ToString();
}
if (ds.Tables[0].Rows[0]["Leadstar_Userid"] != null && ds.Tables[0].Rows[0]["Leadstar_Userid"].ToString() != "")
{
model.Leadstar_Userid = ds.Tables[0].Rows[0]["Leadstar_Userid"].ToString();
}
if (ds.Tables[0].Rows[0]["HomeBranch"] != null && ds.Tables[0].Rows[0]["HomeBranch"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["HomeBranch"].ToString() == "1") || (ds.Tables[0].Rows[0]["HomeBranch"].ToString().ToLower() == "true"))
{
model.HomeBranch = true;
}
else
{
model.HomeBranch = false;
}
}
if (ds.Tables[0].Rows[0]["EnableMailChimp"] != null && ds.Tables[0].Rows[0]["EnableMailChimp"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["EnableMailChimp"].ToString() == "1") || (ds.Tables[0].Rows[0]["EnableMailChimp"].ToString().ToLower() == "true"))
{
model.EnableMailChimp = true;
}
else
{
model.EnableMailChimp = false;
}
}
if (ds.Tables[0].Rows[0]["MailChimpAPIKey"] != null && ds.Tables[0].Rows[0]["MailChimpAPIKey"].ToString() != "")
{
model.MailChimpAPIKey = ds.Tables[0].Rows[0]["MailChimpAPIKey"].ToString();
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 保存Branch和Members信息
/// </summary>
/// <param name="iGroupID"></param>
/// <param name="bEnabled"></param>
/// <param name="sGroupDesc"></param>
/// <param name="sOldGroupMemberIDs"></param>
/// <param name="sGroupMemberIDs"></param>
public void SaveBranchAndMembersBase(LPWeb.Model.Branches model, string sFolderIDs, string sManagers)
{
Collection <SqlCommand> SqlCmdList = new Collection <SqlCommand>();
#region SQL for 更新Branches信息
string sSql = string.Empty;
if (model.WebsiteLogo != null)
{
sSql = " UPDATE [Branches] SET [Name] = @Name,[Desc] = @Desc,[WebsiteLogo] = @WebsiteLogo,[Enabled] = @Enabled, [GroupID] = @GroupID, [BranchAddress] = @BranchAddress,[City] = @City,[BranchState] = @BranchState,[Zip] = @Zip,License1=@License1,License2=@License2,License3=@License3,License4=@License4,License5=@License5,Disclaimer=@Disclaimer,Phone=@Phone,Fax=@Fax,Email=@Email,WebURL=@WebURL,HomeBranch=@HomeBranch WHERE BranchId=@BranchId ";
}
else
{
sSql = " UPDATE [Branches] SET [Name] = @Name,[Desc] = @Desc,[Enabled] = @Enabled , [GroupID] = @GroupID, [BranchAddress] = @BranchAddress,[City] = @City,[BranchState] = @BranchState,[Zip] = @Zip,License1=@License1,License2=@License2,License3=@License3,License4=@License4,License5=@License5,Disclaimer=@Disclaimer,Phone=@Phone,Fax=@Fax,Email=@Email,WebURL=@WebURL,HomeBranch=@HomeBranch WHERE BranchId=@BranchId ";
}
SqlCommand SqlCmd = new SqlCommand(sSql);
DbHelperSQL.AddSqlParameter(SqlCmd, "@Name", SqlDbType.NVarChar, model.Name);
DbHelperSQL.AddSqlParameter(SqlCmd, "@Desc", SqlDbType.NVarChar, model.Desc);
if (model.WebsiteLogo != null)
{
DbHelperSQL.AddSqlParameter(SqlCmd, "@WebsiteLogo", SqlDbType.VarBinary, model.WebsiteLogo);
}
DbHelperSQL.AddSqlParameter(SqlCmd, "@Enabled", SqlDbType.Bit, model.Enabled);
DbHelperSQL.AddSqlParameter(SqlCmd, "@GroupID", SqlDbType.Int, model.GroupID);
DbHelperSQL.AddSqlParameter(SqlCmd, "@BranchAddress", SqlDbType.NVarChar, model.BranchAddress);
DbHelperSQL.AddSqlParameter(SqlCmd, "@City", SqlDbType.NVarChar, model.City);
DbHelperSQL.AddSqlParameter(SqlCmd, "@BranchState", SqlDbType.NVarChar, model.BranchState);
DbHelperSQL.AddSqlParameter(SqlCmd, "@Zip", SqlDbType.NVarChar, model.Zip);
DbHelperSQL.AddSqlParameter(SqlCmd, "@BranchId", SqlDbType.Int, model.BranchId);
DbHelperSQL.AddSqlParameter(SqlCmd, "@License1", SqlDbType.NVarChar, model.License1);
DbHelperSQL.AddSqlParameter(SqlCmd, "@License2", SqlDbType.NVarChar, model.License2);
DbHelperSQL.AddSqlParameter(SqlCmd, "@License3", SqlDbType.NVarChar, model.License3);
DbHelperSQL.AddSqlParameter(SqlCmd, "@License4", SqlDbType.NVarChar, model.License4);
DbHelperSQL.AddSqlParameter(SqlCmd, "@License5", SqlDbType.NVarChar, model.License5);
DbHelperSQL.AddSqlParameter(SqlCmd, "@Disclaimer", SqlDbType.NVarChar, model.Disclaimer);
DbHelperSQL.AddSqlParameter(SqlCmd, "@Phone", SqlDbType.NVarChar, model.Phone);
DbHelperSQL.AddSqlParameter(SqlCmd, "@Fax", SqlDbType.NVarChar, model.Fax);
DbHelperSQL.AddSqlParameter(SqlCmd, "@Email", SqlDbType.NVarChar, model.Email);
DbHelperSQL.AddSqlParameter(SqlCmd, "@WebURL", SqlDbType.NVarChar, model.WebURL);
DbHelperSQL.AddSqlParameter(SqlCmd, "@HomeBranch", SqlDbType.Bit, model.HomeBranch);
SqlCmdList.Add(SqlCmd);
#endregion
string sSql5 = " UPDATE [PointFolders] SET [BranchId] = null WHERE [BranchId]=@BranchId ";
SqlCommand SqlCmd5 = new SqlCommand(sSql5);
DbHelperSQL.AddSqlParameter(SqlCmd5, "@BranchId", SqlDbType.Int, model.BranchId);
SqlCmdList.Add(SqlCmd5);
string sSql2 = " UPDATE [PointFolders] SET [BranchId] = null WHERE [BranchId]=@BranchId ";
SqlCommand SqlCmd2 = new SqlCommand(sSql2);
DbHelperSQL.AddSqlParameter(SqlCmd2, "@BranchId", SqlDbType.Int, model.BranchId);
SqlCmdList.Add(SqlCmd2);
if (sFolderIDs != string.Empty)
{
string[] folders = sFolderIDs.Split("|".ToCharArray());
foreach (string folder in folders)
{
string[] folderstatus = folder.Split(",".ToCharArray());
if (folderstatus.Length == 2)
{
string sSql3 = " UPDATE [PointFolders] SET [BranchId] = @BranchId,LoanStatus=@LoanStatus WHERE FolderId = @FolderId";
SqlCommand SqlCmd3 = new SqlCommand(sSql3);
DbHelperSQL.AddSqlParameter(SqlCmd3, "@BranchId", SqlDbType.Int, model.BranchId);
DbHelperSQL.AddSqlParameter(SqlCmd3, "@LoanStatus", SqlDbType.Int, int.Parse(folderstatus[1]));
DbHelperSQL.AddSqlParameter(SqlCmd3, "@FolderId", SqlDbType.Int, int.Parse(folderstatus[0]));
SqlCmdList.Add(SqlCmd3);
}
}
}
#region 更新 group 表
string sSql9 = "EXEC GroupRelationInfoUpdate 'Branch'," + model.BranchId.ToString() + "," + model.GroupID.ToString();
SqlCommand sqlcmd9 = new SqlCommand(sSql9);
SqlCmdList.Add(sqlcmd9);
//LPWeb.Model.Branches model1 = GetModel(model.BranchId);
//string sSql9 = "UPDATE Groups SET RegionID=NULL,OrganizationType=NULL,DivisionID=NULL,BranchID=NULL WHERE BranchID=" + model.BranchId.ToString();
//SqlCommand sqlcmd9 = new SqlCommand(sSql9);
//SqlCmdList.Add(sqlcmd9);
////设置新的group属于当前region Division branch
//string sSql10 = string.Empty;
//if (model.GroupID.HasValue)
//{
// if (model1.RegionID.HasValue && model1.DivisionID.HasValue)
// {
// sSql10 = "UPDATE Groups SET RegionID=" + model1.RegionID.ToString() + ",OrganizationType='Branch',DivisionID=" + model1.DivisionID.ToString() + ",BranchID=" + model.BranchId.ToString() + " WHERE GroupID=" + model.GroupID.ToString();
// }
// else if (model1.RegionID.HasValue && !model1.DivisionID.HasValue)
// {
// sSql10 = "UPDATE Groups SET RegionID=" + model1.RegionID.ToString() + ",OrganizationType='Branch', BranchID=" + model.BranchId.ToString() + " WHERE GroupID=" + model.GroupID.ToString();
// }
// else if (!model1.RegionID.HasValue && model1.DivisionID.HasValue)
// {
// sSql10 = "UPDATE Groups SET OrganizationType='Branch',DivisionID=" + model1.DivisionID.ToString() + ",BranchID=" + model.BranchId.ToString() + " WHERE GroupID=" + model.GroupID.ToString();
// }
// else
// {
// sSql10 = "UPDATE Groups SET OrganizationType='Branch' ,BranchID=" + model.BranchId.ToString() + " WHERE GroupID=" + model.GroupID.ToString();
// }
// SqlCommand sqlcmd10 = new SqlCommand(sSql10);
// SqlCmdList.Add(sqlcmd10);
//}
#endregion
string sSql4 = "DELETE BranchManagers WHERE [BranchId] = @BranchId ";
SqlCommand SqlCmd4 = new SqlCommand(sSql4);
DbHelperSQL.AddSqlParameter(SqlCmd4, "@BranchId", SqlDbType.Int, model.BranchId);
SqlCmdList.Add(SqlCmd4);
if (sManagers != string.Empty)
{
string[] managers = sManagers.Split(",".ToCharArray());
foreach (string manager in managers)
{
string sSql5x = "INSERT INTO [BranchManagers]([BranchId],[BranchMgrId])VALUES(@BranchId,@BranchMgrId )";
SqlCommand SqlCmd5x = new SqlCommand(sSql5x);
DbHelperSQL.AddSqlParameter(SqlCmd5x, "@BranchId", SqlDbType.Int, model.BranchId);
DbHelperSQL.AddSqlParameter(SqlCmd5x, "@BranchMgrId", 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);
}
}
private void FillBranch()
{
try
{
LPWeb.Model.Branches model = branchManager.GetModel(iBranchID);
ddlBranchName.SelectedValue = iBranchID.ToString();
ckbEnabled.Checked = model.Enabled;
if (model.GroupID.HasValue && ddlGroupAccess.Items.FindByValue(model.GroupID.Value.ToString()) != null)
{
ddlGroupAccess.SelectedValue = model.GroupID.Value.ToString();//设置选中项
}
else
{
ddlGroupAccess.SelectedValue = "0";
}
txbDescription.Text = model.Desc;
txbAddress.Text = model.BranchAddress;
txbCity.Text = model.City;
txbZip.Text = model.Zip;
ddlState.Text = model.BranchState;
txbPhone.Text = model.Phone;
txbFax.Text = model.Fax;
txbEmail.Text = model.Email;
txbWebURL.Text = model.WebURL;
chkHomeBranch.Checked = model.HomeBranch;
chkHomeBranch.Attributes.Add("cid", "chkHomeBranch");
chkHomeBranch.Attributes.Add("BranchID", model.BranchId.ToString());
#region find HomeBranch = true BranchId
var homebranchId = 0;
if (model.HomeBranch != true)
{
var ds = branchManager.GetList(1, " HomeBranch = 1 ", "BranchId");
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
homebranchId = Convert.ToInt32(ds.Tables[0].Rows[0]["BranchId"]);
}
}
else
{
homebranchId = model.BranchId;
}
chkHomeBranch.Attributes.Add("HomeBranchID", homebranchId.ToString());
#endregion
if (model.WebsiteLogo == null)
{
Image1.ImageUrl = "../images/YourLogo.jpg";
}
else if (model.WebsiteLogo.Length < 1)
{
Image1.ImageUrl = "../images/YourLogo.jpg";
}
else
{
Image1.ImageUrl = "BranchLogo.aspx?BranchID=" + iBranchID.ToString() + "&ss=" + DateTime.Now.Millisecond.ToString();
}
txbLicense1.Text = model.License1;
txbLicense2.Text = model.License2;
txbLicense3.Text = model.License3;
txbLicense4.Text = model.License4;
txbLicense5.Text = model.License5;
txbDisclaimer.Text = model.Disclaimer;
}
catch
{
}
}
