public void CancelHandleRMA(RMAInfo rmaInfo, SessionInfo sInfo)
{
TransactionOptions options = new TransactionOptions();
options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
options.Timeout = TransactionManager.DefaultTimeout;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
{
if (this.GetRMACurrentStatus(rmaInfo.SysNo) != (int)AppEnum.RMAStatus.Handled)
{
throw new BizException("This rma sheet is not handled now,can't cancel handle");
}
//如果存在退货单，则作废
ROInfo roInfo = ROManager.GetInstance().LoadROfromRMA(rmaInfo.SysNo);
if (roInfo != null)
{
ROManager.GetInstance().AbandonRO(roInfo);
LogManager.GetInstance().Write(new LogInfo(roInfo.SysNo, (int)AppEnum.LogType.Sale_RO_Abandon, sInfo));
}
Hashtable paramHash = new Hashtable(4);
paramHash.Add("Status", rmaInfo.Status);
paramHash.Add("RMATime", rmaInfo.RMATime);
paramHash.Add("RMAUserSysNo", rmaInfo.RMAUserSysNo);
paramHash.Add("SysNo", rmaInfo.SysNo);
this.UpdateRMAMaster(paramHash);
LogManager.GetInstance().Write(new LogInfo(rmaInfo.SysNo, (int)AppEnum.LogType.Sale_RMA_CancelHandle, sInfo));
scope.Complete();
}
}
void readingIsComplete(object sender, EventArgs args)
{
GeneralInfo.Fill();
ROInfo.Fill();
RWInfo.Fill();
RWFlashInfo.Fill();
}
public ROInfo LoadRO(int roSysNo)
{
string sqlMaster = @"select * from ro_master where sysno =" + roSysNo;
DataSet dsMaster = SqlHelper.ExecuteDataSet(sqlMaster);
ROInfo oRO = new ROInfo();
if (Util.HasMoreRow(dsMaster))
{
map(oRO, dsMaster.Tables[0].Rows[0]);
string sqlItem = @"select * from ro_item where rosysno =" + roSysNo;
DataSet dsItem = SqlHelper.ExecuteDataSet(sqlItem);
if (Util.HasMoreRow(dsItem))
{
foreach (DataRow dr in dsItem.Tables[0].Rows)
{
ROItemInfo oROItem = new ROItemInfo();
map(oROItem, dr);
oRO.ItemHash.Add(oROItem.SysNo, oROItem);
}
}
}
else
{
oRO = null;
}
return(oRO);
}
public void HandleRMA(RMAInfo rmaInfo, SessionInfo sInfo)
{
TransactionOptions options = new TransactionOptions();
options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
options.Timeout = TransactionManager.DefaultTimeout;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
{
if (this.GetRMACurrentStatus(rmaInfo.SysNo) != (int)AppEnum.RMAStatus.Received)
{
throw new BizException("This rma sheet is not received now,can't be handled");
}
Hashtable paramHash = new Hashtable(4);
paramHash.Add("Status", rmaInfo.Status);
paramHash.Add("RMATime", rmaInfo.RMATime);
paramHash.Add("RMAUserSysNo", rmaInfo.RMAUserSysNo);
paramHash.Add("SysNo", rmaInfo.SysNo);
this.UpdateRMAMaster(paramHash);
//如果有退货类型的商品，自动生成退货单
foreach (RMAItemInfo rmaItem in rmaInfo.ItemHash.Values)
{
if (rmaItem.RMAType == (int)AppEnum.RMAType.Return)
{
ROInfo roInfo = ROManager.GetInstance().BuildROFromRMA(rmaInfo);
ROManager.GetInstance().AddRO(roInfo);
LogManager.GetInstance().Write(new LogInfo(roInfo.SysNo, (int)AppEnum.LogType.Sale_RO_Create, sInfo));
break;
}
}
LogManager.GetInstance().Write(new LogInfo(rmaInfo.SysNo, (int)AppEnum.LogType.Sale_RMA_Handle, sInfo));
scope.Complete();
}
}
public void UpdateROMaster(ROInfo roInfo)
{
TransactionOptions options = new TransactionOptions();
options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
options.Timeout = TransactionManager.DefaultTimeout;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
{
Hashtable paramHash = new Hashtable();
paramHash.Add("AuditTime", roInfo.AuditTime);
paramHash.Add("AuditUserSysNo", roInfo.AuditUserSysNo);
paramHash.Add("CashAmt", roInfo.CashAmt);
paramHash.Add("Note", roInfo.Note);
paramHash.Add("OriginCashAmt", roInfo.OriginCashAmt);
paramHash.Add("OriginPointAmt", roInfo.OriginPointAmt);
paramHash.Add("PointAmt", roInfo.PointAmt);
paramHash.Add("ReceiveName", roInfo.ReceiveName);
paramHash.Add("ReceiveAddress", roInfo.ReceiveAddress);
paramHash.Add("ReceivePhone", roInfo.ReceivePhone);
paramHash.Add("RedeemAmt", roInfo.RedeemAmt);
paramHash.Add("ReturnTime", roInfo.ReturnTime);
paramHash.Add("ReturnUserSysNo", roInfo.ReturnUserSysNo);
paramHash.Add("RMASysNo", roInfo.RMASysNo);
paramHash.Add("ROID", roInfo.ROID);
paramHash.Add("Status", roInfo.Status);
paramHash.Add("StockSysNo", roInfo.StockSysNo);
paramHash.Add("SysNo", roInfo.SysNo);
this.UpdateROMaster(paramHash);
scope.Complete();
}
}
public void AddRO(ROInfo roInfo)
{
TransactionOptions options = new TransactionOptions();
options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
options.Timeout = TransactionManager.DefaultTimeout;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
{
roInfo.SysNo = SequenceDac.GetInstance().Create("RO_Sequence");
roInfo.ROID = this.BuildROID(roInfo.SysNo);
new RODac().InsertMaster(roInfo);
if (roInfo.ItemHash.Count > 0)
{
foreach (ROItemInfo roItem in roInfo.ItemHash.Values)
{
roItem.ROSysNo = roInfo.SysNo;
new RODac().InsertItem(roItem);
}
}
else
{
throw new BizException("Can't create an empty RO'");
}
scope.Complete();
}
}
public void ReturnRO(ROInfo roInfo)
{
TransactionOptions options = new TransactionOptions();
options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
options.Timeout = TransactionManager.DefaultTimeout;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
{
if (this.GetROCurrentStatus(roInfo.SysNo) != (int)AppEnum.ROStatus.Audited)
{
throw new BizException("This RO is not Audited now ,can't be returned");
}
roInfo.Status = (int)AppEnum.ROStatus.Returned;
//update ro status
Hashtable paramHash = new Hashtable(4);
paramHash.Add("Status", roInfo.Status);
paramHash.Add("ReturnTime", roInfo.ReturnTime);
paramHash.Add("ReturnUserSysNo", roInfo.ReturnUserSysNo);
paramHash.Add("SysNo", roInfo.SysNo);
this.UpdateROMaster(paramHash);
//update inventory
foreach (ROItemInfo roItem in roInfo.ItemHash.Values)
{
//UnitCostManager.GetInstance().SetCost(roItem.ProductSysNo, roItem.Quantity, roItem.Cost); //Serious bug 2007-07-21
//退货时不影响一手商品的成本，只需要修改二手商品的成本
UnitCostManager.GetInstance().SetCost(roItem.ReturnSysNo, roItem.Quantity, roItem.Cost);
InventoryManager.GetInstance().SetInStockQty(roInfo.StockSysNo, roItem.ReturnSysNo, roItem.Quantity);
}
//update customer score
RMAInfo oRMA = RMAManager.GetInstance().LoadMaster(roInfo.RMASysNo);
//先将销售单所得积分加上
PointManager.GetInstance().DoDelayPointSingle(oRMA.SOSysNo);
//然后减去退货对应积分
if (roInfo.PointAmt != 0)
{
PointManager.GetInstance().SetScore(oRMA.CustomerSysNo, roInfo.PointAmt * (-1), (int)AppEnum.PointLogType.ReturnProduct, roInfo.SysNo.ToString());
}
//生成收款单
//如果无有效的收款单-->生成soincome(normal, origin)
SOIncomeInfo soIncome = SOIncomeManager.GetInstance().LoadValid((int)AppEnum.SOIncomeOrderType.RO, roInfo.SysNo);
if (soIncome == null)//无有效收款单，生成收款单
{
soIncome = new SOIncomeInfo();
soIncome.OrderType = (int)AppEnum.SOIncomeOrderType.RO;
soIncome.OrderSysNo = roInfo.SysNo;
soIncome.OrderAmt = soIncome.IncomeAmt = Util.TruncMoney(roInfo.CashAmt + roInfo.RedeemAmt);
soIncome.IncomeStyle = (int)AppEnum.SOIncomeStyle.Normal;
soIncome.IncomeUserSysNo = roInfo.ReturnUserSysNo;
soIncome.IncomeTime = DateTime.Now;
soIncome.Status = (int)AppEnum.SOIncomeStatus.Origin;
SOIncomeManager.GetInstance().Insert(soIncome);
}
scope.Complete();
}
}
public ROInfo BuildROFromRMA(RMAInfo rmaInfo)
{
ROInfo roInfo = new ROInfo();
SOInfo soInfo = SaleManager.GetInstance().LoadSO(rmaInfo.SOSysNo);
roInfo.RMASysNo = rmaInfo.SysNo;
roInfo.CreateTime = DateTime.Now;
roInfo.CreateUserSysNo = rmaInfo.RMAUserSysNo;
roInfo.StockSysNo = soInfo.StockSysNo;
roInfo.Status = (int)AppEnum.ROStatus.Origin;
roInfo.ReceiveName = soInfo.ReceiveName;
roInfo.ReceivePhone = soInfo.ReceivePhone;
roInfo.ReceiveAddress = soInfo.ReceiveAddress;
roInfo.PointAmt = 0;
roInfo.CashAmt = 0m;
roInfo.RedeemAmt = 0m;
Hashtable leftHash = RMAManager.GetInstance().GetLeftRMAQty(rmaInfo.SOSysNo);
decimal originCashAmt = 0m;
int originPointAmt = 0;
foreach (RMAItemInfo rmaItem in rmaInfo.ItemHash.Values)
{
if (rmaItem.RMAType == (int)AppEnum.RMAType.Return)
{
ROItemInfo roItem = new ROItemInfo();
roItem.ProductSysNo = rmaItem.ProductSysNo;
roItem.Quantity = rmaItem.RMAQty;
if (roItem.Quantity > (int)leftHash[(int)roItem.ProductSysNo])
{
throw new BizException("Too many item(" + roItem.ProductSysNo + ") to return");
}
foreach (SOItemInfo soItem in soInfo.ItemHash.Values)
{
if (soItem.ProductSysNo == rmaItem.ProductSysNo)
{
roItem.Price = soItem.Price;
roItem.Point = soItem.Point;
roItem.Cost = soItem.Cost;
roItem.Weight = soItem.Weight;
roItem.RefundPoint = soItem.Point;
roItem.RefundCash = soItem.Price;
roItem.ReturnPriceType = (int)AppEnum.ReturnPriceType.InputPrice;
roItem.ReturnType = (int)AppEnum.ReturnType.SecondHand;
originCashAmt += roItem.Price * roItem.Quantity;
originPointAmt += roItem.Point * roItem.Quantity;
break;
}
}
roInfo.ItemHash.Add(roItem.ProductSysNo, roItem);
}
}
roInfo.OriginPointAmt = originPointAmt;
roInfo.OriginCashAmt = originCashAmt;
return(roInfo);
}
public void UpdateRO(ROInfo roInfo)
{
TransactionOptions options = new TransactionOptions();
options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
options.Timeout = TransactionManager.DefaultTimeout;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
{
this.UpdateROMaster(roInfo);
foreach (ROItemInfo roItem in roInfo.ItemHash.Values)
{
this.UpdateROItem(roItem);
}
scope.Complete();
}
}
private void CalcRO(ROInfo roInfo)
{
TransactionOptions options = new TransactionOptions();
options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
options.Timeout = TransactionManager.DefaultTimeout;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
{
RMAInfo rmaInfo = RMAManager.GetInstance().LoadMaster(roInfo.RMASysNo);
if (rmaInfo == null || (rmaInfo.Status != (int)AppEnum.RMAStatus.Handled && rmaInfo.Status != (int)AppEnum.RMAStatus.Closed))
{
throw new BizException("Related RMA Sheet load error");
}
SOInfo soInfo = SaleManager.GetInstance().LoadSO(rmaInfo.SOSysNo);
if (soInfo == null || soInfo.Status != (int)AppEnum.SOStatus.OutStock)
{
throw new BizException("Related SO load error");
}
decimal cashPayRate = soInfo.CashPay / soInfo.SOAmt;//获取销售单商品金额的现金支付比例
decimal refundCash = 0m;
int refundPoint = 0;
foreach (ROItemInfo roItem in roInfo.ItemHash.Values)
{
roItem.RefundCash = roItem.Price * cashPayRate * roItem.Quantity;
roItem.RefundPoint = (roItem.Point - Convert.ToInt32(decimal.Round(roItem.Price * (1 - cashPayRate), 1) * AppConst.ExchangeRate)) * roItem.Quantity;
refundCash += roItem.RefundCash;
refundPoint += roItem.RefundPoint;
}
roInfo.CashAmt = Util.ToMoney(refundCash);
roInfo.PointAmt = refundPoint;
CustomerInfo cmInfo = CustomerManager.GetInstance().Load(soInfo.CustomerSysNo);
if ((cmInfo.ValidScore - refundPoint) < 0)
{
roInfo.RedeemAmt = Convert.ToDecimal(cmInfo.ValidScore + refundPoint) / AppConst.ExchangeRate;
}
else
{
roInfo.RedeemAmt = 0m;
}
scope.Complete();
}
}
public void AuditRO(ROInfo roInfo)
{
TransactionOptions options = new TransactionOptions();
options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
options.Timeout = TransactionManager.DefaultTimeout;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
{
if (this.GetROCurrentStatus(roInfo.SysNo) != (int)AppEnum.ROStatus.Origin)
{
throw new BizException("This RO is not origin now ,can't be audited");
}
roInfo.Status = (int)AppEnum.ROStatus.Audited;
this.CalcRO(roInfo);
this.UpdateRO(roInfo);
scope.Complete();
}
}
/// <summary>
/// 获取ro发票
/// </summary>
/// <param name="roSysNo"></param>
/// <returns></returns>
public ROInvoiceInfo GetROInvoice(int roSysNo)
{
ROInvoiceInfo invoice = new ROInvoiceInfo();
ROInfo ro = this.LoadRO(roSysNo);
RMAInfo rma = RMAManager.GetInstance().Load(ro.RMASysNo);
SOInfo so = SaleManager.GetInstance().LoadSO(rma.SOSysNo);
IcsonInfo son = new IcsonInfo();
invoice.AuditUserSysNo = ro.AuditUserSysNo;
invoice.CompanyAddress = son.CompanyAddress;
invoice.InvoiceNote = so.InvoiceNote;
invoice.SOID = so.SOID;
PayTypeInfo ptInfo = ASPManager.GetInstance().LoadPayType(so.PayTypeSysNo);
invoice.PayTypeName = ptInfo.PayTypeName;
invoice.ReceiveAddress = ro.ReceiveAddress;
CustomerInfo customer = CustomerManager.GetInstance().Load(so.CustomerSysNo);
invoice.CustomerName = customer.CustomerName;
invoice.CustomerSysNo = customer.SysNo;
invoice.ReceiveName = ro.ReceiveName;
invoice.ReceivePhone = ro.ReceivePhone;
invoice.ROID = ro.ROID;
invoice.ROSysNo = ro.SysNo;
ShipTypeInfo stInfo = ASPManager.GetInstance().LoadShipType(so.ShipTypeSysNo);
invoice.ShipTypeName = stInfo.ShipTypeName;
UserInfo employee = SysManager.GetInstance().LoadUser(so.OutUserSysNo);
if (employee != null)
{
invoice.WarehouseUserCode = employee.UserID;
}
else
{
invoice.WarehouseUserCode = "";
}
this.InitPageList(ro, invoice);
invoice.TotalPage = invoice.ItemHash.Count;
invoice.TotalWeight = ro.GetTotalWeight();
return(invoice);
}
public void CancelReturnRO(ROInfo roInfo)
{
TransactionOptions options = new TransactionOptions();
options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
options.Timeout = TransactionManager.DefaultTimeout;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
{
if (this.GetROCurrentStatus(roInfo.SysNo) != (int)AppEnum.ROStatus.Returned)
{
throw new BizException("This RO is not returned now ,can't cancel return");
}
roInfo.Status = (int)AppEnum.ROStatus.Audited;
//update ro status
Hashtable paramHash = new Hashtable(4);
paramHash.Add("Status", roInfo.Status);
paramHash.Add("ReturnTime", roInfo.ReturnTime);
paramHash.Add("ReturnUserSysNo", roInfo.ReturnUserSysNo);
paramHash.Add("SysNo", roInfo.SysNo);
this.UpdateROMaster(paramHash);
//update inventory
foreach (ROItemInfo roItem in roInfo.ItemHash.Values)
{
//UnitCostManager.GetInstance().SetCost(roItem.ProductSysNo, roItem.Quantity*(-1), roItem.Cost);
UnitCostManager.GetInstance().SetCost(roItem.ReturnSysNo, roItem.Quantity * (-1), roItem.Cost);
InventoryManager.GetInstance().SetInStockQty(roInfo.StockSysNo, roItem.ReturnSysNo, roItem.Quantity * (-1));
}
//update customer score
if (roInfo.PointAmt != 0)
{
RMAInfo oRMA = RMAManager.GetInstance().LoadMaster(roInfo.RMASysNo);
PointManager.GetInstance().SetScore(oRMA.CustomerSysNo, roInfo.PointAmt, (int)AppEnum.PointLogType.CancelReturn, roInfo.SysNo.ToString());
}
//abandon soincome
SOIncomeManager.GetInstance().ROCancelReturn(roInfo.SysNo);
scope.Complete();
}
}
public void AbandonRO(ROInfo roInfo)
{
TransactionOptions options = new TransactionOptions();
options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
options.Timeout = TransactionManager.DefaultTimeout;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
{
if (this.GetROCurrentStatus(roInfo.SysNo) != (int)AppEnum.ROStatus.Origin)
{
throw new BizException("This RO is not origin ,can't abandon");
}
roInfo.Status = (int)AppEnum.ROStatus.Abandon;
Hashtable paramHash = new Hashtable(4);
paramHash.Add("Status", roInfo.Status);
paramHash.Add("ReturnTime", roInfo.CreateTime);
paramHash.Add("ReturnUserSysNo", roInfo.CreateUserSysNo);
paramHash.Add("SysNo", roInfo.SysNo);
this.UpdateROMaster(paramHash);
scope.Complete();
}
}
private void map(ROInfo oParam, DataRow tempdr)
{
oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]);
oParam.ROID = Util.TrimNull(tempdr["ROID"]);
oParam.RMASysNo = Util.TrimIntNull(tempdr["RMASysNo"]);
oParam.StockSysNo = Util.TrimIntNull(tempdr["StockSysNo"]);
oParam.Status = Util.TrimIntNull(tempdr["Status"]);
oParam.OriginCashAmt = Util.TrimDecimalNull(tempdr["OriginCashAmt"]);
oParam.OriginPointAmt = Util.TrimIntNull(tempdr["OriginPointAmt"]);
oParam.RedeemAmt = Util.TrimDecimalNull(tempdr["RedeemAmt"]);
oParam.CashAmt = Util.TrimDecimalNull(tempdr["CashAmt"]);
oParam.PointAmt = Util.TrimIntNull(tempdr["PointAmt"]);
oParam.CreateUserSysNo = Util.TrimIntNull(tempdr["CreateUserSysNo"]);
oParam.CreateTime = Util.TrimDateNull(tempdr["CreateTime"]);
oParam.AuditUserSysNo = Util.TrimIntNull(tempdr["AuditUserSysNo"]);
oParam.AuditTime = Util.TrimDateNull(tempdr["AuditTime"]);
oParam.ReturnUserSysNo = Util.TrimIntNull(tempdr["ReturnUserSysNo"]);
oParam.ReturnTime = Util.TrimDateNull(tempdr["ReturnTime"]);
oParam.ReceiveName = Util.TrimNull(tempdr["ReceiveName"]);
oParam.ReceiveAddress = Util.TrimNull(tempdr["ReceiveAddress"]);
oParam.ReceivePhone = Util.TrimNull(tempdr["ReceivePhone"]);
oParam.Note = Util.TrimNull(tempdr["Note"]);
}
private void InitPageList(ROInfo ro, ROInvoiceInfo invoice)
{
int index = 0;
ROInvoicePageInfo page = new ROInvoicePageInfo();
invoice.ItemHash.Add(index++, page);
Hashtable sysHash = new Hashtable(5);
foreach (ROItemInfo item in ro.ItemHash.Values)
{
sysHash.Add(item.ProductSysNo, null);
}
Hashtable pbHash = ProductManager.GetInstance().GetProductBoundle(sysHash);
foreach (ROItemInfo item in ro.ItemHash.Values)
{
ROInvoicePageItemInfo printItem = new ROInvoicePageItemInfo();
printItem.pk = ((ProductBasicInfo)pbHash[item.ProductSysNo]).ProductID; //add by lucky 2008/04/16
printItem.ProductID = ((ProductBasicInfo)pbHash[item.ProductSysNo]).ProductID;
printItem.ProductName = ((ProductBasicInfo)pbHash[item.ProductSysNo]).ProductName;
printItem.Quantity = item.Quantity * (-1);
printItem.Weight = item.Weight;
printItem.Total = (-1) * item.RefundCash;
printItem.Price = (decimal)(item.RefundCash / item.Quantity);
printItem.isRoItem = true;
if (page.AddItem(printItem) == true)
{
continue;
}
else
{
page = new ROInvoicePageInfo();
page.AddItem(printItem);
invoice.ItemHash.Add(index++, page);
}
sysHash.Add(item.ProductSysNo, null);
}
if (ro.PointAmt != 0)
{
ROInvoicePageItemInfo printItem = new ROInvoicePageItemInfo();
printItem.pk = "影响积分"; //add by lucky 2008/04/16
printItem.ProductID = "影响积分";
printItem.Total = Convert.ToDecimal(ro.PointAmt);
printItem.isRoItem = false;
printItem.isPoint = true;
if (page.AddItem(printItem) == false)
{
page = new ROInvoicePageInfo();
page.AddItem(printItem);
invoice.ItemHash.Add(index++, page);
}
}
if (ro.RedeemAmt != 0)
{
ROInvoicePageItemInfo printItem = new ROInvoicePageItemInfo();
printItem.pk = "补积分"; //add by lucky 2008/04/16
printItem.ProductID = "补积分";
printItem.Total = ro.RedeemAmt;
printItem.isRoItem = false;
if (page.AddItem(printItem) == false)
{
page = new ROInvoicePageInfo();
page.AddItem(printItem);
invoice.ItemHash.Add(index++, page);
}
}
}
public int InsertMaster(ROInfo oParam)
{
string sql = @"INSERT INTO RO_Master
(
SysNo, ROID, RMASysNo, StockSysNo, Status,
OriginCashAmt, OriginPointAmt, RedeemAmt, CashAmt,
PointAmt, CreateUserSysNo, AuditUserSysNo,
AuditTime, ReturnUserSysNo, ReturnTime, ReceiveName, ReceiveAddress,
ReceivePhone, Note
)
VALUES (
@SysNo, @ROID, @RMASysNo, @StockSysNo, @Status,
@OriginCashAmt, @OriginPointAmt, @RedeemAmt, @CashAmt,
@PointAmt, @CreateUserSysNo, @AuditUserSysNo,
@AuditTime, @ReturnUserSysNo, @ReturnTime, @ReceiveName, @ReceiveAddress,
@ReceivePhone, @Note
)";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramROID = new SqlParameter("@ROID", SqlDbType.NVarChar, 20);
SqlParameter paramRMASysNo = new SqlParameter("@RMASysNo", SqlDbType.Int, 4);
SqlParameter paramStockSysNo = new SqlParameter("@StockSysNo", SqlDbType.Int, 4);
SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4);
SqlParameter paramOriginCashAmt = new SqlParameter("@OriginCashAmt", SqlDbType.Decimal, 9);
SqlParameter paramOriginPointAmt = new SqlParameter("@OriginPointAmt", SqlDbType.Int, 4);
SqlParameter paramRedeemAmt = new SqlParameter("@RedeemAmt", SqlDbType.Decimal, 9);
SqlParameter paramCashAmt = new SqlParameter("@CashAmt", SqlDbType.Decimal, 9);
SqlParameter paramPointAmt = new SqlParameter("@PointAmt", SqlDbType.Int, 4);
SqlParameter paramCreateUserSysNo = new SqlParameter("@CreateUserSysNo", SqlDbType.Int, 4);
SqlParameter paramAuditUserSysNo = new SqlParameter("@AuditUserSysNo", SqlDbType.Int, 4);
SqlParameter paramAuditTime = new SqlParameter("@AuditTime", SqlDbType.DateTime);
SqlParameter paramReturnUserSysNo = new SqlParameter("@ReturnUserSysNo", SqlDbType.Int, 4);
SqlParameter paramReturnTime = new SqlParameter("@ReturnTime", SqlDbType.DateTime);
SqlParameter paramReceiveName = new SqlParameter("@ReceiveName", SqlDbType.NVarChar, 20);
SqlParameter paramReceiveAddress = new SqlParameter("@ReceiveAddress", SqlDbType.NVarChar, 200);
SqlParameter paramReceivePhone = new SqlParameter("@ReceivePhone", SqlDbType.NVarChar, 20);
SqlParameter paramNote = new SqlParameter("@Note", SqlDbType.NVarChar, 500);
if (oParam.SysNo != AppConst.IntNull)
{
paramSysNo.Value = oParam.SysNo;
}
else
{
paramSysNo.Value = System.DBNull.Value;
}
if (oParam.ROID != AppConst.StringNull)
{
paramROID.Value = oParam.ROID;
}
else
{
paramROID.Value = System.DBNull.Value;
}
if (oParam.RMASysNo != AppConst.IntNull)
{
paramRMASysNo.Value = oParam.RMASysNo;
}
else
{
paramRMASysNo.Value = System.DBNull.Value;
}
if (oParam.StockSysNo != AppConst.IntNull)
{
paramStockSysNo.Value = oParam.StockSysNo;
}
else
{
paramStockSysNo.Value = System.DBNull.Value;
}
if (oParam.Status != AppConst.IntNull)
{
paramStatus.Value = oParam.Status;
}
else
{
paramStatus.Value = System.DBNull.Value;
}
if (oParam.OriginCashAmt != AppConst.DecimalNull)
{
paramOriginCashAmt.Value = oParam.OriginCashAmt;
}
else
{
paramOriginCashAmt.Value = System.DBNull.Value;
}
if (oParam.OriginPointAmt != AppConst.IntNull)
{
paramOriginPointAmt.Value = oParam.OriginPointAmt;
}
else
{
paramOriginPointAmt.Value = System.DBNull.Value;
}
if (oParam.RedeemAmt != AppConst.DecimalNull)
{
paramRedeemAmt.Value = oParam.RedeemAmt;
}
else
{
paramRedeemAmt.Value = System.DBNull.Value;
}
if (oParam.CashAmt != AppConst.DecimalNull)
{
paramCashAmt.Value = oParam.CashAmt;
}
else
{
paramCashAmt.Value = System.DBNull.Value;
}
if (oParam.PointAmt != AppConst.IntNull)
{
paramPointAmt.Value = oParam.PointAmt;
}
else
{
paramPointAmt.Value = System.DBNull.Value;
}
if (oParam.CreateUserSysNo != AppConst.IntNull)
{
paramCreateUserSysNo.Value = oParam.CreateUserSysNo;
}
else
{
paramCreateUserSysNo.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.ReturnUserSysNo != AppConst.IntNull)
{
paramReturnUserSysNo.Value = oParam.ReturnUserSysNo;
}
else
{
paramReturnUserSysNo.Value = System.DBNull.Value;
}
if (oParam.ReturnTime != AppConst.DateTimeNull)
{
paramReturnTime.Value = oParam.ReturnTime;
}
else
{
paramReturnTime.Value = System.DBNull.Value;
}
if (oParam.ReceiveName != AppConst.StringNull)
{
paramReceiveName.Value = oParam.ReceiveName;
}
else
{
paramReceiveName.Value = System.DBNull.Value;
}
if (oParam.ReceiveAddress != AppConst.StringNull)
{
paramReceiveAddress.Value = oParam.ReceiveAddress;
}
else
{
paramReceiveAddress.Value = System.DBNull.Value;
}
if (oParam.ReceivePhone != AppConst.StringNull)
{
paramReceivePhone.Value = oParam.ReceivePhone;
}
else
{
paramReceivePhone.Value = System.DBNull.Value;
}
if (oParam.Note != AppConst.StringNull)
{
paramNote.Value = oParam.Note;
}
else
{
paramNote.Value = System.DBNull.Value;
}
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramROID);
cmd.Parameters.Add(paramRMASysNo);
cmd.Parameters.Add(paramStockSysNo);
cmd.Parameters.Add(paramStatus);
cmd.Parameters.Add(paramOriginCashAmt);
cmd.Parameters.Add(paramOriginPointAmt);
cmd.Parameters.Add(paramRedeemAmt);
cmd.Parameters.Add(paramCashAmt);
cmd.Parameters.Add(paramPointAmt);
cmd.Parameters.Add(paramCreateUserSysNo);
cmd.Parameters.Add(paramAuditUserSysNo);
cmd.Parameters.Add(paramAuditTime);
cmd.Parameters.Add(paramReturnUserSysNo);
cmd.Parameters.Add(paramReturnTime);
cmd.Parameters.Add(paramReceiveName);
cmd.Parameters.Add(paramReceiveAddress);
cmd.Parameters.Add(paramReceivePhone);
cmd.Parameters.Add(paramNote);
return(SqlHelper.ExecuteNonQuery(cmd));
}
public void Import()
{
string sql = @"select top 1 * from ro_master;
select top 1 * from ro_item;" ;
DataSet ds = SqlHelper.ExecuteDataSet(sql);
foreach (DataTable dt in ds.Tables)
{
if (Util.HasMoreRow(dt))
{
throw new BizException("The target is not empty");
}
}
TransactionOptions options = new TransactionOptions();
options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
options.Timeout = TransactionManager.DefaultTimeout;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
{
//Insert Master
string sqlDataCleanUp = @"--更新空的退货单创建人为审核人
update ipp2003..ut_master set utusersysno = approversysno where utusersysno =-999" ;
new ProductSaleTrendDac().Exec(sqlDataCleanUp);
string sqlMaster = @"select um.sysno,utid as roid,rmasysno,stock.newsysno as stocksysno,redeemamt,cashamt as origincashamt,pointamt as originpointamt,
(cashamt-redeemamt/10) as cashamt,(pointamt+redeemamt) as pointamt,suct.newsysno as createusersysno,uttime as createtime,
suap.newsysno as auditusersysno ,approvetime as audittime,receiveaddress,receivephone,memo as note,um.status,um.customname as receivename
from ipp2003..ut_master um
left join ippconvert..stock stock on stock.oldsysno = um.warehousesysno
left join ippconvert..sys_user suct on suct.oldsysno = um.utusersysno
left join ippconvert..sys_user suap on suap.oldsysno = um.approversysno" ;
DataSet dsMaster = SqlHelper.ExecuteDataSet(sqlMaster);
if (Util.HasMoreRow(dsMaster))
{
foreach (DataRow dr in dsMaster.Tables[0].Rows)
{
ROInfo oRO = new ROInfo();
oRO.SysNo = Util.TrimIntNull(dr["SysNo"]);
oRO.ROID = Util.TrimNull(dr["ROID"]);
oRO.RMASysNo = Util.TrimIntNull(dr["RMASysNo"]);
oRO.StockSysNo = Util.TrimIntNull(dr["StockSysNo"]);
switch (Util.TrimIntNull(dr["Status"]))
{
case -1: //作废
oRO.Status = (int)AppEnum.ROStatus.Abandon;
break;
case 0: //未审核，可修改
oRO.Status = (int)AppEnum.ROStatus.Origin;
break;
case 1: //待审核
oRO.Status = (int)AppEnum.ROStatus.Origin;
break;
case 2: //已审核
oRO.Status = (int)AppEnum.ROStatus.Audited;
break;
case 3: //已退货
oRO.Status = (int)AppEnum.ROStatus.Returned;
break;
}
oRO.OriginCashAmt = Util.TrimDecimalNull(dr["OriginCashAmt"]);
oRO.OriginPointAmt = Util.TrimIntNull(dr["OriginPointAmt"]);
oRO.RedeemAmt = Util.TrimDecimalNull(dr["RedeemAmt"]);
oRO.CashAmt = Util.TrimDecimalNull(dr["CashAmt"]);
oRO.PointAmt = Util.TrimIntNull(dr["PointAmt"]);
oRO.CreateUserSysNo = Util.TrimIntNull(dr["CreateUserSysNo"]);
oRO.CreateTime = Util.TrimDateNull(dr["CreateTime"]);
oRO.AuditUserSysNo = Util.TrimIntNull(dr["AuditUserSysNo"]);
oRO.AuditTime = Util.TrimDateNull(dr["AuditTime"]);
oRO.ReceiveName = Util.TrimNull(dr["ReceiveName"]);
oRO.ReceiveAddress = Util.TrimNull(dr["ReceiveAddress"]);
oRO.ReceivePhone = Util.TrimNull(dr["ReceivePhone"]);
oRO.Note = Util.TrimNull(dr["Note"]);
new RODac().InsertMaster(oRO);
}
}
//Insert Item
string sqlItem = @"select 1 as sysno ,utsysno as rosysno,pb.newsysno as productsysno,2 as returntype,pb.newsysno as returnsysno,quantity,price,cost,weight,returnpoint as point,
isnull(refundcash,0) as refundcash,isnull(refundpoint,0) as refundpoint
from ipp2003..ut_item ui
left join ippconvert..productbasic pb on pb.oldsysno = ui.productsysno" ;
DataSet dsItem = SqlHelper.ExecuteDataSet(sqlItem);
if (Util.HasMoreRow(dsItem))
{
foreach (DataRow dr in dsItem.Tables[0].Rows)
{
ROItemInfo oROItem = new ROItemInfo();
map(oROItem, dr);
new RODac().InsertItem(oROItem);
}
}
//Insert Sequence
string sqlMaxSysNo = @"select max(sysno) as sysno from rma_master";
DataSet dsMaxSysNo = SqlHelper.ExecuteDataSet(sqlMaxSysNo);
int n = 0;
while (n < Util.TrimIntNull(dsMaxSysNo.Tables[0].Rows[0][0]))
{
n = SequenceDac.GetInstance().Create("RO_Sequence");
}
scope.Complete();
}
}