public bool SaveJRCPInfo(JRCPInfo ji)
{
var sql = string.Format(@"select BankId from SysUser where UserName='******'", ji.UserName);
var bank = DBHelper.GetScalar(sql) as int?;
if (bank == null)
{
return(false);
}
sql = @"
insert into JRCPFlow(BankId,Title,QxLow,QxUp,DanbaoId,DaikunLow,DaikuanUp,LilvLow,LilvUp
,Dianhua,Jianjie,Tedian,Kehu,Tiaojian,Cailiao,Logo,PublishDate,Status)
values(@BankId,@Title,@QxLow,@QxUp,@DanbaoId,@DaikunLow,@DaikuanUp,@LilvLow,@LilvUp
,@Dianhua,@Jianjie,@Tedian,@Kehu,@Tiaojian,@Cailiao,@Logo,@PublishDate,0)";
var efc = DBHelper.Execute(sql,
new SqlParameter("@BankId", bank),
new SqlParameter("@Title", ji.jrname),
new SqlParameter("@QxLow", ji.dkqxstart),
new SqlParameter("@QxUp", ji.dkqxend),
new SqlParameter("@DanbaoId", ji.jrdanbao),
new SqlParameter("@DaikunLow", ji.dkedstart),
new SqlParameter("@DaikuanUp", ji.dkedend),
new SqlParameter("@LilvLow", ji.llfwstart),
new SqlParameter("@LilvUp", ji.llfwend),
new SqlParameter("@Dianhua", ji.jrlxdh),
new SqlParameter("@Jianjie", ji.jrcpjj),
new SqlParameter("@Tedian", ji.jrcptd),
new SqlParameter("@Kehu", ji.jrsykh),
new SqlParameter("@Tiaojian", ji.jrsqtj),
new SqlParameter("@Cailiao", ji.jrcailiao),
new SqlParameter("@Logo", ji.logo ?? new byte[0]),
new SqlParameter("@PublishDate", DateTime.Now));
return(efc > 0);
}
public void TestSaveJRCP()
{
PublishJRCPService ser = new PublishJRCPService();
JRCPInfo ji = new JRCPInfo
{
UserName = "******",
jrname = "testname",
dkqxstart = 1,
dkqxend = 2,
jrdanbao = 10,
dkedstart = 1.52,
dkedend = 2.5,
llfwstart = 1,
llfwend = 1.01,
jrlxdh = "18261952313",
jrcpjj = "简介",
jrcptd = "特点",
jrsykh = "客户",
jrsqtj = "条件",
jrcailiao = "材料"
};
ser.SaveJRCPInfo(ji);
}
public bool SaveJRCPInfo(JRCPInfo ji)
{
return(_js.SaveJRCPInfo(ji));
}
