public Tz888.Model.LoansInfoTab GetLoansInfoTabByLoansInfoId(int LoansInfoId)
{
string sql = "select * from loansInfoTab where loansInfoID=@LoansInfoId";
SqlDataReader reader = DbHelperSQL.ExecuteReader(sql, new SqlParameter("@LoansInfoId", LoansInfoId));
LoansInfoTab loansinfo = null;
try
{
if (reader.Read())
{
loansinfo = new LoansInfoTab();
loansinfo.LoansInfoID = Convert.ToInt32(reader["loansInfoID"]);
loansinfo.LoginName = reader["LoginName"].ToString();
loansinfo.LoansTitle = reader["LoansTitle"].ToString();
loansinfo.BorrowingType = Convert.ToInt32(reader["BorrowingType"]);
loansinfo.AuditID = Convert.ToInt32(reader["auditID"]);
loansinfo.ChargeID = Convert.ToInt32(reader["chargeID"]);
loansinfo.RecommendID = Convert.ToInt32(reader["recommendID"]);
loansinfo.Url = reader["URL"].ToString();
loansinfo.Loansdate = reader["loansdate"].ToString();
}
reader.Close();
}
catch (Exception)
{
throw;
}
finally { reader.Close(); }
return(loansinfo);
}
//查询记录通过登录名
public List <Tz888.Model.LoansInfoTab> GetAllInfoTabByLoginName(string name)
{
string sql = "select * from loansInfoTab where LoginName=@LoginName";
List <Tz888.Model.LoansInfoTab> list = new List <LoansInfoTab>();
DataSet set = null;
set = DbHelperSQL.Query(sql, new SqlParameter("@LoginName", name));
foreach (DataRow row in set.Tables[0].Rows)
{
LoansInfoTab loansinfo = new LoansInfoTab();
loansinfo.LoansInfoID = Convert.ToInt32(row["loansInfoID"]);
loansinfo.LoginName = row["LoginName"].ToString();
loansinfo.LoansTitle = row["LoansTitle"].ToString();
loansinfo.BorrowingType = Convert.ToInt32(row["BorrowingType"]);
loansinfo.AuditID = Convert.ToInt32(row["auditID"]);
loansinfo.ChargeID = Convert.ToInt32(row["chargeID"]);
loansinfo.RecommendID = Convert.ToInt32(row["recommendID"]);
loansinfo.Url = row["URL"].ToString();
loansinfo.Loansdate = row["loansdate"].ToString();
list.Add(loansinfo);
}
return(list);
}
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);
}
