public int Update(DOInfo oParam) { string sql = @"UPDATE DO_master SET DONo=@DONo WHERE SysNo=@SysNo"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramDONo = new SqlParameter("@DONo", SqlDbType.NVarChar, 50); if (oParam.SysNo != AppConst.IntNull) { paramSysNo.Value = oParam.SysNo; } else { paramSysNo.Value = System.DBNull.Value; } if (oParam.DONo != AppConst.StringNull) { paramDONo.Value = oParam.DONo; } else { paramDONo.Value = System.DBNull.Value; } cmd.Parameters.Add(paramSysNo); cmd.Parameters.Add(paramDONo); return(SqlHelper.ExecuteNonQuery(cmd)); }
private void map(DOInfo oInfo, DataRow tempdr) { oInfo.SysNo = Util.TrimIntNull(tempdr["SysNo"]); oInfo.SOSysNo = Util.TrimIntNull(tempdr["SOSysNo"]); oInfo.DONo = Util.TrimNull(tempdr["DONo"]); oInfo.CreateTime = Util.TrimDateNull(tempdr["CreateTime"]); }
public void UpdateDO(DOInfo oInfo) { TransactionOptions options = new TransactionOptions(); options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted; options.Timeout = TransactionManager.DefaultTimeout; using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options)) { new DODac().Update(oInfo); scope.Complete(); } }
public int Insert(DOInfo oParam) { string sql = @"INSERT INTO DO_master ( SOSysNo, DONo ) VALUES ( @SOSysNo, @DONo )"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramSOSysNo = new SqlParameter("@SOSysNo", SqlDbType.Int, 4); SqlParameter paramDONo = new SqlParameter("@DONo", SqlDbType.NVarChar, 50); if (oParam.SysNo != AppConst.IntNull) { paramSysNo.Value = oParam.SysNo; } else { paramSysNo.Value = System.DBNull.Value; } if (oParam.SOSysNo != AppConst.IntNull) { paramSOSysNo.Value = oParam.SOSysNo; } else { paramSOSysNo.Value = System.DBNull.Value; } if (oParam.DONo != AppConst.StringNull) { paramDONo.Value = oParam.DONo; } else { paramDONo.Value = System.DBNull.Value; } cmd.Parameters.Add(paramSysNo); cmd.Parameters.Add(paramSOSysNo); cmd.Parameters.Add(paramDONo); return(SqlHelper.ExecuteNonQuery(cmd)); }
public DOInfo LoadDOBySO(int SOSysNo) { string sql = "select * from do_master where sosysno = @SOSysNo"; sql = sql.Replace("@SOSysNo", SOSysNo.ToString()); DataSet ds = SqlHelper.ExecuteDataSet(sql); if (!Util.HasMoreRow(ds)) { return(null); } DataRow tempdr = ds.Tables[0].Rows[0]; DOInfo oInfo = new DOInfo(); this.map(oInfo, tempdr); return(oInfo); }