public int InsertItem(SRItemInfo oParam)
{
string sql = @"INSERT INTO SR_Item
(
SRSysNo, ProductSysNo, Quantity
)
VALUES (
@SRSysNo, @ProductSysNo, @Quantity
);set @SysNo = SCOPE_IDENTITY();";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramSRSysNo = new SqlParameter("@SRSysNo", SqlDbType.Int, 4);
SqlParameter paramProductSysNo = new SqlParameter("@ProductSysNo", SqlDbType.Int, 4);
SqlParameter paramQuantity = new SqlParameter("@Quantity", SqlDbType.Int, 4);
paramSysNo.Direction = ParameterDirection.Output;
if (oParam.SRSysNo != AppConst.IntNull)
paramSRSysNo.Value = oParam.SRSysNo;
else
paramSRSysNo.Value = System.DBNull.Value;
if (oParam.ProductSysNo != AppConst.IntNull)
paramProductSysNo.Value = oParam.ProductSysNo;
else
paramProductSysNo.Value = System.DBNull.Value;
if (oParam.Quantity != AppConst.IntNull)
paramQuantity.Value = oParam.Quantity;
else
paramQuantity.Value = System.DBNull.Value;
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramSRSysNo);
cmd.Parameters.Add(paramProductSysNo);
cmd.Parameters.Add(paramQuantity);
return SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo);
}
public int UpdateItem(SRItemInfo oParam)
{
string sql = @"UPDATE SR_Item SET
SRSysNo=@SRSysNo, ProductSysNo=@ProductSysNo,
Quantity=@Quantity
WHERE SysNo=@SysNo";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramSRSysNo = new SqlParameter("@SRSysNo", SqlDbType.Int, 4);
SqlParameter paramProductSysNo = new SqlParameter("@ProductSysNo", SqlDbType.Int, 4);
SqlParameter paramQuantity = new SqlParameter("@Quantity", SqlDbType.Int, 4);
if (oParam.SysNo != AppConst.IntNull)
paramSysNo.Value = oParam.SysNo;
else
paramSysNo.Value = System.DBNull.Value;
if (oParam.SRSysNo != AppConst.IntNull)
paramSRSysNo.Value = oParam.SRSysNo;
else
paramSRSysNo.Value = System.DBNull.Value;
if (oParam.ProductSysNo != AppConst.IntNull)
paramProductSysNo.Value = oParam.ProductSysNo;
else
paramProductSysNo.Value = System.DBNull.Value;
if (oParam.Quantity != AppConst.IntNull)
paramQuantity.Value = oParam.Quantity;
else
paramQuantity.Value = System.DBNull.Value;
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramSRSysNo);
cmd.Parameters.Add(paramProductSysNo);
cmd.Parameters.Add(paramQuantity);
return SqlHelper.ExecuteNonQuery(cmd);
}
private void map(SRItemInfo oParam, DataRow tempdr)
{
oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]);
oParam.SRSysNo = Util.TrimIntNull(tempdr["SRSysNo"]);
oParam.ProductSysNo = Util.TrimIntNull(tempdr["ProductSysNo"]);
oParam.Quantity = Util.TrimIntNull(tempdr["Quantity"]);
}
private void InsertSRItem(SRItemInfo oParam, SRInfo srInfo)
{
TransactionOptions options = new TransactionOptions();
options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
options.Timeout = TransactionManager.DefaultTimeout;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
{
new SRDac().InsertItem(oParam);
scope.Complete();
}
}
public void UpdateSRItem(SRItemInfo oParam)
{
new SRDac().UpdateItem(oParam);
}
public SRInfo Load(int sysno)
{
try
{
SRInfo oInfo = new SRInfo();
string sql = "select * from SR_Master (NOLOCK) where sysno=" + sysno;
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if (Util.HasMoreRow(ds))
{
DataRow dr = ds.Tables[0].Rows[0];
map(oInfo, dr);
string itemSql = @"select SR_Item.*
from SR_Master (NOLOCK)
inner join SR_Item (NOLOCK) on SR_Item.SRSysNo = SR_Master.SysNo
where SR_Master.sysno=" + sysno;
DataSet itemds = SqlHelper.ExecuteDataSet(itemSql);
if (Util.HasMoreRow(itemds))
{
foreach (DataRow itemdr in itemds.Tables[0].Rows)
{
SRItemInfo oSRItem = new SRItemInfo();
map(oSRItem, itemdr);
oInfo.ItemHash.Add(Util.TrimIntNull(itemdr["SysNo"]), oSRItem);
}
}
}
return oInfo;
}
catch
{
throw new BizException("Load SRInfo Error!");
}
}
