public Tz888.Model.LoansInfo GetLoansInfoByLoansInfoId(int LoansInfoId)
{
string sql = "select * from loansInfo where loansInfoID=@LoansInfoId";
DataSet set = DbHelperSQL.Query(sql, new SqlParameter("LoansInfoId", LoansInfoId));
LoansInfo loansinfo = null;
try
{
foreach (DataRow row in set.Tables[0].Rows)
{
Tz888.SQLServerDAL.loansInfoTab loantabl = new loansInfoTab();
loansinfo = new LoansInfo();
loansinfo.LoanID = Convert.ToInt32(row["LoanID"]);
loansinfo.LoansInfoID = loantabl.GetLoansInfoTabByLoansInfoId(Convert.ToInt32(row["LoansInfoID"]));
loansinfo.ValidityID = Convert.ToInt32(row["ValidityID"].ToString());
loansinfo.CountryID = row["CountryID"].ToString();
loansinfo.ProvinceID = row["ProvinceID"].ToString();
loansinfo.CityID = row["CityID"].ToString();
loansinfo.CountyID = row["CountyID"].ToString();
loansinfo.Amount = Convert.ToInt32(row["Amount"]);
loansinfo.Deadline = Convert.ToInt32(row["Deadline"]);
loansinfo.Reimbursement = Convert.ToInt32(row["Reimbursement"]);
loansinfo.Guarantee = Convert.ToInt32(row["Guarantee"]);
loansinfo.BorrowingUse = row["BorrowingUse"].ToString();
loansinfo.Title = row["Title"].ToString();
loansinfo.Keywords = row["Keywords"].ToString();
loansinfo.Description = row["Description"].ToString();
loansinfo.Reason = row["Reason"].ToString();
}
}
catch (Exception)
{
}
return(loansinfo);
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
Tz888.Model.LoansInfoTab loansInfotab = new LoansInfoTab();
Tz888.Model.LoansInfo loansinfo = new LoansInfo();
Tz888.Model.LoanscontactsTab loanscontactstab = new LoanscontactsTab();
//贷款主表的修改
loansInfotab.LoansInfoID = loansInfoID;
loansInfotab.LoansTitle = txtCapitalTitle.Text.Trim();
loansInfotab.Updatetime = DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToLongTimeString().Trim();
if (txtCapitalTitle.Text.Trim() == "")
{
this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('请输入标题！');", true);
return;
}
else
{
resultrow1 = loansInfoTabbll.UpdateLoansInfoTab(loansInfotab);
}
if (txtCapitalMoney.Text.Trim() == "")
{
this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('请输入贷款金额！');", true);
return;
}
else if (Convert.ToInt32(txtCapitalMoney.Text.Trim().Length) > 9)
{
this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('请输入小于10亿的金额！');", true);
return;
}
else if (txtCapitalIntent.Value.Trim() == "")
{
this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('请输入贷款原因！');", true);
return;
}
else
{
//贷款详细表的修改
loansinfo.CountryID = this.ZoneSelectControl1.CountryID;
loansinfo.ProvinceID = this.ZoneSelectControl1.ProvinceID;
loansinfo.CityID = this.ZoneSelectControl1.CityID;
loansinfo.CountyID = this.ZoneSelectControl1.CountyID;
loansinfo.Deadline = Convert.ToInt32(rdlValiditeTerm.SelectedValue.Trim());
loansinfo.Reimbursement = 0;
loansinfo.Guarantee = Convert.ToInt32(this.radiodanbao.SelectedValue.Trim());
loansinfo.BorrowingUse = txtCapitalIntent.Value.Trim();
loansinfo.ValidityID = Convert.ToInt32(rdlValiditeSystem.SelectedValue.Trim());
loansinfo.Amount = Convert.ToInt32(txtCapitalMoney.Text.Trim());
resultrow2 = loansinfobll.UpdateLoansInfoTab(loansinfo, loansInfoID);
}
//联系方式
loanscontactstab.EnterpriseName = txtenpricename.Text.Trim();
loanscontactstab.ContactsName = txtcontactsName.Text.Trim();
loanscontactstab.Telephone = txtcontactsTel.Text.Trim() + "-" + txttel1.Text.Trim() + "-" + txttel2.Text.Trim();
loanscontactstab.Moblie = txtcontactsphone.Text.Trim();
loanscontactstab.Mail = txtcontactsemail.Text.Trim();
loanscontactstab.Address = this.txtcontactsaddress.Text.Trim();
if (txtenpricename.Text.Trim() == "")
{
this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('请输入公司名称！');", true);
return;
}
else if (txtcontactsName.Text.Trim() == "")
{
this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('请输入联系人！');", true);
return;
}
else if (txtcontactsTel.Text.Trim() == "" && txtcontactsphone.Text.Trim() == "")
{
this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('至少输入一个联系电话！');", true);
return;
}
else if (txttel1.Text.Trim() == "" && txtcontactsphone.Text.Trim() == "")
{
this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('至少输入一个联系电话！');", true);
return;
}
else if (txttel2.Text.Trim() == "" && txtcontactsphone.Text.Trim() == "")
{
this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('至少输入一个联系电话！');", true);
return;
}
else if (txtcontactsemail.Text.Trim() == "")
{
this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('请输入邮箱！');", true);
return;
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "提示f：", "s();", true);
resultrow3 = loanscontacttabbll.UpdateloanscontactsTab(loanscontactstab, loansInfoID);
}
if (resultrow2 > 0 && resultrow2 > 0 && resultrow2 > 0)
{
this.ClientScript.RegisterStartupScript(this.GetType(), "", "location.href='LoansManager.aspx'", true);
}
else
{
this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('修改失败！');", true);
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
Tz888.Model.LoansInfoTab loansInfotab = new LoansInfoTab();
Tz888.Model.LoansInfo loansinfo = new LoansInfo();
Tz888.Model.LoanscontactsTab loanscontactstab = new LoanscontactsTab();
//贷款主表的修改
loansInfotab.LoansInfoID = loansInfoID;
loansInfotab.LoansTitle = txtCapitalTitle.Text.Trim();
loansInfotab.Updatetime = DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToLongTimeString().Trim();
if (shen.Checked == true)
{
loansInfotab.AuditID = 0;
loansInfotab.Url = "";
}
if (shens.Checked == true)
{
loansInfotab.AuditID = 1;
string urladdress = loansInfoTabbll.GetLoansInfoTabByLoansInfoId(loansInfoID).Url.Trim();
if (urladdress == "")
{
loansInfotab.Url = "loans/" + DateTime.Now.ToString("yyyyMM") + "/loans" + DateTime.Now.ToString("yyyyMMdd") + "_" + loansInfoID + ".shtml";
}
else
{
loansInfotab.Url = urladdress;
}
}
if (shensss.Checked == true)
{
loansInfotab.AuditID = 3;
loansInfotab.Url = "";
}
if (shenssss.Checked == true)
{
loansInfotab.AuditID = 5;
loansInfotab.Url = "";
}
loansInfotab.RecommendID = Convert.ToInt32(radiotuijian.SelectedValue.ToString().Trim());
int reulstrow1 = loansInfoTabbll.ShenHeLoansInfoTab(loansInfotab);
//贷款详细表的修改
loansinfo.CountryID = this.ZoneSelectControl1.CountryID;
loansinfo.ProvinceID = this.ZoneSelectControl1.ProvinceID;
loansinfo.CityID = this.ZoneSelectControl1.CityID;
loansinfo.CountyID = this.ZoneSelectControl1.CountyID;
if (txtCapitalMoney.Text.Trim() == "" || txtCapitalMoney.Text.Trim() == null)
{
loansinfo.Amount = 0;
}
else
{
loansinfo.Amount = Convert.ToInt32(txtCapitalMoney.Text.Trim());
}
loansinfo.Deadline = Convert.ToInt32(rdlValiditeTerm.SelectedValue.Trim());
loansinfo.Reimbursement = 0;
loansinfo.Guarantee = Convert.ToInt32(this.radiodanbao.SelectedValue.Trim());
loansinfo.BorrowingUse = txtCapitalIntent.Value.Trim();
loansinfo.ValidityID = Convert.ToInt32(rdlValiditeSystem.SelectedValue.Trim());
loansinfo.Title = txttitle.Text.Trim();
loansinfo.Keywords = txtkeywords.Text.Trim();
loansinfo.Description = txtdescript.Text.Trim();
loansinfo.Reason = txtreson.Text.Trim();
int resultrow2 = loansinfobll.ShenHeloansInfo(loansinfo, loansInfoID);
loanscontactstab.EnterpriseName = txtenpricename.Text.Trim();
loanscontactstab.ContactsName = txtcontactsName.Text.Trim();
loanscontactstab.Telephone = txtcontactsTel.Text.Trim() + "-" + txttel1.Text.Trim() + "-" + txttel2.Text.Trim();
loanscontactstab.Moblie = txtcontactsphone.Text.Trim();
loanscontactstab.Mail = txtcontactsemail.Text.Trim();
loanscontactstab.Address = this.txtcontactsaddress.Text.Trim();
int resultrow3 = loanscontacttabbll.UpdateloanscontactsTab(loanscontactstab, loansInfoID);
if (resultrow3 != 0 && reulstrow1 != 0 && resultrow2 != 0)
{
if (loansInfotab.AuditID == 1)
{
Tz888.BLL.Loans.PageStaticenprice stat = new Tz888.BLL.Loans.PageStaticenprice();
stat.StaticHtml(loansInfoID);
BindShow();
}
}
else
{
this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('审核失败！');", true);;
}
this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('审核成功！');location.href='LoansInfoCRM.aspx'", true);
}
string CasesTem = ConfigurationManager.AppSettings["DKMerchantTem"].ToString(); //其他成功案例模版存放位置
#region 创建招商静态页面
/// <summary>
///创建贷款静态页面
/// </summary>
public int StaticHtml(int loansInfoID)
{
Tz888.BLL.loansInfoTab loansinfotabbll = new loansInfoTab();
Tz888.BLL.LoansInfo loansinfobll = new LoansInfo();
Tz888.BLL.loanscontactsTab loanscontactstabbll = new loanscontactsTab();
Tz888.Model.LoansInfoTab loansinfotab = loansinfotabbll.GetLoansInfoTabByLoansInfoId(loansInfoID);
Tz888.Model.LoansInfo loansinfo = loansinfobll.GetLoansInfoByLoansInfoId(loansInfoID);
Tz888.Model.LoanscontactsTab loanscontactstab = loanscontactstabbll.GetLoanscontactsTabByLoansInfoId(loansInfoID);
try
{
string proviceID = loansinfo.ProvinceID.ToString().Trim();
string TempFileName = CasesTem.ToString();
string Tem = Compage.Reader(TempFileName); //读取模板内容
#region 替换模版
string TempSoure = Tem;
TempSoure = TempSoure.Replace("$title$", loansinfotab.LoansTitle.ToString().Trim());
string ProvinceID = loansinfo.ProvinceID.ToString().Trim();
string provincename = loansinfobll.GetProvinceNameByProvinceId(ProvinceID).Trim();
if (provincename.Trim() == "")
{
provincename = "中国";
}
string deadlineriqi = "";
if (loansinfo.Deadline == 3)
{
deadlineriqi = "3个月";
}
if (loansinfo.Deadline == 6)
{
deadlineriqi = "半年";
}
if (loansinfo.Deadline == 12)
{
deadlineriqi = "1年";
}
if (loansinfo.Deadline == 24)
{
deadlineriqi = "2年";
}
if (loansinfo.Deadline == 36)
{
deadlineriqi = "3年";
}
if (loansinfo.Deadline == 60)
{
deadlineriqi = "5年";
}
string systime = "";
if (loansinfo.ValidityID == 3)
{
systime = "3个月";
}
if (loansinfo.ValidityID == 6)
{
systime = "半年";
}
if (loansinfo.ValidityID == 12)
{
systime = "1年";
}
if (loansinfo.ValidityID == 24)
{
systime = "2年";
}
if (loansinfo.ValidityID == 36)
{
systime = "3年";
}
if (loansinfo.ValidityID == 60)
{
systime = "5年";
}
string danbao = "";
if (loansinfo.Guarantee == 0)
{
danbao = "担保";
}
if (loansinfo.Guarantee == 1)
{
danbao = "抵押";
}
if (loansinfo.Guarantee == 2)
{
danbao = "信用";
}
string titlesystemname = sethtml();
string hai = "";
if (loansinfo.Reimbursement == 0)
{
hai = "月";
}
if (loansinfo.Reimbursement == 1)
{
hai = "季";
}
if (loansinfo.Reimbursement == 2)
{
hai = "年";
}
string xiangxi = sethtmls(loansinfo.ProvinceID.ToString().Trim());
TempSoure = TempSoure.Replace("$infoID$", loansInfoID.ToString().Trim());
TempSoure = TempSoure.Replace("$loansTitle$", loansinfotab.LoansTitle.ToString().Trim());
TempSoure = TempSoure.Replace("$Are$", provincename);
TempSoure = TempSoure.Replace("$money$", loansinfo.Amount.ToString().Trim());
TempSoure = TempSoure.Replace("$borrowmoneyqixian$", deadlineriqi.ToString().Trim());
TempSoure = TempSoure.Replace("$danbaotype$", danbao.ToString().Trim());
TempSoure = TempSoure.Replace("$publishdate$", loansinfotab.Loansdate.ToString().Trim().Substring(0, 9));
TempSoure = TempSoure.Replace("$systime$", systime.ToString().Trim());
TempSoure = TempSoure.Replace("$Content$", loansinfo.BorrowingUse.ToString().Trim());
TempSoure = TempSoure.Replace("$Titlesytem$", titlesystemname.ToString().Trim());
TempSoure = TempSoure.Replace("$DisplayTitle$", loansinfo.Title.ToString().Trim());
TempSoure = TempSoure.Replace("$KeyWord$", loansinfo.Keywords.ToString().Trim());
TempSoure = TempSoure.Replace("$description$", loansinfo.Description.ToString().Trim());
TempSoure = TempSoure.Replace("$haifangshi$", hai.ToString().Trim());
TempSoure = TempSoure.Replace("$XianXi$", xiangxi);
#endregion
#region
string inPathTo = "/loans";
string htmlFile = loansinfotab.Url.ToString().Trim();
string[] html = htmlFile.Split('/');
string[] nn = html[2].Split('_');
string cc = nn[0].Substring(nn[0].Length - 8);
string wenjian = MerchantTmpPathTo + html[1].Replace("loans", "");
if (Directory.Exists(wenjian) == false)
{
Directory.CreateDirectory(wenjian);
}
string htmlpaths = wenjian + inPathTo + cc + "_" + loansInfoID + ".shtml";
Compage.Writer(htmlpaths, TempSoure);
return(1);
}
catch (Exception e)
{
return(0);
}
#endregion
}
