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