/// <summary>
/// Get Branch data
/// </summary>
/// <returns></returns>
private DataTable GetBranchData(string sRegionID, string sDivisionID)
{
DataTable dtBranches;
try
{
Branches branchManager = new Branches();;
//Binding Branch
string sCondition = " Enabled='true'";
if (sRegionID != "" && sRegionID != "0")
{
sCondition += " AND RegionID = " + sRegionID;
}
if (sDivisionID != "" && sDivisionID != "0")
{
sCondition += " AND DivisionID = " + sDivisionID;
}
dtBranches = branchManager.GetList(sCondition).Tables[0];
DataRow drNewBranches = dtBranches.NewRow();
drNewBranches["BranchId"] = 0;
drNewBranches["Name"] = "All Branches";
dtBranches.Rows.InsertAt(drNewBranches, 0);
}
catch (Exception ex)
{
throw ex;
}
return(dtBranches);
}
private void BindSelectBranchs()
{
Branches branch = new Branches();
try
{
string strWhere = " (DivisionID is null) or (DivisionID = " + this.iDivisionID.ToString() + ")";
DataSet ds = branch.GetList(strWhere);
if (ds == null || ds.Tables.Count < 1 || ds.Tables[0].Rows.Count < 1)
{
//ds = null;
}
gridBranchSelectionList.AutoGenerateColumns = false;
gridBranchSelectionList.DataSource = ds.Tables[0];
gridBranchSelectionList.DataBind();
}
catch
{ }
}
private void BindBranchs(int divID)
{
Branches branch = new Branches();
try
{
string strWhere = " DivisionID = " + divID;
DataSet ds = branch.GetList(strWhere);
if (ds == null || ds.Tables.Count < 1 || ds.Tables[0].Rows.Count < 1)
{
//ds=null;
}
gridBranchList.AutoGenerateColumns = false;
gridBranchList.DataSource = ds.Tables[0];
gridBranchList.DataBind();
}
catch
{ }
}
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
{
}
}
public void BindData()
{
#region Local PointFile ----pointFileInfo and pointFolderInfo
if (pointFileInfo != null)
{
txbLastSync.Text = pointFileInfo.LastImported == null ? "" : pointFileInfo.LastImported.Value.ToString("MM/dd/yyyy hh:mm tt");
txbFilename.Text = pointFileInfo.Name;
}
if (pointFolderInfo == null || string.IsNullOrEmpty(pointFolderInfo.Path))
{
txbPath.Text = string.Empty;
}
else
{
txbPath.Text = pointFolderInfo.Path;
}
txbPath.Text += (pointFileInfo == null || string.IsNullOrEmpty(pointFileInfo.Name))?string.Empty : pointFileInfo.Name;
// pointFolderInfo.Name;
txbPath.Enabled = false;
#endregion
#region Branch ----loanInfo.BranchID
Branches bllBranches = new Branches();
if (iBranchId > 0)
{
ddlBranch.DataSource = bllBranches.GetList(" BranchId = " + loanInfo.BranchID);
ddlBranch.DataBind();
if (ddlBranch.Items.Count > 0)
{
ddlBranch.SelectedIndex = 0;
}
ddlBranch.Enabled = false;
}
else
{
DataTable dt = new DataTable();
if (loginUser.sRoleName == "Executive")
{
dt = bllBranches.GetBranchFilter_Executive(loginUser.iUserID, 0, 0);
}
else if (loginUser.sRoleName == "Branch Manager")
{
dt = bllBranches.GetBranchFilter_Branch_Manager(loginUser.iUserID, 0, 0);
}
else
{
dt = bllBranches.GetBranchFilter(loginUser.iUserID, 0, 0);
}
ddlBranch.DataSource = dt;
ddlBranch.DataBind();
ddlBranch.Enabled = true;
}
#endregion
BindOther();
var folderId = pointFolderInfo != null ? pointFolderInfo.FolderId : 0;
var fileName = pointFileInfo != null ? pointFileInfo.Name : "";
#region btnDisabled
//1. Create Point File可用
//a. folder name或filename为空时
//b. Folder name和filename不为空时, 但Point文件不存在
//2. Update Point File可用
//a. Folder name和filename不为空时, 以及Point文件存在
//3. Sync Now 可用
//a. Folder name和filename不为空时, 以及Point文件存在
var pointFileWcf = GetPointFileInfo();
btnCreatePointFile.Disabled = true;
btnSyncNow.Disabled = true;
btnUpdatePoint.Disabled = true;
//Create Point File
if (folderId == 0 || string.IsNullOrEmpty(pointFileInfo.Name))
{
btnCreatePointFile.Disabled = false;
}
else if (!pointFileWcf.FileExists) //not exists
{
btnCreatePointFile.Disabled = false;
}
else
{
btnSyncNow.Disabled = false;
btnUpdatePoint.Disabled = false;
}
#endregion
if (folderId != 0)
{
ddlFolderName.Enabled = false;
}
if (!string.IsNullOrEmpty(fileName))
{
txbFilename.Enabled = false;
}
}