private void mapSlnItemC3Attr2Info(SlnItemC3Attr2Info oParam, DataRow tempdr) { oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]); oParam.SlnItemC3SysNo = Util.TrimIntNull(tempdr["SlnItemC3SysNo"]); oParam.C3Attr2SysNo = Util.TrimIntNull(tempdr["C3Attr2SysNo"]); oParam.Status = Util.TrimIntNull(tempdr["Status"]); }
public void UpdateSlnItemC3Attr2(SlnItemC3Attr2Info oParam) { TransactionOptions options = new TransactionOptions(); options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted; options.Timeout = TransactionManager.DefaultTimeout; using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options)) { new SlnDac().Update(oParam); scope.Complete(); } }
public int InsertSlnItemC3Attr2(SlnItemC3Attr2Info oParam) { string sql = "select * from sln_item_c3_attr2 where slnitemc3sysno = " + oParam.SlnItemC3SysNo + " and c3attr2sysno = " + oParam.C3Attr2SysNo; DataSet ds = SqlHelper.ExecuteDataSet(sql); if (Util.HasMoreRow(ds)) { oParam.SysNo = Util.TrimIntNull(ds.Tables[0].Rows[0]["sysno"]); return new SlnDac().Update(oParam); } else { return new SlnDac().Insert(oParam); } }
public SortedList GetSlnItemC2Attr2List(int SlnItemC3SysNo) { string sql = "select * from sln_item_c3_attr2 where slnitemc3sysno=" + SlnItemC3SysNo; DataSet ds = SqlHelper.ExecuteDataSet(sql); if (!Util.HasMoreRow(ds)) return null; SortedList sl = new SortedList(ds.Tables[0].Rows.Count); foreach (DataRow dr in ds.Tables[0].Rows) { SlnItemC3Attr2Info oParam = new SlnItemC3Attr2Info(); mapSlnItemC3Attr2Info(oParam, dr); sl.Add(oParam.C3Attr2SysNo, oParam); } return sl; }
public int Update(SlnItemC3Attr2Info oParam) { string sql = @"UPDATE sln_item_c3_attr2 SET SlnItemC3SysNo=@SlnItemC3SysNo, C3Attr2SysNo=@C3Attr2SysNo, Status=@Status WHERE SysNo=@SysNo"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramSlnItemC3SysNo = new SqlParameter("@SlnItemC3SysNo", SqlDbType.Int, 4); SqlParameter paramC3Attr2SysNo = new SqlParameter("@C3Attr2SysNo", SqlDbType.Int, 4); SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4); if (oParam.SysNo != AppConst.IntNull) paramSysNo.Value = oParam.SysNo; else paramSysNo.Value = System.DBNull.Value; if (oParam.SlnItemC3SysNo != AppConst.IntNull) paramSlnItemC3SysNo.Value = oParam.SlnItemC3SysNo; else paramSlnItemC3SysNo.Value = System.DBNull.Value; if (oParam.C3Attr2SysNo != AppConst.IntNull) paramC3Attr2SysNo.Value = oParam.C3Attr2SysNo; else paramC3Attr2SysNo.Value = System.DBNull.Value; if (oParam.Status != AppConst.IntNull) paramStatus.Value = oParam.Status; else paramStatus.Value = System.DBNull.Value; cmd.Parameters.Add(paramSysNo); cmd.Parameters.Add(paramSlnItemC3SysNo); cmd.Parameters.Add(paramC3Attr2SysNo); cmd.Parameters.Add(paramStatus); return SqlHelper.ExecuteNonQuery(cmd); }
public int Insert(SlnItemC3Attr2Info oParam) { string sql = @"INSERT INTO sln_item_c3_attr2 ( SlnItemC3SysNo, C3Attr2SysNo, Status ) VALUES ( @SlnItemC3SysNo, @C3Attr2SysNo, @Status );set @SysNo = SCOPE_IDENTITY();"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramSlnItemC3SysNo = new SqlParameter("@SlnItemC3SysNo", SqlDbType.Int, 4); SqlParameter paramC3Attr2SysNo = new SqlParameter("@C3Attr2SysNo", SqlDbType.Int, 4); SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4); paramSysNo.Direction = ParameterDirection.Output; if (oParam.SlnItemC3SysNo != AppConst.IntNull) paramSlnItemC3SysNo.Value = oParam.SlnItemC3SysNo; else paramSlnItemC3SysNo.Value = System.DBNull.Value; if (oParam.C3Attr2SysNo != AppConst.IntNull) paramC3Attr2SysNo.Value = oParam.C3Attr2SysNo; else paramC3Attr2SysNo.Value = System.DBNull.Value; if (oParam.Status != AppConst.IntNull) paramStatus.Value = oParam.Status; else paramStatus.Value = System.DBNull.Value; cmd.Parameters.Add(paramSysNo); cmd.Parameters.Add(paramSlnItemC3SysNo); cmd.Parameters.Add(paramC3Attr2SysNo); cmd.Parameters.Add(paramStatus); return SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo); }