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); }