public List <StockDetailDTO> GetStockDetailHeadQ(Int32 HeaderID)
{
List <StockDetailDTO> lst = new List <StockDetailDTO>();
try
{
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter()
{
ParameterName = "StockHeaderID", Value = HeaderID
});
DataSet ds = conn.GetDataSet("GetStockDetailHeadQ", param);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0] != null)
{
StockDetailDTO o = new StockDetailDTO();
foreach (DataRow dr in ds.Tables[0].Rows)
{
o = new StockDetailDTO();
o.StockHeaderID = Convert.ToInt32(dr["StockHeadQHeaderID"].ToString());
o.StockDetailID = Convert.ToInt32(dr["StockHeadQDetailID"].ToString());
o.ProductID = Convert.ToInt32(dr["ProductID"].ToString());
o.Amount = Convert.ToInt32(dr["Amount"].ToString());
o.ProductCode = dr["ProductCode"].ToString();
o.ProductName = dr["ProductName"].ToString();
lst.Add(o);
}
}
}
catch (Exception ex)
{
}
return(lst);
}
public void UpdateStorageRecord()
{
var flag = false;
var stockList = _storageManager.GetStorageRecordListByOriginalCode("04SPH1408270940");
var stockInfo = stockList.FirstOrDefault(act => act.StockState == (int)StorageState.Pass);
if (stockInfo != null && stockInfo.StockId != Guid.Empty)
{
var stockDtailList = _storageManager.GetStorageRecordDetailListByStockId(stockInfo.StockId);
//联盟店生成调拨出库 异常差额 已审核
var allianceOutStorage = new StockDTO()
{
CompanyID = new Guid(""),
DateCreated = DateTime.Now,
Description = "调拨异常差额出库",
OriginalTradeCode = ""
};
var allianceOutStorageDetails = new List <StockDetailDTO>();
//ERP生成调拨入库 异常差额 已审核
var erpInStoreageInfo = new StorageRecordInfo();
var erpInStorageDetails = new List <StorageRecordDetailInfo>();
foreach (var storageRecordDetailInfo in stockDtailList)
{
storageRecordDetailInfo.Quantity = storageRecordDetailInfo.Quantity + 1;
var detail = storageRecordDetailInfo.DeepCopy() as StorageRecordDetailInfo;
var detailDto = new StockDetailDTO();
erpInStorageDetails.Add(detail);
allianceOutStorageDetails.Add(detailDto);
}
using (var ts = new TransactionScope(TransactionScopeOption.Required))
{
//修改原调拨出库单据
string msg;
_storageManager.InsertStockAndGoods(erpInStoreageInfo, erpInStorageDetails);
ShopSao.InsertStock(allianceOutStorage.StockID, allianceOutStorage, allianceOutStorageDetails, false, null, 0,
out msg);
var result = _target.UpdateApplyStockState(new Guid("842B65D2-3892-43DA-8BE5-99B0F8F0E68D"), (int)ApplyStockState.Pended, false, out msg);
if (result)
{
ts.Complete();
}
}
}
Assert.IsTrue(flag);
}
