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