private void DeleteZeroRow()
{
if (gridView1.GetSelectedRows().Length > 1)
{
MsgBox.Warn("只允许逐行删除。");
return;
}
//为了减少出错，只允许一行一行删除
StockRecordEntity s = SelectedStockRecord;
if (s == null)
{
MsgBox.Warn("请选中要删除的行。");
return;
}
//必须是库存为0，占用为0
if (s.Qty != 0 || s.PickingQty != 0 || s.OccupyQty != 0)
{
MsgBox.Warn("总库存、拣货中与占用中必须全部为0，才可以删除。");
return;
}
try
{
bool result = DeleteStock(s.StockID);
//if (result == -1)
// MsgBox.Warn("该行库存未查到，可能已经被其他人删除。");
//else if (result == -2)
// MsgBox.Warn("总库存、拣货中与占用中必须全部为0，才可以删除。");
//else
if (result)
{
gridView1.DeleteRow(gridView1.FocusedRowHandle);
MsgBox.OK("删除成功。");
}
//int result = DeleteStock(s.StockID);
//if (result == -1)
// MsgBox.Warn("该行库存未查到，可能已经被其他人删除。");
//else if (result == -2)
// MsgBox.Warn("总库存、拣货中与占用中必须全部为0，才可以删除。");
//else
//{
// gridView1.DeleteRow(gridView1.FocusedRowHandle);
// MsgBox.OK("删除成功。");
//}
Insert(ELogType.库存, GlobeSettings.LoginedUser.UserName, ConvertUtil.ToString(s.StockID), ConvertUtil.ToString(result), "库存查询", JsonConvert.SerializeObject(s));
}
catch (Exception ex)
{
MsgBox.Err(ex.Message);
}
}
private void OnItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
StockRecordEntity s = SelectedStockRecord;
string tag = ConvertUtil.ToString(e.Item.Tag);
if (tag == "查看商品库存信息")
{
FrmStockSKU frmStockSKU = new FrmStockSKU();
frmStockSKU.Show();
return;
}
else if (tag == "台账记录")
{
FrmSkuLog frmLog = null;
if (s == null)
{
frmLog = new FrmSkuLog();
}
else
{
frmLog = new FrmSkuLog(s.StockID);
}
frmLog.ShowDialog();
return;
}
if (s == null)
{
MsgBox.Warn("请选中要查看的行。");
return;
}
switch (tag)
{
case "台账记录":
break;
case "占用记录":
FrmPickingScan frmPickingScan = new FrmPickingScan(s.StockID);
frmPickingScan.ShowDialog();
break;
case "删除0库存行":
DeleteZeroRow();
break;
}
}
public int DeleteStock(int stockID)
{
//先查看是否数量全部为0
StockRecordEntity s = FindStock(stockID);
if (s == null)
{
return(-1);
}
else if (s.Qty != 0 || s.PickingQty != 0 || s.OccupyQty != 0)
{
return(-2);
}
else
{
string sql = "DELETE FROM WM_STOCK WHERE ID = @StockID";
IMapper map = DatabaseInstance.Instance();
return(map.Execute(sql, new { StockID = stockID }));
}
}
private void barBtnSkuFlag_ItemClick(object sender, ItemClickEventArgs e)
{
FrmChooseBaseCode frm = new FrmChooseBaseCode("130", "商品标记");
if (gridView1.SelectedRowsCount < 1)
{
MsgBox.Warn("请要修改的行！");
return;
}
if (frm.ShowDialog() == DialogResult.OK)
{
int[] index_array = gridView1.GetSelectedRows();
BaseCodeEntity _selectedBaseCode = frm.cboVehicle.EditValue as BaseCodeEntity;
foreach (int index in index_array)
{
StockRecordEntity stock = gridView1.GetRow(index) as StockRecordEntity;
int code = ConvertUtil.ToInt(_selectedBaseCode.ItemValue.ToString());
UpdateSkuQuality(code, stock.StockID);
}
Query();
}
}
/// <summary>
/// 当前订单量（加载报警窗体）
/// </summary>
/// <returns></returns>
public List <StockRecordEntity> QueryStockWarm()
{
List <StockRecordEntity> temp = new List <StockRecordEntity>();
try
{
#region 请求数据
System.Text.StringBuilder loStr = new System.Text.StringBuilder();
string jsons = string.Empty;
string jsonQuery = WebWork.SendRequest(jsons, WebWork.URL_QueryStockWarm);
if (string.IsNullOrEmpty(jsonQuery))
{
MsgBox.Warn(WebWork.RESULT_NULL);
//LogHelper.InfoLog(WebWork.RESULT_NULL);
return(temp);
}
#endregion
#region 正常错误处理
JsonQueryStockWarm bill = JsonConvert.DeserializeObject <JsonQueryStockWarm>(jsonQuery);
if (bill == null)
{
MsgBox.Warn(WebWork.JSON_DATA_NULL);
return(temp);
}
if (bill.flag != 0)
{
MsgBox.Warn(bill.error);
return(temp);
}
#endregion
#region 赋值数据
foreach (JsonQueryStockWarmResult jbr in bill.result)
{
StockRecordEntity asnEntity = new StockRecordEntity();
#region 0-10
asnEntity.ExpDays = Convert.ToInt32(jbr.expDays);
asnEntity.StockID = Convert.ToInt32(jbr.id);
asnEntity.Location = jbr.lcCode;
asnEntity.OccupyQty = Convert.ToDecimal(jbr.occupyQty);
asnEntity.PickingQty = Convert.ToDecimal(jbr.pickingQty);
asnEntity.Qty = Convert.ToDecimal(jbr.qty);
asnEntity.Material = jbr.skuCode;
asnEntity.MaterialName = jbr.skuName;
asnEntity.Spec = jbr.spec;
asnEntity.UnitName = jbr.umName;
asnEntity.ZoneName = jbr.znName;
#endregion
#region
try
{
if (!string.IsNullOrEmpty(jbr.expDate))
{
asnEntity.ExpDate = Convert.ToDateTime(jbr.expDate);
}
}
catch (Exception msg)
{
MsgBox.Warn(msg.Message);
//LogHelper.errorLog("FrmVehicle+QueryNotRelatedBills", msg);
}
#endregion
#region
try
{
if (!string.IsNullOrEmpty(jbr.latestIn))
{
asnEntity.LastInDate = Convert.ToDateTime(jbr.latestIn);
}
}
catch (Exception msg)
{
MsgBox.Warn(msg.Message);
//LogHelper.errorLog("FrmVehicle+QueryNotRelatedBills", msg);
}
#endregion
#region
try
{
if (!string.IsNullOrEmpty(jbr.latestOut))
{
asnEntity.LastOutDate = Convert.ToDateTime(jbr.latestOut);
}
}
catch (Exception msg)
{
MsgBox.Warn(msg.Message);
//LogHelper.errorLog("FrmVehicle+QueryNotRelatedBills", msg);
}
#endregion
temp.Add(asnEntity);
}
return(temp);
#endregion
}
catch (Exception ex)
{
MsgBox.Err(ex.Message);
}
return(temp);
}
public FrmInventory(StockRecordEntity Entity)
: this()
{
this.StockRecord = Entity;
}
public FrmComMaterialSplit(StockRecordEntity stockEntity)
{
InitializeComponent();
this.stockEntity = stockEntity;
this.Text = this.Text + string.Format("({0})", stockEntity.Material);
}
public List <StockRecordEntity> QueryStock(string location, string materialName, bool withZeroQty, int nums, int begin, out int total)
{
List <StockRecordEntity> list = new List <StockRecordEntity>();
total = 0;
try
{
// watch.Start();
#region 请求数据
System.Text.StringBuilder loStr = new System.Text.StringBuilder();
loStr.Append("location=").Append(location).Append("&");
loStr.Append("materialName=").Append(materialName).Append("&");
if (begin == 0)
{
loStr.Append("startPage=").Append("&");
}
else
{
loStr.Append("startPage=").Append(begin).Append("&");
}
if (nums == 0)
{
loStr.Append("pageSize=").Append("&");
}
else
{
loStr.Append("pageSize=").Append(nums).Append("&");
}
loStr.Append("withZeroQty=").Append(withZeroQty);
string jsonQuery = WebWork.SendRequest(loStr.ToString(), WebWork.URL_QueryStock, 20000);
//watch.Stop();
//labSH.Text = string.Format("查询完成：耗时{0}秒", watch.ElapsedMilliseconds / 1000f);
//watch.Reset();
if (string.IsNullOrEmpty(jsonQuery))
{
MsgBox.Warn(WebWork.RESULT_NULL);
//LogHelper.InfoLog(WebWork.RESULT_NULL);
return(list);
}
#endregion
#region 正常错误处理
JsonQueryStock bill = JsonConvert.DeserializeObject <JsonQueryStock>(jsonQuery);
if (bill == null)
{
MsgBox.Warn(WebWork.JSON_DATA_NULL);
return(list);
}
if (bill.flag != 0)
{
MsgBox.Warn(bill.error);
return(list);
}
#endregion
#region 赋值数据
foreach (JsonQueryStockResult jbr in bill.result)
{
StockRecordEntity asnEntity = new StockRecordEntity();
#region 0- 10
asnEntity.ExpDays = Convert.ToInt32(jbr.expDays);
asnEntity.Location = jbr.lcCode;
asnEntity.LocationIsActive = jbr.active;
asnEntity.Material = jbr.skuCode;
asnEntity.MaterialName = jbr.skuName;
asnEntity.OccupyQty = Convert.ToDecimal(jbr.occupyQty);
asnEntity.PickingQty = Convert.ToDecimal(jbr.pickingQty);
asnEntity.Qty = Convert.ToDecimal(jbr.qty);
asnEntity.SkuQuality = jbr.skuQuality;
asnEntity.Spec = jbr.spec;
#endregion
asnEntity.StockID = Convert.ToInt32(jbr.id);
asnEntity.UnitName = jbr.umName;
asnEntity.ZoneName = jbr.znName;
#region
try
{
if (!string.IsNullOrEmpty(jbr.createDate))
{
asnEntity.CreateDate = Convert.ToDateTime(jbr.createDate);
}
}
catch (Exception msg)
{
MsgBox.Warn(msg.Message);
//LogHelper.errorLog("FrmVehicle+QueryNotRelatedBills", msg);
}
#endregion
#region
try
{
if (!string.IsNullOrEmpty(jbr.expDate))
{
asnEntity.ExpDate = Convert.ToDateTime(jbr.expDate);
}
}
catch (Exception msg)
{
MsgBox.Warn(msg.Message);
//LogHelper.errorLog("FrmVehicle+QueryNotRelatedBills", msg);
}
#endregion
#region
try
{
if (!string.IsNullOrEmpty(jbr.latestIn))
{
asnEntity.LastInDate = Convert.ToDateTime(jbr.latestIn);
}
}
catch (Exception msg)
{
MsgBox.Warn(msg.Message);
//LogHelper.errorLog("FrmVehicle+QueryNotRelatedBills", msg);
}
#endregion
#region
try
{
if (!string.IsNullOrEmpty(jbr.latestOut))
{
asnEntity.LastOutDate = Convert.ToDateTime(jbr.latestOut);
}
}
catch (Exception msg)
{
MsgBox.Warn(msg.Message);
//LogHelper.errorLog("FrmVehicle+QueryNotRelatedBills", msg);
}
#endregion
list.Add(asnEntity);
}
total = bill.total;
return(list);
#endregion
}
catch (Exception ex)
{
MsgBox.Err(ex.Message);
}
return(list);
}
