public bool Save(ZzdInfo zi)
{
if (zi.Id > 0)
{
return(Update(zi));
}
var sql = string.Format(@"select EnterpriseId from SysUser where UserName='******'", zi.UserName.Trim());
var ent = DBHelper.GetScalar(sql) as int?;
if (ent == null)
{
return(false);
}
sql = @"
insert into ZZDFlow(EnterpriseId,BankId,MastBankId,Manager,ManagerPhone,OriginalQuota,ThisQuota,ExpirationDate,[Status],PublishDate)
values(@ent,@bk,@mbk,@ma,@map,@oq,@q,@ed,0,@date)";
var efc = DBHelper.Execute(sql, new SqlParameter("@eid", ent),
new SqlParameter("@ent", ent),
new SqlParameter("@bk", zi.ydkyh),
new SqlParameter("@mbk", zi.zbh),
new SqlParameter("@ma", zi.khjlxm),
new SqlParameter("@map", zi.khjllxdh),
new SqlParameter("@oq", zi.ydkje),
new SqlParameter("@q", zi.bcdkje),
new SqlParameter("@ed", zi.dkdqsj),
new SqlParameter("@date", DateTime.Now));
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.Id in({0})", zi.ydkyh);
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 Update(ZzdInfo zi)
{
var sql = string.Format(@"select EnterpriseId from SysUser where UserName='******'", zi.UserName.Trim());
var ent = DBHelper.GetScalar(sql) as int?;
if (ent == null)
{
return(false);
}
sql = @"
update ZZDFlow set BankId=@bk,MastBankId=@mbk,Manager=@ma,ManagerPhone=@map,OriginalQuota=@oq,ThisQuota=@q,ExpirationDate=@ed where Id=@zzdid";
var efc = DBHelper.Execute(sql,
new SqlParameter("@zzdid", zi.Id),
new SqlParameter("@bk", zi.ydkyh),
new SqlParameter("@mbk", zi.zbh),
new SqlParameter("@ma", zi.khjlxm),
new SqlParameter("@map", zi.khjllxdh),
new SqlParameter("@oq", zi.ydkje),
new SqlParameter("@q", zi.bcdkje),
new SqlParameter("@ed", zi.dkdqsj));
return(efc > 0);
}
public bool Save(ZzdInfo zi)
{
return(_zs.Save(zi));
}
