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();
}
}
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 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 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();
}
}
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);
}
}
}
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 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 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();
}
}
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
//�˻�ʱ��Ӱ��һ����Ʒ�ijɱ���ֻ��Ҫ�Ķ�����Ʒ�ijɱ�
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 LoadROfromRMA(int rmaSysNo)
{
string sqlMaster = @"select * from ro_master where status <> " + (int)AppEnum.RMAStatus.Abandon + " and rmasysno =" + rmaSysNo;
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 =" + rmaSysNo;
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 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();
}
}
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 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;
}
