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