//# end region 异常原因表格
// #region 新增异常记录
public void AddYcyyItem(ycyy_Service model)
{
using (conn = ConnectionFactory.CreateConnection())
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
string sql = " insert into yw_hddz_ycyy (zbr, zbrq ,ycyybm,ycyymc,beizhu, ycyyqc, ycyyqcsj,ywbh,wxsffs)values(@zbr,CONVERT(VARCHAR(40),@zbrq,20) ,@ycyybm,@ycyymc,@beizhu,@ycyyqc,CONVERT(VARCHAR(40),@ycyyqcsj,20),@ywbh,@wxsffs) ";
conn.Execute(sql, model);
}
}
/// <summary>
// #region 更新异常记录
public void UpdateYcyyItem(ycyy_Service model)
{
using (conn = ConnectionFactory.CreateConnection())
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
string sql = " update yw_hddz_ycyy set zbr=@zbr,ycyybm=@ycyybm,ycyymc=@ycyymc,beizhu=@beizhu, ycyyqc=@ycyyqc,ywbh=@ywbh where id=@id";
conn.Execute(sql, model);
}
}
public void SaveYcyy(HttpContext context)
{
try
{
Interfaces.Service.GetWarningMenuListService GetWarningService = new Interfaces.Service.GetWarningMenuListService();
string id = context.Request.Params["id"];
string json = context.Request.Params["json"];
ycyy_Service model = JsonConvert.DeserializeObject <ycyy_Service>(json);
GetWarningService.AddYcyyItem(model);
res.msg = "新增异常原因记录成功";
res.result = true;
}
catch (Exception ex)
{
res.result = true;
res.msg = ex.Message;
}
}
