private void map(PriceReportInfo oParam, DataRow tempdr) { oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]); oParam.ProductSysNo = Util.TrimIntNull(tempdr["ProductSysNo"]); oParam.CurrentPrice = Util.TrimDecimalNull(tempdr["CurrentPrice"]); oParam.UnitCost = Util.TrimDecimalNull(tempdr["UnitCost"]); oParam.LastOrderPrice = Util.TrimDecimalNull(tempdr["LastOrderPrice"]); oParam.CompetitorSysNo = Util.TrimIntNull(tempdr["CompetitorSysNo"]); oParam.CompetitorPrice = Util.TrimDecimalNull(tempdr["CompetitorPrice"]); oParam.CompetitorUrl = Util.TrimNull(tempdr["CompetitorUrl"]); oParam.CustomerSysNo = Util.TrimIntNull(tempdr["CustomerSysNo"]); oParam.NickName = Util.TrimNull(tempdr["NickName"]); oParam.Email = Util.TrimNull(tempdr["Email"]); oParam.CustomerMemo = Util.TrimNull(tempdr["CustomerMemo"]); oParam.ReportTime = Util.TrimDateNull(tempdr["ReportTime"]); oParam.CustomerIP = Util.TrimNull(tempdr["CustomerIP"]); oParam.AuditUserSysNo = Util.TrimIntNull(tempdr["AuditUserSysNo"]); oParam.AuditMemo = Util.TrimNull(tempdr["AuditMemo"]); oParam.AuditNote = Util.TrimNull(tempdr["AuditNote"]); oParam.AuditTime = Util.TrimDateNull(tempdr["AuditTime"]); oParam.AbandonUserSysNo = Util.TrimIntNull(tempdr["AbandonUserSysNo"]); oParam.AbandonTime = Util.TrimDateNull(tempdr["AbandonTime"]); oParam.Point = Util.TrimIntNull(tempdr["Point"]); oParam.HandleType = Util.TrimIntNull(tempdr["HandleType"]); oParam.Reason = Util.TrimIntNull(tempdr["Reason"]); oParam.Status = Util.TrimIntNull(tempdr["Status"]); }
public int Insert(PriceReportInfo oParam) { PriceReportInfo pr = Load(oParam.ProductSysNo, oParam.CustomerSysNo); if (pr != null && pr.ReportTime.ToString(AppConst.DateFormat) == DateTime.Now.ToString(AppConst.DateFormat)) { throw new BizException("�����ظ��ύ�۸�ٱ���Ϣ��"); } return new PriceReportDac().Insert(oParam); }
public PriceReportInfo Load(int ProductSysNo,int CustomerSysNo) { string sql = "select * from price_report where productsysno=" + ProductSysNo + " and customersysno=" + CustomerSysNo; DataSet ds = SqlHelper.ExecuteDataSet(sql); if (Util.HasMoreRow(ds)) { PriceReportInfo oInfo = new PriceReportInfo(); map(oInfo, ds.Tables[0].Rows[0]); return oInfo; } else return null; }
public int Insert(PriceReportInfo oParam) { string sql = @"INSERT INTO Price_Report ( ProductSysNo, CurrentPrice, UnitCost, LastOrderPrice, CompetitorSysNo, CompetitorPrice, CompetitorUrl, CustomerSysNo, NickName, Email, CustomerMemo, ReportTime, CustomerIP, AuditUserSysNo, AuditMemo, AuditNote, AuditTime, AbandonUserSysNo, AbandonTime, Point, HandleType, Reason, Status ) VALUES ( @ProductSysNo, @CurrentPrice, @UnitCost, @LastOrderPrice, @CompetitorSysNo, @CompetitorPrice, @CompetitorUrl, @CustomerSysNo, @NickName, @Email, @CustomerMemo, @ReportTime, @CustomerIP, @AuditUserSysNo, @AuditMemo, @AuditNote, @AuditTime, @AbandonUserSysNo, @AbandonTime, @Point, @HandleType, @Reason, @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 paramCurrentPrice = new SqlParameter("@CurrentPrice", SqlDbType.Decimal, 9); SqlParameter paramUnitCost = new SqlParameter("@UnitCost", SqlDbType.Decimal, 9); SqlParameter paramLastOrderPrice = new SqlParameter("@LastOrderPrice", SqlDbType.Decimal, 9); SqlParameter paramCompetitorSysNo = new SqlParameter("@CompetitorSysNo", SqlDbType.Int, 4); SqlParameter paramCompetitorPrice = new SqlParameter("@CompetitorPrice", SqlDbType.Decimal, 9); SqlParameter paramCompetitorUrl = new SqlParameter("@CompetitorUrl", SqlDbType.NVarChar, 500); SqlParameter paramCustomerSysNo = new SqlParameter("@CustomerSysNo", SqlDbType.Int, 4); SqlParameter paramNickName = new SqlParameter("@NickName", SqlDbType.NVarChar, 100); SqlParameter paramEmail = new SqlParameter("@Email", SqlDbType.NVarChar, 100); SqlParameter paramCustomerMemo = new SqlParameter("@CustomerMemo", SqlDbType.NVarChar, 500); SqlParameter paramReportTime = new SqlParameter("@ReportTime", SqlDbType.DateTime); SqlParameter paramCustomerIP = new SqlParameter("@CustomerIP", SqlDbType.NVarChar, 50); SqlParameter paramAuditUserSysNo = new SqlParameter("@AuditUserSysNo", SqlDbType.Int, 4); SqlParameter paramAuditMemo = new SqlParameter("@AuditMemo", SqlDbType.NVarChar, 200); SqlParameter paramAuditNote = new SqlParameter("@AuditNote", SqlDbType.NVarChar, 200); SqlParameter paramAuditTime = new SqlParameter("@AuditTime", SqlDbType.DateTime); SqlParameter paramAbandonUserSysNo = new SqlParameter("@AbandonUserSysNo", SqlDbType.Int, 4); SqlParameter paramAbandonTime = new SqlParameter("@AbandonTime", SqlDbType.DateTime); SqlParameter paramPoint = new SqlParameter("@Point", SqlDbType.Int, 4); SqlParameter paramHandleType = new SqlParameter("@HandleType", SqlDbType.Int, 4); SqlParameter paramReason = new SqlParameter("@Reason", SqlDbType.Int, 4); 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.CurrentPrice != AppConst.DecimalNull) paramCurrentPrice.Value = oParam.CurrentPrice; else paramCurrentPrice.Value = System.DBNull.Value; if (oParam.UnitCost != AppConst.DecimalNull) paramUnitCost.Value = oParam.UnitCost; else paramUnitCost.Value = System.DBNull.Value; if (oParam.LastOrderPrice != AppConst.DecimalNull) paramLastOrderPrice.Value = oParam.LastOrderPrice; else paramLastOrderPrice.Value = System.DBNull.Value; if (oParam.CompetitorSysNo != AppConst.IntNull) paramCompetitorSysNo.Value = oParam.CompetitorSysNo; else paramCompetitorSysNo.Value = System.DBNull.Value; if (oParam.CompetitorPrice != AppConst.DecimalNull) paramCompetitorPrice.Value = oParam.CompetitorPrice; else paramCompetitorPrice.Value = System.DBNull.Value; if (oParam.CompetitorUrl != AppConst.StringNull) paramCompetitorUrl.Value = oParam.CompetitorUrl; else paramCompetitorUrl.Value = System.DBNull.Value; if (oParam.CustomerSysNo != AppConst.IntNull) paramCustomerSysNo.Value = oParam.CustomerSysNo; else paramCustomerSysNo.Value = System.DBNull.Value; if (oParam.NickName != AppConst.StringNull) paramNickName.Value = oParam.NickName; else paramNickName.Value = System.DBNull.Value; if (oParam.Email != AppConst.StringNull) paramEmail.Value = oParam.Email; else paramEmail.Value = System.DBNull.Value; if (oParam.CustomerMemo != AppConst.StringNull) paramCustomerMemo.Value = oParam.CustomerMemo; else paramCustomerMemo.Value = System.DBNull.Value; if (oParam.ReportTime != AppConst.DateTimeNull) paramReportTime.Value = oParam.ReportTime; else paramReportTime.Value = System.DBNull.Value; if (oParam.CustomerIP != AppConst.StringNull) paramCustomerIP.Value = oParam.CustomerIP; else paramCustomerIP.Value = System.DBNull.Value; if (oParam.AuditUserSysNo != AppConst.IntNull) paramAuditUserSysNo.Value = oParam.AuditUserSysNo; else paramAuditUserSysNo.Value = System.DBNull.Value; if (oParam.AuditMemo != AppConst.StringNull) paramAuditMemo.Value = oParam.AuditMemo; else paramAuditMemo.Value = System.DBNull.Value; if (oParam.AuditNote != AppConst.StringNull) paramAuditNote.Value = oParam.AuditNote; else paramAuditNote.Value = System.DBNull.Value; if (oParam.AuditTime != AppConst.DateTimeNull) paramAuditTime.Value = oParam.AuditTime; else paramAuditTime.Value = System.DBNull.Value; if (oParam.AbandonUserSysNo != AppConst.IntNull) paramAbandonUserSysNo.Value = oParam.AbandonUserSysNo; else paramAbandonUserSysNo.Value = System.DBNull.Value; if (oParam.AbandonTime != AppConst.DateTimeNull) paramAbandonTime.Value = oParam.AbandonTime; else paramAbandonTime.Value = System.DBNull.Value; if (oParam.Point != AppConst.IntNull) paramPoint.Value = oParam.Point; else paramPoint.Value = System.DBNull.Value; if (oParam.HandleType != AppConst.IntNull) paramHandleType.Value = oParam.HandleType; else paramHandleType.Value = System.DBNull.Value; if (oParam.Reason != AppConst.IntNull) paramReason.Value = oParam.Reason; else paramReason.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(paramCurrentPrice); cmd.Parameters.Add(paramUnitCost); cmd.Parameters.Add(paramLastOrderPrice); cmd.Parameters.Add(paramCompetitorSysNo); cmd.Parameters.Add(paramCompetitorPrice); cmd.Parameters.Add(paramCompetitorUrl); cmd.Parameters.Add(paramCustomerSysNo); cmd.Parameters.Add(paramNickName); cmd.Parameters.Add(paramEmail); cmd.Parameters.Add(paramCustomerMemo); cmd.Parameters.Add(paramReportTime); cmd.Parameters.Add(paramCustomerIP); cmd.Parameters.Add(paramAuditUserSysNo); cmd.Parameters.Add(paramAuditMemo); cmd.Parameters.Add(paramAuditNote); cmd.Parameters.Add(paramAuditTime); cmd.Parameters.Add(paramAbandonUserSysNo); cmd.Parameters.Add(paramAbandonTime); cmd.Parameters.Add(paramPoint); cmd.Parameters.Add(paramHandleType); cmd.Parameters.Add(paramReason); cmd.Parameters.Add(paramStatus); return SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo); }