public void insertErrLog(s_log_fence model)
{
using (conn = ConnectionFactory.CreateConnection())
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
string sql = SqlFactory.GetInsertSql(model);
conn.Execute(sql, model);
s_task_exception task = conn.Query <s_task_exception>(" select * from s_task_exception where rwbh=@rwbh and type=@type", model).FirstOrDefault();
if (task == null)//新增
{
string sql1 = SqlFactory.GetInsertSql(model, "s_task_exception");
conn.Execute(sql1, model);
}
else
{
task.des = model.des;
task.dz_xx = model.dz_xx;
task.fw = model.fw;
task.cjsj = model.cjsj;
task.state = model.state;
task.wd = model.wd;
task.jd = model.jd;
task.wlxh = model.wlxh;
task.status = 0;
string sql1 = SqlFactory.GetUpdateSql(task, "s_task_exception", "id");
conn.Execute(sql1, task);
}
}
}
/// <summary>
///
/// </summary>
public bool UpdateBdsbwh(List <yw_hddz_bdsbwhEntity> list)
{
using (conn = ConnectionFactory.CreateConnection())
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
string sql = SqlFactory.GetUpdateSql(new yw_hddz_bdsbwhEntity(), "yw_hddz_bdsbwh", "bdyssbh");
return(conn.Execute(sql, list) != 0);
}
}
/// <summary>
/// 更新失败操作记录
/// </summary>
/// <returns></returns>
public static void UpdateErrLog(s_log_errEntity model)
{
using (var con = ConnectionFactory.CreateConnection())
{
if (con.State == System.Data.ConnectionState.Closed)
{
con.Open();
}
string sql = SqlFactory.GetUpdateSql(model, "s_log_err", "eid");
con.Execute(sql, model);
}
}
