public Tz888.Model.LoanscontactsTab GetLoanscontactsTabByLoansInfoId(int LoansInfoId)
{
string sql = "select * from loanscontactsTab where loansInfoID=@loansinfoid";
DataSet set = DbHelperSQL.Query(sql, new SqlParameter("@LoansInfoId", LoansInfoId));
LoanscontactsTab loansinfo = null;
try
{
foreach (DataRow row in set.Tables[0].Rows)
{
Tz888.SQLServerDAL.loansInfoTab loantabl = new loansInfoTab();
loansinfo = new LoanscontactsTab();
loansinfo.ContactsID = Convert.ToInt32(row["ContactsID"]);
loansinfo.LoansInfoID = loantabl.GetLoansInfoTabByLoansInfoId(Convert.ToInt32(row["LoansInfoID"]));
loansinfo.EnterpriseName = row["EnterpriseName"].ToString();
loansinfo.ContactsName = row["ContactsName"].ToString();
loansinfo.Telephone = row["Telephone"].ToString();
loansinfo.Moblie = row["Moblie"].ToString();
loansinfo.Mail = row["Mail"].ToString();
loansinfo.Address = row["Address"].ToString();
loansinfo.Loginname = row["Loginname"].ToString();
}
}
catch (Exception)
{
throw;
}
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);
}
