//---------2006-07-27------------- // public int AddScore(int CustomerSysNo,int AddTotalScore,int AddValidScore) // { // string sql = @"UPDATE Customer SET TotalScore = TotalScore+@AddTotalScore,ValidScore=ValidScore+@AddValidScore WHERE SysNo=@CustomerSysNo"; // // SqlCommand cmd = new SqlCommand(sql); // // SqlParameter paramCustomerSysNo = new SqlParameter("@CustomerSysNo", SqlDbType.Int,4); // SqlParameter paramAddTotalScore = new SqlParameter("@AddTotalScore", SqlDbType.Int,4); // SqlParameter paramAddValidScore = new SqlParameter("@AddValidScore", SqlDbType.Int,4); // // if ( CustomerSysNo != AppConst.IntNull) // paramCustomerSysNo.Value = CustomerSysNo; // else // paramCustomerSysNo.Value = System.DBNull.Value; // // if ( AddTotalScore != AppConst.IntNull) // paramAddTotalScore.Value = AddTotalScore; // else // paramAddTotalScore.Value = System.DBNull.Value; // // if ( AddTotalScore != AppConst.IntNull) // paramAddValidScore.Value = AddValidScore; // else // paramAddValidScore.Value = System.DBNull.Value; // // cmd.Parameters.Add(paramCustomerSysNo); // cmd.Parameters.Add(paramAddTotalScore); // cmd.Parameters.Add(paramAddValidScore); // // return SqlHelper.ExecuteNonQuery(cmd); // } public int InsertCustomerPointRequest(CustomerPointRequestInfo oParam) { string sql = @"INSERT INTO Customer_PointRequest ( CustomerSysNo, PointSourceType, PointSourceSysNo, PointLogType, PointAmount, RequestUserType, RequestUserSysNo, RequestTime, AuditUserSysNo, AuditTime, AddUserSysNo, AddTime, AbandonUserSysNo, AbandonTime, Memo, Status,PMUserSysNo ) VALUES ( @CustomerSysNo, @PointSourceType, @PointSourceSysNo, @PointLogType, @PointAmount, @RequestUserType, @RequestUserSysNo, @RequestTime, @AuditUserSysNo, @AuditTime, @AddUserSysNo, @AddTime, @AbandonUserSysNo, @AbandonTime, @Memo, @Status,@PMUserSysNo );set @SysNo = SCOPE_IDENTITY();"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramCustomerSysNo = new SqlParameter("@CustomerSysNo", SqlDbType.Int, 4); SqlParameter paramPointSourceType = new SqlParameter("@PointSourceType", SqlDbType.Int, 4); SqlParameter paramPointSourceSysNo = new SqlParameter("@PointSourceSysNo", SqlDbType.Int, 4); SqlParameter paramPointLogType = new SqlParameter("@PointLogType", SqlDbType.Int, 4); SqlParameter paramPointAmount = new SqlParameter("@PointAmount", SqlDbType.Int, 4); SqlParameter paramRequestUserType = new SqlParameter("@RequestUserType", SqlDbType.Int, 4); SqlParameter paramRequestUserSysNo = new SqlParameter("@RequestUserSysNo", SqlDbType.Int, 4); SqlParameter paramRequestTime = new SqlParameter("@RequestTime", SqlDbType.DateTime); SqlParameter paramAuditUserSysNo = new SqlParameter("@AuditUserSysNo", SqlDbType.Int, 4); SqlParameter paramAuditTime = new SqlParameter("@AuditTime", SqlDbType.DateTime); SqlParameter paramAddUserSysNo = new SqlParameter("@AddUserSysNo", SqlDbType.Int, 4); SqlParameter paramAddTime = new SqlParameter("@AddTime", SqlDbType.DateTime); SqlParameter paramAbandonUserSysNo = new SqlParameter("@AbandonUserSysNo", SqlDbType.Int, 4); SqlParameter paramAbandonTime = new SqlParameter("@AbandonTime", SqlDbType.DateTime); SqlParameter paramMemo = new SqlParameter("@Memo", SqlDbType.NVarChar, 200); SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4); SqlParameter paramPMUserSysNo = new SqlParameter("@PMUserSysNo", SqlDbType.Int, 4); paramSysNo.Direction = ParameterDirection.Output; if (oParam.CustomerSysNo != AppConst.IntNull) paramCustomerSysNo.Value = oParam.CustomerSysNo; else paramCustomerSysNo.Value = System.DBNull.Value; if (oParam.PointSourceType != AppConst.IntNull) paramPointSourceType.Value = oParam.PointSourceType; else paramPointSourceType.Value = System.DBNull.Value; if (oParam.PointSourceSysNo != AppConst.IntNull) paramPointSourceSysNo.Value = oParam.PointSourceSysNo; else paramPointSourceSysNo.Value = System.DBNull.Value; if (oParam.PointLogType != AppConst.IntNull) paramPointLogType.Value = oParam.PointLogType; else paramPointLogType.Value = System.DBNull.Value; if (oParam.PointAmount != AppConst.IntNull) paramPointAmount.Value = oParam.PointAmount; else paramPointAmount.Value = System.DBNull.Value; if (oParam.RequestUserType != AppConst.IntNull) paramRequestUserType.Value = oParam.RequestUserType; else paramRequestUserType.Value = System.DBNull.Value; if (oParam.RequestUserSysNo != AppConst.IntNull) paramRequestUserSysNo.Value = oParam.RequestUserSysNo; else paramRequestUserSysNo.Value = System.DBNull.Value; if (oParam.RequestTime != AppConst.DateTimeNull) paramRequestTime.Value = oParam.RequestTime; else paramRequestTime.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.AddUserSysNo != AppConst.IntNull) paramAddUserSysNo.Value = oParam.AddUserSysNo; else paramAddUserSysNo.Value = System.DBNull.Value; if (oParam.AddTime != AppConst.DateTimeNull) paramAddTime.Value = oParam.AddTime; else paramAddTime.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.Memo != AppConst.StringNull) paramMemo.Value = oParam.Memo; else paramMemo.Value = System.DBNull.Value; if (oParam.Status != AppConst.IntNull) paramStatus.Value = oParam.Status; else paramStatus.Value = System.DBNull.Value; if (oParam.PMUserSysNo != AppConst.IntNull) paramPMUserSysNo.Value = oParam.PMUserSysNo; else paramPMUserSysNo.Value = System.DBNull.Value; cmd.Parameters.Add(paramSysNo); cmd.Parameters.Add(paramCustomerSysNo); cmd.Parameters.Add(paramPointSourceType); cmd.Parameters.Add(paramPointSourceSysNo); cmd.Parameters.Add(paramPointLogType); cmd.Parameters.Add(paramPointAmount); cmd.Parameters.Add(paramRequestUserType); cmd.Parameters.Add(paramRequestUserSysNo); cmd.Parameters.Add(paramRequestTime); cmd.Parameters.Add(paramAuditUserSysNo); cmd.Parameters.Add(paramAuditTime); cmd.Parameters.Add(paramAddUserSysNo); cmd.Parameters.Add(paramAddTime); cmd.Parameters.Add(paramAbandonUserSysNo); cmd.Parameters.Add(paramAbandonTime); cmd.Parameters.Add(paramMemo); cmd.Parameters.Add(paramStatus); cmd.Parameters.Add(paramPMUserSysNo); return SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo); }
public void Update(Hashtable paramHash) { TransactionOptions options = new TransactionOptions(); options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted; options.Timeout = TransactionManager.DefaultTimeout; using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options)) { if (paramHash.ContainsKey("Status")) { bool NeedAddPoint = false; int newStatus = Int32.Parse(paramHash["Status"].ToString()); int SysNo = Int32.Parse(paramHash["SysNo"].ToString()); PriceReportInfo oInfo = Load(SysNo); if (newStatus == (int)AppEnum.PriceReportStatus.Abandon) { if (oInfo.Status != (int)AppEnum.PriceReportStatus.Origin&&oInfo.Status!=(int)AppEnum.PriceReportStatus.AuditWaitingChangePrice) throw new BizException("�dz�ʼ״̬����������"); } else if (newStatus == (int)AppEnum.PriceReportStatus.Origin) { if (oInfo.Status != (int)AppEnum.PriceReportStatus.Abandon) throw new BizException("������״̬������ȡ������"); } else if (newStatus == (int)AppEnum.PriceReportStatus.AuditedNotChangePrice) { NeedAddPoint = true; if (oInfo.Status != (int)AppEnum.PriceReportStatus.Origin && oInfo.Status != (int)AppEnum.PriceReportStatus.AuditWaitingChangePrice) throw new BizException("�dz�ʼ״̬��������˲��ļ۸�"); } else if (newStatus == (int)AppEnum.PriceReportStatus.AuditChangePrice) { NeedAddPoint = true; if (oInfo.Status != (int)AppEnum.PriceReportStatus.Origin && oInfo.Status != (int)AppEnum.PriceReportStatus.AuditWaitingChangePrice) throw new BizException("�dz�ʼ״̬��������˲��ļ۸�"); } new PriceReportDac().Update(paramHash); if (NeedAddPoint) { oInfo = Load(SysNo); CustomerPointRequestInfo cprInfo = new CustomerPointRequestInfo(); cprInfo.CustomerSysNo = oInfo.CustomerSysNo; cprInfo.PointSourceType = (int)AppEnum.PointSourceType.PriceReport; cprInfo.PointSourceSysNo = SysNo; cprInfo.PointLogType = (int)AppEnum.PointLogType.award; cprInfo.PointAmount = oInfo.Point; cprInfo.Memo = oInfo.AuditMemo; cprInfo.RequestTime = DateTime.Now; cprInfo.RequestUserSysNo = oInfo.AuditUserSysNo; cprInfo.RequestUserType = (int)AppEnum.CreateUserType.Employee; cprInfo.Status = (int)AppEnum.PointRequestStatus.Origin; PointManager.GetInstance().InsertCustomerPointRequest(cprInfo); } } else { new PriceReportDac().Update(paramHash); } scope.Complete(); } }
public CustomerPointRequestInfo LoadCustomerPointRequest(int sysno) { string sql = "select * from customer_pointrequest where sysno=" + sysno; DataSet ds = SqlHelper.ExecuteDataSet(sql); if (Util.HasMoreRow(ds)) { CustomerPointRequestInfo oInfo = new CustomerPointRequestInfo(); map(oInfo, ds.Tables[0].Rows[0]); return oInfo; } else return null; }
private void map(CustomerPointRequestInfo oParam, DataRow tempdr) { oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]); oParam.CustomerSysNo = Util.TrimIntNull(tempdr["CustomerSysNo"]); oParam.PointSourceType = Util.TrimIntNull(tempdr["PointSourceType"]); oParam.PointSourceSysNo = Util.TrimIntNull(tempdr["PointSourceSysNo"]); oParam.PointLogType = Util.TrimIntNull(tempdr["PointLogType"]); oParam.PointAmount = Util.TrimIntNull(tempdr["PointAmount"]); oParam.RequestUserType = Util.TrimIntNull(tempdr["RequestUserType"]); oParam.RequestUserSysNo = Util.TrimIntNull(tempdr["RequestUserSysNo"]); oParam.RequestTime = Util.TrimDateNull(tempdr["RequestTime"]); oParam.AuditUserSysNo = Util.TrimIntNull(tempdr["AuditUserSysNo"]); oParam.AuditTime = Util.TrimDateNull(tempdr["AuditTime"]); oParam.AddUserSysNo = Util.TrimIntNull(tempdr["AddUserSysNo"]); oParam.AddTime = Util.TrimDateNull(tempdr["AddTime"]); oParam.AbandonUserSysNo = Util.TrimIntNull(tempdr["AbandonUserSysNo"]); oParam.AbandonTime = Util.TrimDateNull(tempdr["AbandonTime"]); oParam.Memo = Util.TrimNull(tempdr["Memo"]); oParam.Status = Util.TrimIntNull(tempdr["Status"]); oParam.PMUserSysNo = Util.TrimIntNull(tempdr["PMUserSysNo"]); }
public int InsertCustomerPointRequest(CustomerPointRequestInfo oParam) { return new PointDac().InsertCustomerPointRequest(oParam); }