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