public bool UpdateRzInfo(RzInfo rzi)
{
bool isDyw = false;
if (rzi.dywdesc.Trim() != "" && rzi.dywdesc != null)
{
isDyw = true;
}
var sql = string.Format(@"select EnterpriseId from SysUser where UserName='******'", rzi.UserName.Trim());
var ent = DBHelper.GetScalar(sql) as int?;
if (ent == null)
{
return(false);
}
sql = @"
update RZDemandInfo set Quota=@qua,TermId=@tem,PurposeId=@pup,HadCollateral=@hc,CollateralDesc=@cd where Id in (select DemandId from RZFlow where Id = @rzid)";
DBHelper.Execute(sql,
new SqlParameter("@qua", rzi.RZED),
new SqlParameter("@tem", rzi.RZQX),
new SqlParameter("@pup", rzi.RZQT),
new SqlParameter("@hc", isDyw),
new SqlParameter("@rzid", rzi.Id),
new SqlParameter("@cd", rzi.dywdesc.Trim()));
sql = @"update RZFlow set BankIds=@bks where Id=@rzid";
var efc = DBHelper.Execute(sql,
new SqlParameter("@bks", rzi.RZYH),
new SqlParameter("@rzid", rzi.Id));
return(efc > 0);
}
private void UpdateRzInfo()
{
lock (this)
{
computedOnce = new RzInfo();
computedOnce.Update(this);
}
}
private void UpdateRzInfo()
{
lock (this)
{
computedOnce = new RzInfo();
computedOnce.Update(this);
}
}
public bool SaveRzInfo(RzInfo rzi)
{
if (rzi.Id > 0)
{
return(UpdateRzInfo(rzi));
}
bool isDyw = false;
if (rzi.dywdesc.Trim() != "" && rzi.dywdesc != null)
{
isDyw = true;
}
var sql = string.Format(@"select EnterpriseId from SysUser where UserName='******'", rzi.UserName.Trim());
var ent = DBHelper.GetScalar(sql) as int?;
if (ent == null)
{
return(false);
}
sql = @"
insert into RZDemandInfo (Quota,TermId,PurposeId,HadCollateral,CollateralDesc)
values(@qua,@tem,@pup,@hc,@cd)
SELECT @@IDENTITY";
var demid = DBHelper.GetScalar(sql,
new SqlParameter("@qua", rzi.RZED),
new SqlParameter("@tem", rzi.RZQX),
new SqlParameter("@pup", rzi.RZQT),
new SqlParameter("@hc", isDyw),
new SqlParameter("@cd", rzi.dywdesc.Trim()));
if (demid == null)
{
return(false);
}
sql = @"
insert into RZFlow(EnterpriseId,BankIds,FinanceId,DemandId,[Status])
values(@ent,@bks,(select top 1 Id from RZFinance where EnterpriseId=@ent),@dm,0)";
var efc = DBHelper.Execute(sql,
new SqlParameter("@ent", ent),
new SqlParameter("@bks", rzi.RZYH),
new SqlParameter("@dm", demid));
if (efc > 0)
{
List <string> phonelist = new List <string>();
sql = "select Phone from SysUser where RolesID = 2";
DataTable dt = DBHelper.GetDataSet(sql);
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
string Phone = dr[0].ToString();
phonelist.Add(Phone);
}
}
sql = string.Format(@"select Phone from Bank a right join LiaisonanMan b on a.Id = b.BankId where 1=1 and b.IsDeleteed = 0 and a.ParentBankId in({0})", rzi.RZYH);
DataTable yhdt = DBHelper.GetDataSet(sql);
if (yhdt.Rows.Count > 0)
{
foreach (DataRow yhdr in yhdt.Rows)
{
string Phone = yhdr[0].ToString();
phonelist.Add(Phone);
}
}
SmsService sms = new SmsService();
for (int h = 0; h < phonelist.Count; h++)
{
sms.Send(phonelist[h].ToString(), "有新的融资申请，请及时登陆镇江融资平台查看详细信息");
}
}
return(efc > 0);
}
public bool SaveRzInfo(RzInfo rzi)
{
return(_prs.SaveRzInfo(rzi));
}
