/// <summary>
/// 更新一条数据
/// </summary>
public void Update(LPWeb.Model.Company_General model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Company_General set ");
strSql.Append("[Name]=@Name,");
strSql.Append("AD_OU_Filter=@AD_OU_Filter,");
strSql.Append("[Desc]=@Desc,");
strSql.Append("[Address]=@Address,");
strSql.Append("[City]=@City,");
strSql.Append("[State]=@State,");
strSql.Append("[Zip]=@Zip,");
strSql.Append("[ImportUserInterval]=@ImportUserInterval,");
strSql.Append("[ReleaseVersion]=@ReleaseVersion,");
strSql.Append("[Edition]=@Edition,");
strSql.Append("[RuleMonitorInterval]=@RuleMonitorInterval,");
strSql.Append("[GlobalId]=@GlobalId,");
strSql.Append("[EnableMarketing]=@EnableMarketing,");
strSql.Append("[Phone]=@Phone,");
strSql.Append("[Fax]=@Fax,");
strSql.Append("[Email]=@Email,");
strSql.Append("[WebURL]=@WebURL,");
strSql.Append("[IntegrationID]=@IntegrationID,");
strSql.Append("[APIKey]=@APIKey,");
strSql.Append("[LeadStar_ID]=@LeadStar_ID,");
strSql.Append("[LeadStar_username]=@LeadStar_username,");
strSql.Append("[LeadStar_userid]=@LeadStar_userid,");
strSql.Append("[ActiveLoanWorkflow] = @ActiveLoanWorkflow, ");
strSql.Append("[StartMarketingSync] =@StartMarketingSync, ");
strSql.Append("[MyEmailInboxURL] =@MyEmailInboxURL, ");
strSql.Append("[MyCalendarURL] =@MyCalendarURL, ");
strSql.Append("[RatesURL] =@RatesURL ");
//strSql.Append("Prefix=@Prefix");
//strSql.Append(" where ");
SqlParameter[] parameters =
{
new SqlParameter("@Name", SqlDbType.NVarChar, 255),
new SqlParameter("@AD_OU_Filter", SqlDbType.NVarChar, 50),
new SqlParameter("@Desc", SqlDbType.NVarChar, 500),
new SqlParameter("@Address", SqlDbType.NVarChar, 255),
new SqlParameter("@City", SqlDbType.NVarChar, 100),
new SqlParameter("@State", SqlDbType.NVarChar, 2),
new SqlParameter("@Zip", SqlDbType.NVarChar, 5),
new SqlParameter("@ImportUserInterval", SqlDbType.SmallInt, 2),
new SqlParameter("@ReleaseVersion", SqlDbType.NVarChar, 255),
new SqlParameter("@Edition", SqlDbType.Int),
new SqlParameter("@RuleMonitorInterval", SqlDbType.Int),
new SqlParameter("@GlobalId", SqlDbType.NVarChar, 255),
new SqlParameter("@EnableMarketing", SqlDbType.Bit),
new SqlParameter("@Phone", SqlDbType.NVarChar, 20),
new SqlParameter("@Fax", SqlDbType.NVarChar, 20),
new SqlParameter("@Email", SqlDbType.NVarChar, 255),
new SqlParameter("@WebURL", SqlDbType.NVarChar, 255),
new SqlParameter("@IntegrationID", SqlDbType.NVarChar, 255),
new SqlParameter("@APIKey", SqlDbType.NVarChar, 255),
new SqlParameter("@LeadStar_ID", SqlDbType.NVarChar, 255),
new SqlParameter("@LeadStar_username", SqlDbType.NVarChar, 255),
new SqlParameter("@LeadStar_userid", SqlDbType.NVarChar, 255),
new SqlParameter("@ActiveLoanWorkflow", SqlDbType.Bit),
new SqlParameter("@StartMarketingSync", SqlDbType.Bit),
new SqlParameter("@MyEmailInboxURL", SqlDbType.NVarChar),
new SqlParameter("@MyCalendarURL", SqlDbType.NVarChar),
new SqlParameter("@RatesURL", SqlDbType.NVarChar)
};
parameters[0].Value = model.Name;
parameters[1].Value = model.AD_OU_Filter;
parameters[2].Value = model.Desc;
parameters[3].Value = model.Address;
parameters[4].Value = model.City;
parameters[5].Value = model.State;
parameters[6].Value = model.Zip;
parameters[7].Value = model.ImportUserInterval;
parameters[8].Value = model.ReleaseVersion;
parameters[9].Value = model.Edition;
parameters[10].Value = model.RuleMonitorInterval;
parameters[11].Value = model.GlobalId;
parameters[12].Value = model.EnableMarketing;
parameters[13].Value = model.Phone;
parameters[14].Value = model.Fax;
parameters[15].Value = model.Email;
parameters[16].Value = model.WebURL;
parameters[17].Value = model.IntegrationID;
parameters[18].Value = model.APIKey;
parameters[19].Value = model.LeadStar_ID;
parameters[20].Value = model.LeadStar_username;
parameters[21].Value = model.LeadStar_userid;
parameters[22].Value = model.ActiveLoanWorkflow;
parameters[23].Value = model.StartMarketingSync;
parameters[24].Value = model.MyEmailInboxURL;
parameters[25].Value = model.MyCalendarURL;
parameters[26].Value = model.RatesURL;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(LPWeb.Model.Company_General model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Company_General(");
strSql.Append(" Name, AD_OU_Filter,[Desc],Address, City, State, Zip, ImportUserInterval, ReleaseVersion, Edition, RuleMonitorInterval, GlobalId, EnableMarketing, Phone, Fax, Email, WebURL, IntegrationID, APIKey, LeadStar_ID, LeadStar_username, LeadStar_userid, ActiveLoanWorkflow, StartMarketingSync, MyEmailInboxURL, MyCalendarURL, RatesURL)");
strSql.Append(" values (");
strSql.Append("@Name,@AD_OU_Filter,@Desc,@Address,@City,@State,@Zip,@ImportUserInterval,@ReleaseVersion,@Edition,@RuleMonitorInterval,@GlobalId,@EnableMarketing,@Phone,@Fax,@Email,@WebURL,@IntegrationID,@APIKey,@LeadStar_ID,@LeadStar_username,@LeadStar_userid,@ActiveLoanWorkflow,@StartMarketingSync, @MyEmailInboxURL, @MyCalendarURL, @RatesURL)");
SqlParameter[] parameters =
{
new SqlParameter("@Name", SqlDbType.NVarChar, 255),
new SqlParameter("@AD_OU_Filter", SqlDbType.NVarChar, 50),
new SqlParameter("@Desc", SqlDbType.NVarChar, 500),
new SqlParameter("@Address", SqlDbType.NVarChar, 255),
new SqlParameter("@City", SqlDbType.NVarChar, 100),
new SqlParameter("@State", SqlDbType.NVarChar, 2),
new SqlParameter("@Zip", SqlDbType.NVarChar, 5),
new SqlParameter("@ImportUserInterval", SqlDbType.SmallInt, 2),
new SqlParameter("@ReleaseVersion", SqlDbType.NVarChar, 255),
new SqlParameter("@Edition", SqlDbType.Int),
new SqlParameter("@RuleMonitorInterval", SqlDbType.Int),
new SqlParameter("@GlobalId", SqlDbType.NVarChar, 255),
new SqlParameter("@EnableMarketing", SqlDbType.Bit),
new SqlParameter("@Phone", SqlDbType.NVarChar, 20),
new SqlParameter("@Fax", SqlDbType.NVarChar, 20),
new SqlParameter("@Email", SqlDbType.NVarChar, 255),
new SqlParameter("@WebURL", SqlDbType.NVarChar, 255),
new SqlParameter("@IntegrationID", SqlDbType.NVarChar, 255),
new SqlParameter("@APIKey", SqlDbType.NVarChar, 255),
new SqlParameter("@LeadStar_ID", SqlDbType.NVarChar, 255),
new SqlParameter("@LeadStar_username", SqlDbType.NVarChar, 255),
new SqlParameter("@LeadStar_userid", SqlDbType.NVarChar, 255),
new SqlParameter("@ActiveLoanWorkflow", SqlDbType.Bit),
new SqlParameter("@StartMarketingSync", SqlDbType.Bit),
new SqlParameter("@MyEmailInboxURL", SqlDbType.NVarChar),
new SqlParameter("@MyCalendarURL", SqlDbType.NVarChar),
new SqlParameter("@RatesURL", SqlDbType.NVarChar)
};
parameters[0].Value = model.Name;
parameters[1].Value = model.AD_OU_Filter;
parameters[2].Value = model.Desc;
parameters[3].Value = model.Address;
parameters[4].Value = model.City;
parameters[5].Value = model.State;
parameters[6].Value = model.Zip;
parameters[7].Value = model.ImportUserInterval;
parameters[8].Value = model.ReleaseVersion;
parameters[9].Value = model.Edition;
parameters[10].Value = model.RuleMonitorInterval;
parameters[11].Value = model.GlobalId;
parameters[12].Value = model.EnableMarketing;
parameters[13].Value = model.Phone;
parameters[14].Value = model.Fax;
parameters[15].Value = model.Email;
parameters[16].Value = model.WebURL;
parameters[17].Value = model.IntegrationID;
parameters[18].Value = model.APIKey;
parameters[19].Value = model.LeadStar_ID;
parameters[20].Value = model.LeadStar_username;
parameters[21].Value = model.LeadStar_userid;
parameters[22].Value = model.ActiveLoanWorkflow;
parameters[23].Value = model.StartMarketingSync;
parameters[24].Value = model.MyEmailInboxURL;
parameters[25].Value = model.MyCalendarURL;
parameters[26].Value = model.RatesURL;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public LPWeb.Model.Company_General GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Name,AD_OU_Filter,[Desc],Address,City,State,Zip,ImportUserInterval,ReleaseVersion,Edition,RuleMonitorInterval,GlobalId,EnableMarketing,Phone,Fax,Email,WebURL,IntegrationID,APIKey,LeadStar_ID,LeadStar_username,LeadStar_userid,ActiveLoanWorkflow,StartMarketingSync, MyEmailInboxURL, MyCalendarURL, RatesURL from Company_General ");
//strSql.Append(" where ");
SqlParameter[] parameters =
{
};
LPWeb.Model.Company_General model = new LPWeb.Model.Company_General();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
model.Name = ds.Tables[0].Rows[0]["Name"].ToString();
model.AD_OU_Filter = ds.Tables[0].Rows[0]["AD_OU_Filter"].ToString();
model.Desc = ds.Tables[0].Rows[0]["Desc"].ToString();
model.Address = ds.Tables[0].Rows[0]["Address"].ToString();
model.City = ds.Tables[0].Rows[0]["City"].ToString();
model.State = ds.Tables[0].Rows[0]["State"].ToString();
model.Zip = ds.Tables[0].Rows[0]["Zip"].ToString();
if (ds.Tables[0].Rows[0]["ImportUserInterval"].ToString() != "")
{
model.ImportUserInterval = int.Parse(ds.Tables[0].Rows[0]["ImportUserInterval"].ToString());
}
model.ReleaseVersion = ds.Tables[0].Rows[0]["ReleaseVersion"].ToString();
if (ds.Tables[0].Rows[0]["Edition"].ToString() != "")
{
model.Edition = int.Parse(ds.Tables[0].Rows[0]["Edition"].ToString());
}
model.GlobalId = ds.Tables[0].Rows[0]["GlobalId"].ToString();
if (ds.Tables[0].Rows[0]["RuleMonitorInterval"].ToString() != "")
{
model.RuleMonitorInterval = int.Parse(ds.Tables[0].Rows[0]["RuleMonitorInterval"].ToString());
}
model.EnableMarketing = ds.Tables[0].Rows[0]["EnableMarketing"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["EnableMarketing"]) : true;
model.Phone = ds.Tables[0].Rows[0]["Phone"].ToString();
model.Fax = ds.Tables[0].Rows[0]["Fax"].ToString();
model.Email = ds.Tables[0].Rows[0]["Email"].ToString();
model.WebURL = ds.Tables[0].Rows[0]["WebURL"].ToString();
model.IntegrationID = ds.Tables[0].Rows[0]["IntegrationID"].ToString();
model.APIKey = ds.Tables[0].Rows[0]["APIKey"].ToString();
model.LeadStar_ID = ds.Tables[0].Rows[0]["LeadStar_ID"].ToString();
model.LeadStar_username = ds.Tables[0].Rows[0]["LeadStar_username"].ToString();
model.LeadStar_userid = ds.Tables[0].Rows[0]["LeadStar_userid"].ToString();
model.ActiveLoanWorkflow = ds.Tables[0].Rows[0]["ActiveLoanWorkflow"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["ActiveLoanWorkflow"]) : true;
model.StartMarketingSync = ds.Tables[0].Rows[0]["StartMarketingSync"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["StartMarketingSync"]) : true;
model.MyEmailInboxURL = ds.Tables[0].Rows[0]["MyEmailInboxURL"].ToString();
model.MyCalendarURL = ds.Tables[0].Rows[0]["MyCalendarURL"].ToString();
model.RatesURL = ds.Tables[0].Rows[0]["RatesURL"].ToString();
return(model);
}
else
{
return(null);
}
}
protected void Page_Load(object sender, EventArgs e)
{
LPWeb.Common.LoginUser login = new Common.LoginUser();
if (!login.userRole.CompanySetup || !login.userRole.OtherLoanAccess)
{
hfdUserPre.Value = "0";
}
else
{
hfdUserPre.Value = "1";
}
//LPWeb.BLL.Users bllUser = new LPWeb.BLL.Users();
//LPWeb.BLL.Roles bllRole = new LPWeb.BLL.Roles();
//LPWeb.Model.Roles modelRole = new LPWeb.Model.Roles();
////string sLoginUserId = HttpContext.Current.User.Identity.Name;
//string sLoginUserId = "SPSTESTLO2_2B1";// "SPSTESTReg1Ex";//todo:hard-code
//if (sLoginUserId.IndexOf("\\") >= 0)
//{
// sLoginUserId = sLoginUserId.Substring(sLoginUserId.LastIndexOf("\\") + 1);
//}
//DataTable dtUserInfo = bllUser.GetUserList(" AND Username='******'");
//if (dtUserInfo == null || dtUserInfo.Rows.Count == 0)
//{
// HttpContext.Current.Response.Redirect("../NoPermission.htm");
// return;
//}
//int roleID = Convert.ToInt32(dtUserInfo.Rows[0]["RoleId"].ToString());
//if (roleID != 0)
//{
// modelRole = bllRole.GetModel(roleID);
//}
//if (!modelRole.CompanySetup || !modelRole.OtherLoanAccess)
//{
// hfdUserPre.Value = "0";
//}
//else
//{
// hfdUserPre.Value = "1";
//}
List <Int32> LUserRecentList = login.RecentItems;
foreach (var recentItem in LUserRecentList)
{
var _bUserRecentItems = new BLL.UserRecentItems();
string sBorrowerName = _bUserRecentItems.GetUserRecentItemsBorrowerInfo(Convert.ToInt32(recentItem));
string sLoanStatus = _bUserRecentItems.GetLoanStatusbyFileID(Convert.ToInt32(recentItem));
string sCurrentPageURL = Request.Url.AbsoluteUri;
if (sLoanStatus == "Prospect")
{
if (sCurrentPageURL.IndexOf("FileID=") > -1)
{
sCurrentPageURL = "";
}
if (sBorrowerName.Trim() != string.Empty)
{
sUserRecentItems += "<li class='static'><a class='static menu-item' href='../Prospect/ProspectLoanDetails.aspx?FileID=" + recentItem + "&FileIDs=" + recentItem + "&FromPage=" + sCurrentPageURL + "'>";
sUserRecentItems += "<span class='additional-background'><span class='menu-item-text'>" + sBorrowerName + "</span></span></a></li>";
sHomePageUserRecentItems += "<li class='static'><a class='static menu-item' href='Prospect/ProspectLoanDetails.aspx?FileID=" + recentItem + "&FileIDs=" + recentItem + "&FromPage=" + sCurrentPageURL + "'>";
sHomePageUserRecentItems += "<span class='additional-background'><span class='menu-item-text'>" + sBorrowerName + "</span></span></a></li>";
}
}
else
{
if (sCurrentPageURL.IndexOf("fieldid=") > -1)
{
sCurrentPageURL = "";
}
if (sBorrowerName.Trim() != string.Empty)
{
sUserRecentItems += "<li class='static'><a class='static menu-item' href='../LoanDetails/LoanDetails.aspx?fieldid=" + recentItem + "&fieldids=" + recentItem + "&FromPage=" + sCurrentPageURL + "'>";
sUserRecentItems += "<span class='additional-background'><span class='menu-item-text' >" + sBorrowerName + "</span></span></a></li>";
sHomePageUserRecentItems += "<li class='static'><a class='static menu-item' href='LoanDetails/LoanDetails.aspx?fieldid=" + recentItem + "&fieldids=" + recentItem + "&FromPage=" + sCurrentPageURL + "'>";
sHomePageUserRecentItems += "<span class='additional-background'><span class='menu-item-text' >" + sBorrowerName + "</span></span></a></li>";
}
}
}
if (!IsPostBack)
{
try
{
// set welcome info
BLL.Company_General comGeneral = new BLL.Company_General();
Model.Company_General company = comGeneral.GetModel();
if (null != company)
{
this.literalComName.Text = string.Format("Welcome to the {0} Portal! ", company.Name);
}
}
catch
{ }
}
// 获取Company_General
LPWeb.BLL.Company_General bllCompanyGeneral = new LPWeb.BLL.Company_General();
LPWeb.Model.Company_General modCompanyGeneral = bllCompanyGeneral.GetModel();
this.sMyEmailInboxURL = modCompanyGeneral.MyEmailInboxURL;
this.sMyCalendarURL = modCompanyGeneral.MyCalendarURL;
this.sRatesURL = modCompanyGeneral.RatesURL;
}
