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