public int Insert(ProductPriceMarketInfo oParam)
{
string sql = @"INSERT INTO Product_Price_Market
(
ProductSysNo, MarketLowestPrice, MarketUrl, CreateMemo,
CreateUserSysNo, CreateTime, AuditMemo, AuditUserSysNo,
AuditTime, Status
)
VALUES (
@ProductSysNo, @MarketLowestPrice, @MarketUrl, @CreateMemo,
@CreateUserSysNo, @CreateTime, @AuditMemo, @AuditUserSysNo,
@AuditTime, @Status
);set @SysNo = SCOPE_IDENTITY();";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramProductSysNo = new SqlParameter("@ProductSysNo", SqlDbType.Int, 4);
SqlParameter paramMarketLowestPrice = new SqlParameter("@MarketLowestPrice", SqlDbType.Decimal, 9);
SqlParameter paramMarketUrl = new SqlParameter("@MarketUrl", SqlDbType.NVarChar, 500);
SqlParameter paramCreateMemo = new SqlParameter("@CreateMemo", SqlDbType.NVarChar, 500);
SqlParameter paramCreateUserSysNo = new SqlParameter("@CreateUserSysNo", SqlDbType.Int, 4);
SqlParameter paramCreateTime = new SqlParameter("@CreateTime", SqlDbType.DateTime);
SqlParameter paramAuditMemo = new SqlParameter("@AuditMemo", SqlDbType.NVarChar, 500);
SqlParameter paramAuditUserSysNo = new SqlParameter("@AuditUserSysNo", SqlDbType.Int, 4);
SqlParameter paramAuditTime = new SqlParameter("@AuditTime", SqlDbType.DateTime);
SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4);
paramSysNo.Direction = ParameterDirection.Output;
if (oParam.ProductSysNo != AppConst.IntNull)
paramProductSysNo.Value = oParam.ProductSysNo;
else
paramProductSysNo.Value = System.DBNull.Value;
if (oParam.MarketLowestPrice != AppConst.DecimalNull)
paramMarketLowestPrice.Value = oParam.MarketLowestPrice;
else
paramMarketLowestPrice.Value = System.DBNull.Value;
if (oParam.MarketUrl != AppConst.StringNull)
paramMarketUrl.Value = oParam.MarketUrl;
else
paramMarketUrl.Value = System.DBNull.Value;
if (oParam.CreateMemo != AppConst.StringNull)
paramCreateMemo.Value = oParam.CreateMemo;
else
paramCreateMemo.Value = System.DBNull.Value;
if (oParam.CreateUserSysNo != AppConst.IntNull)
paramCreateUserSysNo.Value = oParam.CreateUserSysNo;
else
paramCreateUserSysNo.Value = System.DBNull.Value;
if (oParam.CreateTime != AppConst.DateTimeNull)
paramCreateTime.Value = oParam.CreateTime;
else
paramCreateTime.Value = System.DBNull.Value;
if (oParam.AuditMemo != AppConst.StringNull)
paramAuditMemo.Value = oParam.AuditMemo;
else
paramAuditMemo.Value = System.DBNull.Value;
if (oParam.AuditUserSysNo != AppConst.IntNull)
paramAuditUserSysNo.Value = oParam.AuditUserSysNo;
else
paramAuditUserSysNo.Value = System.DBNull.Value;
if (oParam.AuditTime != AppConst.DateTimeNull)
paramAuditTime.Value = oParam.AuditTime;
else
paramAuditTime.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(paramProductSysNo);
cmd.Parameters.Add(paramMarketLowestPrice);
cmd.Parameters.Add(paramMarketUrl);
cmd.Parameters.Add(paramCreateMemo);
cmd.Parameters.Add(paramCreateUserSysNo);
cmd.Parameters.Add(paramCreateTime);
cmd.Parameters.Add(paramAuditMemo);
cmd.Parameters.Add(paramAuditUserSysNo);
cmd.Parameters.Add(paramAuditTime);
cmd.Parameters.Add(paramStatus);
return SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo);
}
public int Update(ProductPriceMarketInfo oParam)
{
string sql = @"UPDATE Product_Price_Market SET
ProductSysNo=@ProductSysNo, MarketLowestPrice=@MarketLowestPrice,
MarketUrl=@MarketUrl, CreateMemo=@CreateMemo,
CreateUserSysNo=@CreateUserSysNo, CreateTime=@CreateTime,
AuditMemo=@AuditMemo, AuditUserSysNo=@AuditUserSysNo,
AuditTime=@AuditTime, Status=@Status
WHERE SysNo=@SysNo";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramProductSysNo = new SqlParameter("@ProductSysNo", SqlDbType.Int, 4);
SqlParameter paramMarketLowestPrice = new SqlParameter("@MarketLowestPrice", SqlDbType.Decimal, 9);
SqlParameter paramMarketUrl = new SqlParameter("@MarketUrl", SqlDbType.NVarChar, 500);
SqlParameter paramCreateMemo = new SqlParameter("@CreateMemo", SqlDbType.NVarChar, 500);
SqlParameter paramCreateUserSysNo = new SqlParameter("@CreateUserSysNo", SqlDbType.Int, 4);
SqlParameter paramCreateTime = new SqlParameter("@CreateTime", SqlDbType.DateTime);
SqlParameter paramAuditMemo = new SqlParameter("@AuditMemo", SqlDbType.NVarChar, 500);
SqlParameter paramAuditUserSysNo = new SqlParameter("@AuditUserSysNo", SqlDbType.Int, 4);
SqlParameter paramAuditTime = new SqlParameter("@AuditTime", SqlDbType.DateTime);
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.ProductSysNo != AppConst.IntNull)
paramProductSysNo.Value = oParam.ProductSysNo;
else
paramProductSysNo.Value = System.DBNull.Value;
if (oParam.MarketLowestPrice != AppConst.DecimalNull)
paramMarketLowestPrice.Value = oParam.MarketLowestPrice;
else
paramMarketLowestPrice.Value = System.DBNull.Value;
if (oParam.MarketUrl != AppConst.StringNull)
paramMarketUrl.Value = oParam.MarketUrl;
else
paramMarketUrl.Value = System.DBNull.Value;
if (oParam.CreateMemo != AppConst.StringNull)
paramCreateMemo.Value = oParam.CreateMemo;
else
paramCreateMemo.Value = System.DBNull.Value;
if (oParam.CreateUserSysNo != AppConst.IntNull)
paramCreateUserSysNo.Value = oParam.CreateUserSysNo;
else
paramCreateUserSysNo.Value = System.DBNull.Value;
if (oParam.CreateTime != AppConst.DateTimeNull)
paramCreateTime.Value = oParam.CreateTime;
else
paramCreateTime.Value = System.DBNull.Value;
if (oParam.AuditMemo != AppConst.StringNull)
paramAuditMemo.Value = oParam.AuditMemo;
else
paramAuditMemo.Value = System.DBNull.Value;
if (oParam.AuditUserSysNo != AppConst.IntNull)
paramAuditUserSysNo.Value = oParam.AuditUserSysNo;
else
paramAuditUserSysNo.Value = System.DBNull.Value;
if (oParam.AuditTime != AppConst.DateTimeNull)
paramAuditTime.Value = oParam.AuditTime;
else
paramAuditTime.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(paramProductSysNo);
cmd.Parameters.Add(paramMarketLowestPrice);
cmd.Parameters.Add(paramMarketUrl);
cmd.Parameters.Add(paramCreateMemo);
cmd.Parameters.Add(paramCreateUserSysNo);
cmd.Parameters.Add(paramCreateTime);
cmd.Parameters.Add(paramAuditMemo);
cmd.Parameters.Add(paramAuditUserSysNo);
cmd.Parameters.Add(paramAuditTime);
cmd.Parameters.Add(paramStatus);
return SqlHelper.ExecuteNonQuery(cmd);
}
private void mapProductPriceMarket(ProductPriceMarketInfo oParam, DataRow tempdr)
{
oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]);
oParam.ProductSysNo = Util.TrimIntNull(tempdr["ProductSysNo"]);
oParam.MarketLowestPrice = Util.TrimDecimalNull(tempdr["MarketLowestPrice"]);
oParam.MarketUrl = Util.TrimNull(tempdr["MarketUrl"]);
oParam.CreateMemo = Util.TrimNull(tempdr["CreateMemo"]);
oParam.CreateUserSysNo = Util.TrimIntNull(tempdr["CreateUserSysNo"]);
oParam.CreateTime = Util.TrimDateNull(tempdr["CreateTime"]);
oParam.AuditMemo = Util.TrimNull(tempdr["AuditMemo"]);
oParam.AuditUserSysNo = Util.TrimIntNull(tempdr["AuditUserSysNo"]);
oParam.AuditTime = Util.TrimDateNull(tempdr["AuditTime"]);
oParam.Status = Util.TrimIntNull(tempdr["Status"]);
}
public int UpdateProductPriceMarket(ProductPriceMarketInfo oParam)
{
return new ProductPriceMarketDac().Update(oParam);
}
//��ѯ�г��ͼ���Ϣ
public ProductPriceMarketInfo LoadPriceMarket(int sysno)
{
string sql = "select * from Product_Price_Market where sysno=" + sysno.ToString();
DataSet ds = SqlHelper.ExecuteDataSet(sql);
ProductPriceMarketInfo ppr = new ProductPriceMarketInfo();
if (Util.HasMoreRow(ds))
{
mapProductPriceMarket(ppr, ds.Tables[0].Rows[0]);
}
else
{
ppr = null;
}
return ppr;
}
public void InsertProductPriceMarket(ProductPriceMarketInfo oParam)
{
TransactionOptions options = new TransactionOptions();
options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
options.Timeout = TransactionManager.DefaultTimeout;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
{
new ProductPriceMarketDac().Insert(oParam);
SetLastMarketLowestPrice(oParam.ProductSysNo, oParam.MarketLowestPrice);
scope.Complete();
}
}
