private bool Save()
{
if (!IsFieldValueValid())
{
return(false);
}
try
{
SkuWarehouseEntity entity = PrepareSave();
bool isCreateNew = (this.Entity == null);
//int result = skuWarehouseDal.Save(entity, isCreateNew);
//if (result == -1)
//{
// MsgBox.Warn("编号已经存在，请改为其他的编号。");
// return false;
//}
if (SaveUpdateSkuWarehouse(entity, isCreateNew))
{
if (DataSourceChanged != null)
{
DataSourceChanged(null, null);
}
return(true);
}
}
catch (Exception ex)
{
MsgBox.Err(ex.Message);
return(false);
}
return(false);
}
private void ShowEditInfo(SkuWarehouseEntity entity)
{
txtCode.Text = entity.SkuWarehouseID.ToString();
listSku.EditValue = entity.SkuCode;
txtSpec.Text = entity.Spec;
txtMinStockQty.Text = entity.MinStockQty.ToString();
txtMaxStockQty.Text = entity.MaxStockQty.ToString();
txtLocSafe.Text = entity.SecurityQty.ToString();
}
public int Save(SkuWarehouseEntity entity, bool isCreateNew)
{
IMapper map = DatabaseInstance.Instance();
//int sUnit = 0; //销售单位与库存单位，转换倍数大于1时为销售单位，否则为库存单位
//if (Qty > 1)
// sUnit = 1;
int ret = -1;
if (isCreateNew) //新增
{
//if (IsCodeExists(SkuCode, UmCode, Barcode))
// return -1;
//ret = map.Execute("INSERT INTO wm_um_sku "
// + "(UM_CODE ,QTY ,SKU_CODE ,SKU_BARCODE ,WEIGHT ,LENGTH ,WIDTH ,HEIGHT ,IS_ACTIVE ,LAST_UPDATETIME, S_UNIT) "
// + "VALUES(@umCode, @qty, @skuCode, @barcode, @weight, @length, @width, @height, @isActive, NOW(), @SUnit)",
//new
//{
// umCode = UmCode,
// qty = Qty,
// skuCode = SkuCode,
// barcode = Barcode,
// weight = Weight,
// length = Length,
// width = Width,
// height = Height,
// isActive = IsActive,
// SUnit = sUnit
//});
}
else
{
//查看是否在使用中，否则不允许更新
//更新【如果允许WMS修改物料信息需要修改操作的表为wm_sku】
ret = map.Execute("UPDATE wm_sku_warehouse wsw SET wsw.MIN_STOCK_QTY=@minStockQty,wsw.MAX_STOCK_QTY=@maxStockQty,wsw.SECURITY_QTY=@safeQty WHERE wsw.ID=@ID ",
new
{
spec = entity.Spec,
minStockQty = entity.MinStockQty,
maxStockQty = entity.MaxStockQty,
safeQty = entity.SecurityQty,
ID = entity.SkuWarehouseID
});
}
return(ret);
}
private void ShowEditLocation()
{
SkuWarehouseEntity editEntity = SelectedLocationRow;
if (editEntity == null)
{
MsgBox.Warn("没有要修改的数据。");
return;
}
FrmSKUWarehouseEdit frmSKUWarehouseEdit = new FrmSKUWarehouseEdit(editEntity);
frmSKUWarehouseEdit.DataSourceChanged += OnEditChanage;
frmSKUWarehouseEdit.ShowDialog();
}
public SkuWarehouseEntity PrepareSave()
{
SkuWarehouseEntity editEntity = this.Entity;
if (editEntity == null)
{
editEntity = new SkuWarehouseEntity();
}
editEntity.Spec = txtSpec.Text.Trim();
editEntity.MinStockQty = ConvertUtil.ToInt(txtMinStockQty.Text.Trim());
editEntity.MaxStockQty = ConvertUtil.ToInt(txtMaxStockQty.Text.Trim());
editEntity.SecurityQty = ConvertUtil.ToInt(txtLocSafe.Text.Trim());
return(editEntity);
}
/// <summary>
/// 基础管理（本库物料-更新本库物料）
/// </summary>
/// <param name="entity"></param>
/// <param name="isCreateNew"></param>
/// <returns></returns>
public bool SaveUpdateSkuWarehouse(SkuWarehouseEntity entity, bool isCreateNew)
{
try
{
#region 请求数据
System.Text.StringBuilder loStr = new System.Text.StringBuilder();
#region
loStr.Append("minStockQty=").Append(entity.MinStockQty).Append("&");
loStr.Append("maxStockQty=").Append(entity.MaxStockQty).Append("&");
loStr.Append("securityQty=").Append(entity.SecurityQty).Append("&");
loStr.Append("id=").Append(entity.SkuWarehouseID);
#endregion
string jsonQuery = WebWork.SendRequest(loStr.ToString(), WebWork.URL_SaveUpdateSkuWarehouse);
if (string.IsNullOrEmpty(jsonQuery))
{
MsgBox.Warn(WebWork.RESULT_NULL);
//LogHelper.InfoLog(WebWork.RESULT_NULL);
return(false);
}
#endregion
#region 正常错误处理
Sucess bill = JsonConvert.DeserializeObject <Sucess>(jsonQuery);
if (bill == null)
{
MsgBox.Warn(WebWork.JSON_DATA_NULL);
return(false);
}
if (bill.flag != 0)
{
MsgBox.Warn(bill.error);
return(false);
}
#endregion
return(true);
}
catch (Exception ex)
{
MsgBox.Err(ex.Message);
}
return(false);
}
public FrmSKUWarehouseEdit(SkuWarehouseEntity entity)
: this()
{
this.Entity = entity;
}
///<summary>
///查询所有
///</summary>
///<returns></returns>
public List <SkuWarehouseEntity> GetAllSkuWarehouse(int nums, int begin, out int total)
{
List <SkuWarehouseEntity> list = new List <SkuWarehouseEntity>();
total = 0;
try
{
#region 请求数据
System.Text.StringBuilder loStr = new System.Text.StringBuilder();
//loStr.Append("billState=").Append(BillStateConst.ASN_STATE_CODE_COMPLETE).Append("&");
if (begin == 0)
{
loStr.Append("beginRow=").Append("&");
loStr.Append("rows=");
}
else
{
loStr.Append("beginRow=").Append(begin).Append("&");
loStr.Append("rows=").Append(nums);
}
//loStr.Append("wareHouseCode=").Append(warehouseCode);
string jsonQuery = WebWork.SendRequest(loStr.ToString(), WebWork.URL_GetAllSkuWarehouse);
if (string.IsNullOrEmpty(jsonQuery))
{
MsgBox.Warn(WebWork.RESULT_NULL);
//LogHelper.InfoLog(WebWork.RESULT_NULL);
return(list);
}
#endregion
#region 正常错误处理
JsonGetAllSkuWarehouse bill = JsonConvert.DeserializeObject <JsonGetAllSkuWarehouse>(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 (JsonGetAllSkuWarehouseResult jbr in bill.result)
{
SkuWarehouseEntity asnEntity = new SkuWarehouseEntity();
#region 0-10
asnEntity.LowerLocation = Convert.ToInt32(jbr.lowerLocation);
asnEntity.MaxStockQty = Convert.ToInt32(jbr.maxStockQty);
asnEntity.MinStockQty = Convert.ToInt32(jbr.minStockQty);
asnEntity.PickType = Convert.ToInt32(jbr.pickType);
asnEntity.SecurityQty = Convert.ToInt32(jbr.securityQty);
asnEntity.SkuCode = jbr.skuCode;
asnEntity.SkuName = jbr.skuName;
asnEntity.Spec = jbr.spec;
asnEntity.UpperLocation = Convert.ToInt32(jbr.upperLocation);
#endregion
try
{
//if (!string.IsNullOrEmpty(jbr.closeDate))
// asnEntity.CloseDate = Convert.ToDateTime(jbr.closeDate);
//if (!string.IsNullOrEmpty(jbr.printedTime))
// asnEntity.PrintedTime = Convert.ToDateTime(jbr.printedTime);
//if (!string.IsNullOrEmpty(jbr.createDate))
// asnEntity.CreateDate = Convert.ToDateTime(jbr.createDate);
}
catch (Exception msg)
{
MsgBox.Warn(msg.Message);
//LogHelper.errorLog("FrmVehicle+QueryNotRelatedBills", msg);
}
list.Add(asnEntity);
}
total = bill.total;
return(list);
#endregion
}
catch (Exception ex)
{
MsgBox.Err(ex.Message);
}
return(list);
}
