/// <summary>
/// 获取退货单的详细信息并保存到数据库
/// </summary>
/// <param name="tradeRefundList"></param>
/// <param name="refundIDList"></param>
public void GetNewRefundDetail(string session, List <Alading.Entity.TradeRefund> tradeRefundList, List <string> refundIDList)
{
//存放数据库中不存在的退货详细信息
List <Alading.Entity.TradeRefund> newRefundList = new List <Alading.Entity.TradeRefund>();
List <Alading.Entity.TradeRefund> oldRefundList = TradeRefundService.GetTradeRefund(refundIDList);
foreach (Alading.Entity.TradeRefund tradeRefund in tradeRefundList)
{
Alading.Entity.TradeRefund oldRefund = oldRefundList.Find(c => c.refund_id == tradeRefund.refund_id);
if (oldRefund != null)//数据库中已存在此数据
{
continue;
}
else//不存在则取淘宝网获取
{
TradeRsp tradeRsp = TopService.RefundGet(session, tradeRefund.refund_id);
/*未获取到数据*/
if (tradeRsp == null)
{
continue;
}
oldRefund = new TradeRefund();
oldRefund.modified = tradeRefund.modified;
oldRefund.order_status = tradeRefund.order_status;
TradeRefundCopyData(oldRefund, tradeRsp.Refund);
newRefundList.Add(oldRefund);
}
}
TradeRefundService.AddTradeRefund(newRefundList);
}
/// <summary>
/// 加载界面
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void SelledReturnIn_Load(object sender, EventArgs e)
{
try
{
inoutHelper = new InOutHelper();
dTable = new DataTable();
skuOuterIDList = new List <string>();
//显示当前入库日期
dateEditInTime.Text = DateTime.Now.ToShortDateString();
//加载展示信息
AddColumns(dTable);
//从数据库获取并展示数据
List <Alading.Entity.View_RefundTradeStock> tradeRefundList = TradeRefundService.GetTradeRefundByView(c => c.LocalStatus == LocalTradeStatus.SentNotRate &&
c.IsRecieved == false);
LoadTradeRefund(tradeRefundList);
/*加载所有仓库*/
inoutHelper.LoadAllHouse(repositoryItemComboBoxStockHouse);
gvReturnInProduct.BestFitColumns();
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message, Constants.SYSTEM_PROMPT, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// 点击刷新按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void barBtnRefresh_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
WaitDialogForm waitFrm = new WaitDialogForm(Constants.WAIT_LOAD_DATA);
try
{
//从数据库获取并展示数据
List <Alading.Entity.View_RefundTradeStock> tradeRefundList = TradeRefundService.GetTradeRefundByView(c => c.LocalStatus == LocalTradeStatus.SentNotRate &&
c.IsRecieved == false);
LoadTradeRefund(tradeRefundList);
waitFrm.Close();
}
catch (Exception ex)
{
waitFrm.Close();
XtraMessageBox.Show(ex.Message, Constants.SYSTEM_PROMPT, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// 点击更新按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void barBtnDownLoad_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
WaitDialogForm waitFrm = new WaitDialogForm(Constants.WAIT_LOAD_DATA);
try
{
#region 获取全部淘宝店铺的淘宝会员号
List <Alading.Entity.Shop> shopBList = ShopService.GetShop(c => c.ShopType == (int)ShopType.TaobaoBShop);
List <Alading.Entity.Shop> shopCList = ShopService.GetShop(c => c.ShopType == (int)ShopType.TaobaoCShop);
List <string> sessionKeyList = new List <string>();
foreach (Alading.Entity.Shop shop in shopBList)
{
sessionKeyList.Add(Alading.Utils.SystemHelper.GetSessionKey(shop.nick));
}
foreach (Alading.Entity.Shop shop in shopCList)
{
sessionKeyList.Add(Alading.Utils.SystemHelper.GetSessionKey(shop.nick));
}
#endregion
foreach (string sessionKey in sessionKeyList)//获取全部淘宝店铺的数据
{
/*获取未评价数据*/
int totalResults = 0;
int pageSize = 100;
int totalPageNo = 0;
/*用于存放从淘宝上获取回的数据*/
List <Alading.Entity.TradeRefund> tradeRefundList = new List <Alading.Entity.TradeRefund>();
//存放退货单编号
List <string> refundIDList = new List <string>();
GetNewTradeRefund(sessionKey, 1, pageSize, out totalResults, tradeRefundList, refundIDList);
if (totalResults % totalResults == 0)//能除尽
{
totalPageNo = totalResults / totalResults;
}
else//不能除尽
{
totalPageNo = totalResults / totalResults + 1;
}
/*超过两页的循环调取数据*/
for (int pageno = 2; pageno <= totalPageNo; pageno++)
{
GetNewTradeRefund(sessionKey, pageno, pageSize, out totalResults, tradeRefundList, refundIDList);
}
//以消除数据库中已存在的数据
GetNewRefundDetail(sessionKey, tradeRefundList, refundIDList);
}
//从数据库获取并展示数据
List <Alading.Entity.View_RefundTradeStock> refundList = TradeRefundService.GetTradeRefundByView(c => c.LocalStatus == LocalTradeStatus.SentNotRate &&
c.IsRecieved == false);
LoadTradeRefund(refundList);
waitFrm.Close();
XtraMessageBox.Show("从淘宝网获取数据成功", Constants.SYSTEM_PROMPT, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
waitFrm.Close();
XtraMessageBox.Show(ex.Message, Constants.SYSTEM_PROMPT, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// 保存操作
/// </summary>
public bool SaveRefund()
{
//出入库时间
if (string.IsNullOrEmpty(dateEditInTime.Text))
{
XtraMessageBox.Show("请填写入库日期", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
dateEditInTime.Focus();
return(false);
}
//业务员及编号
if (string.IsNullOrEmpty(pceOperator.Text))
{
XtraMessageBox.Show("请填写业务员", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
pceOperator.Focus();
return(false);
}
//用于存放需要退货入库的订单的退款单号
List <string> refundIDList = new List <string>();
//用于存放oid,以通过View_RefundTradeStock获取sku_outerID
List <string> oidList = new List <string>();
//存放修要修改库存的sku_outer_id
List <string> outerSkuIdList = new List <string>();
//存放修要修改库存的outer_id
List <string> outerIdList = new List <string>();
//用于存放需要更新的StockProduct数据
List <StockProduct> stockProductList = new List <StockProduct>();
//用于存放要保存到数据库的StockHouseProduct
List <Alading.Entity.StockHouseProduct> stockHouseProList = new List <StockHouseProduct>();
//存放StockDetail
List <Alading.Entity.StockDetail> stockDetailList = new List <Alading.Entity.StockDetail>();
//入库单编号
string inOutCode = string.Empty;
if (!string.IsNullOrEmpty(textEditInOutCode.Text))
{
inOutCode = textEditInOutCode.Text.Trim();
if (inoutHelper.ExistInOutCode(inOutCode))
{
XtraMessageBox.Show("此单号已存在", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
textEditInOutCode.Focus();
return(false);
}
}
else
{
inOutCode = Guid.NewGuid().ToString();
}
for (int index = 0; index < gvReturnInProduct.RowCount; index++)
{
DataRow dataRow = gvReturnInProduct.GetDataRow(index);
if (dataRow["Select"].ToString() == true.ToString())
{
if (dataRow["HouseName"] == null || string.IsNullOrEmpty(dataRow["HouseName"].ToString()))
{
XtraMessageBox.Show("需要选择仓库", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return(false);
}
if (dataRow["LayoutName"] == null || string.IsNullOrEmpty(dataRow["LayoutName"].ToString()))
{
XtraMessageBox.Show("需要选择库位", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return(false);
}
refundIDList.Add(dataRow["refund_id"].ToString());
oidList.Add(dataRow["oid"].ToString());
#region 保存StockProduct信息
outerSkuIdList.Add(dataRow["outer_sku_id"].ToString());
outerIdList.Add(dataRow["OuterID"].ToString());
StockProduct newStockPro = new StockProduct();
newStockPro.SkuOuterID = dataRow["outer_sku_id"].ToString();
newStockPro.OuterID = dataRow["OuterID"].ToString();
//入库数量
if (string.IsNullOrEmpty(dataRow["Count"].ToString()))
{
newStockPro.SkuQuantity = 0;
}
else
{
newStockPro.SkuQuantity = int.Parse(dataRow["Count"].ToString());
}
stockProductList.Add(newStockPro);
#endregion
#region 添加或更新StockHouseProduct
StockHouseProduct stockHousePro = new StockHouseProduct();
stockHousePro.HouseCode = dataRow["HouseCode"] == null ? string.Empty : dataRow["HouseCode"].ToString();
stockHousePro.LayoutCode = dataRow["LayoutCode"] == null ? string.Empty : dataRow["LayoutCode"].ToString();
stockHousePro.SkuOuterID = newStockPro.SkuOuterID;
stockHousePro.Num = newStockPro.SkuQuantity;
stockHousePro.HouseName = dataRow["HouseName"].ToString();
stockHousePro.LayoutName = dataRow["LayoutName"].ToString();
stockHouseProList.Add(stockHousePro);
#endregion
#region 保存StockDetail
Alading.Entity.StockDetail stockDetail = new StockDetail();
stockDetail.StockDetailCode = Guid.NewGuid().ToString();
stockDetail.ProductSkuOuterId = dataRow["outer_sku_id"].ToString();
stockDetail.InOutCode = inOutCode;
//仓库编号
if (dataRow["HouseCode"] == null)
{
stockDetail.StockHouseCode = string.Empty;
}
else
{
stockDetail.StockHouseCode = dataRow["HouseCode"].ToString();
}
//库位编号
if (dataRow["LayoutCode"] == null)
{
stockDetail.StockLayOutCode = string.Empty;
}
else
{
stockDetail.StockLayOutCode = dataRow["LayoutCode"].ToString();
}
//商品价格price
stockDetail.Price = float.Parse(dataRow["price"].ToString());
stockDetail.Quantity = int.Parse(dataRow["Count"].ToString());
stockDetail.DetailType = (int)InOutType.SelledReturnIn;
stockDetail.DetailRemark = string.Empty;
stockDetail.Tax = string.Empty;
stockDetail.TotalFee = dataRow["payment"] == null?0:float.Parse(dataRow["payment"].ToString());
stockDetail.DurabilityDate = DateTime.Parse(DateTime.Now.ToShortDateString());
stockDetailList.Add(stockDetail);
#endregion
}
}
if (refundIDList.Count == 0)
{
XtraMessageBox.Show("请先勾选数据", "系统提示", MessageBoxButtons.OK
, MessageBoxIcon.Information);
return(false);
}
/*销售退货时间，仓库，库位要求必须填写*/
#region 将要更新的数据保存到oldRefundList
List <Alading.Entity.TradeRefund> oldRefundList = TradeRefundService.GetTradeRefund(refundIDList);
//用于保存等待更新到数据库表TradeRefund的数据
List <Alading.Entity.TradeRefund> refundUpdateList = new List <Alading.Entity.TradeRefund>();
//修改StockRefund中的IsRecieved 和 LocalPrivyC的状态
foreach (string refundId in refundIDList)
{
Alading.Entity.TradeRefund refund = new TradeRefund();
refund.refund_id = refundId;
//记录当前库管是否收到从买家发回的货物
refund.IsRecieved = true;
//经办人
refund.LocalPrivyC = pceOperator.Text;
refundUpdateList.Add(refund);
}
#endregion
#region 更新StockInOut
string InOutTime = dateEditInTime.Text;
//用于存放StockInOut
List <Alading.Entity.StockInOut> stockInOutList = new List <Alading.Entity.StockInOut>();
//添加到StockInOut
Alading.Entity.StockInOut stockInOut = new Alading.Entity.StockInOut();
stockInOut.InOutCode = inOutCode; //进出库单编号
stockInOut.InOutTime = DateTime.Parse(InOutTime); //进出库时间
stockInOut.OperatorName = pceOperator.Text == null ? string.Empty : pceOperator.Text;
stockInOut.OperatorCode = pceOperator.Tag.ToString();
stockInOut.InOutType = (int)InOutType.SelledReturnIn;
//oid赋值
stockInOut.TradeOrderCode = string.Empty;;
stockInOut.DiscountFee = 0;
//保存应付应收金额
if (string.IsNullOrEmpty(textEditTotalFee.EditValue.ToString()))
{
stockInOut.DueFee = 0;
}
else
{
stockInOut.DueFee = float.Parse(textEditTotalFee.EditValue.ToString());
}
stockInOut.InOutStatus = (int)InOutStatus.AllRefund;
stockInOut.IsSettled = true;
stockInOut.PayType = 0;//付款方式
stockInOut.PayThisTime = string.IsNullOrEmpty(textEditTotalFee.EditValue.ToString()) ? 0 : float.Parse(textEditTotalFee.EditValue.ToString());
stockInOut.PayTerm = 0;
stockInOut.IncomeTime = DateTime.Parse(DateTime.Now.ToShortDateString());;
stockInOut.AmountTax = 0;
stockInOut.FreightCompany = string.Empty;
stockInOut.FreightCode = string.Empty;
stockInOutList.Add(stockInOut);
#endregion
#region 添加PayCharge
PayCharge payCharge = new PayCharge();
payCharge.PayChargeCode = Guid.NewGuid().ToString();
payCharge.PayChargeType = 0;
payCharge.InOutCode = inOutCode;
payCharge.PayerCode = string.Empty;
payCharge.PayerName = string.Empty;
payCharge.ChargerCode = string.Empty;
payCharge.ChargerName = string.Empty;
payCharge.OperateTime = DateTime.Parse(dateEditInTime.Text);
payCharge.OperatorCode = pceOperator.Tag.ToString();
payCharge.OperatorName = pceOperator.Text;
payCharge.PayChargeRemark = string.Empty;
if (!string.IsNullOrEmpty(textEditTotalFee.Text))
{
payCharge.TotalFee = double.Parse(textEditTotalFee.EditValue.ToString());
}
else
{
payCharge.TotalFee = 0.0;
}
payCharge.NeedToPay = 0.0;
payCharge.AmountTax = 0.0;
payCharge.PayThisTime = payCharge.TotalFee;
payCharge.DiscountFee = 0.0;
payCharge.IncomeDay = 0;
payCharge.IncomeTime = DateTime.MinValue;
#endregion
//更新Refund StockProduct StockItem StockInOut StockDetail
TradeRefundService.UpdateTradeRefund(refundUpdateList, stockProductList, stockHouseProList, stockInOutList, stockDetailList
, payCharge, refundIDList, outerSkuIdList, outerIdList);
return(true);
}
