private void CreateLog(string sConn, string cSoCode, string DisCode, string RdCode, string Status, string Remark) { try { SqlConnection conn = new SqlConnection(sConn); conn.Open(); //启用事务 SqlTransaction tran = conn.BeginTransaction(); string sSQL = ""; try { Model._CreateDisInfo mod = new DllForService.Model._CreateDisInfo(); mod.cSOCode = cSoCode; mod.DisCode = DisCode; mod.RdCode = RdCode; mod.Status = Status; mod.CreateDate = DateTime.Now; mod.Remark = Remark; DAL._CreateDisInfo dal = new DllForService.DAL._CreateDisInfo(); sSQL = dal.Exists(mod.cSOCode); bool b = BaseFunction.ReturnBool(DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0].Rows[0][0]); if (b) { sSQL = dal.Update(mod); DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); } else { sSQL = dal.Add(mod); DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); } Model._CreateDisInfo_Log mod_log = new DllForService.Model._CreateDisInfo_Log(); mod_log.cSOCode = cSoCode; mod_log.DisCode = DisCode; mod_log.RdCode = RdCode; mod_log.Status = Status; mod_log.CreateDate = DateTime.Now; mod_log.Remark = Remark; DAL._CreateDisInfo_Log dal_log = new DllForService.DAL._CreateDisInfo_Log(); sSQL = dal_log.Add(mod_log); DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); tran.Commit(); } catch (Exception ee) { tran.Rollback(); } } catch (Exception ee) { } }
/// <summary> /// 增加一条数据 /// </summary> public string Add(DllForService.Model._CreateDisInfo_Log model) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); if (model.cSOCode != null) { strSql1.Append("cSOCode,"); strSql2.Append("'" + model.cSOCode + "',"); } if (model.DisCode != null) { strSql1.Append("DisCode,"); strSql2.Append("'" + model.DisCode + "',"); } if (model.RdCode != null) { strSql1.Append("RdCode,"); strSql2.Append("'" + model.RdCode + "',"); } if (model.CreateDate != null) { strSql1.Append("CreateDate,"); strSql2.Append("'" + model.CreateDate + "',"); } if (model.Status != null) { strSql1.Append("Status,"); strSql2.Append("'" + model.Status + "',"); } if (model.Remark != null) { strSql1.Append("Remark,"); strSql2.Append("'" + model.Remark + "',"); } strSql.Append("insert into _CreateDisInfo_Log("); strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1)); strSql.Append(")"); strSql.Append(" values ("); strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1)); strSql.Append(")"); strSql.Append(";select @@IDENTITY"); return(strSql.ToString()); }