/// <summary>
/// 删除
/// </summary>
private void DoDeleteCtl()
{
//soQueryDal.DeleteCTL();
SoContainerLocation removeEntity = SelectedRow;
if (removeEntity == null)
{
MsgBox.Warn("没有要删除的数据。");
return;
}
if (removeEntity.CTLState == "占用")
{
MsgBox.Warn("不能删除被占用的托盘位");
return;
}
if (MsgBox.AskOK(string.Format("确定要删除托盘位编号“({0}){1}”吗？", removeEntity.CTLName, removeEntity.CTLState)) == DialogResult.OK)
{
bool ret = DeleteCTL(removeEntity.CTLName, removeEntity.CTlType);
if (ret)
{
bindingSource1.Remove(removeEntity);
}
//else
//{
// MsgBox.Warn("删除失败。");
// return;
//}
}
}
private bool IsCodeExists(SoContainerLocation sclEntity)
{
IMapper map = DatabaseInstance.Instance();
string id = map.ExecuteScalar <string>("SELECT wcl.CTL_NAME FROM wm_container_location wcl" +
" INNER JOIN wm_base_code wbc ON wcl.CTL_TYPE =wbc.ITEM_VALUE " +
" WHERE wcl.CTL_NAME= @CTLNAME AND wbc.ITEM_DESC=@CTL_TYPE", new { CTLNAME = sclEntity.CTLName, CTL_TYPE = sclEntity.CTlType });
return(!string.IsNullOrEmpty(id));
}
/// <summary>
/// 获取准备操作的实体
/// </summary>
/// <returns></returns>
public SoContainerLocation PrepareSave()
{
SoContainerLocation editEntity = new SoContainerLocation();
editEntity.CTLState = BaseCodeConstant.CTL_STATE_KONG_XIAN;
editEntity.CTlType = lookUpEdit1.Text;
editEntity.CTLName_Old = ctlEntity == null ? "" : ctlEntity.CTLName;
editEntity.CTLName = textEdit1.Text.Trim();
return(editEntity);
}
/// <summary>
/// 基础管理（容器位维护-查询所有容器位）
/// </summary>
/// <returns></returns>
public List <SoContainerLocation> QeryCTL()
{
List <SoContainerLocation> list = new List <SoContainerLocation>();
try
{
#region 请求数据
System.Text.StringBuilder loStr = new System.Text.StringBuilder();
//loStr.Append("whCode=").Append(warehouseCode).Append("&");
//loStr.Append("state=").Append(state);
string jsonQuery = WebWork.SendRequest(string.Empty, WebWork.URL_QeryCTL);
if (string.IsNullOrEmpty(jsonQuery))
{
MsgBox.Warn(WebWork.RESULT_NULL);
//LogHelper.InfoLog(WebWork.RESULT_NULL);
return(list);
}
#endregion
#region 正常错误处理
JsonQeryCTL bill = JsonConvert.DeserializeObject <JsonQeryCTL>(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 (JsonQeryCTLResult jbr in bill.result)
{
SoContainerLocation asnEntity = new SoContainerLocation();
#region
asnEntity.CTLName = jbr.ctlName;
asnEntity.CTLState = jbr.itemDesc1;
asnEntity.CTlType = jbr.itemDesc2;
#endregion
list.Add(asnEntity);
}
return(list);
#endregion
}
catch (Exception ex)
{
MsgBox.Err(ex.Message);
}
return(list);
}
private bool Save()
{
if (!IsFieldValueValid())
{
return(false);
}
bool success = false;
try
{
//BaseCodeEntity ctlType = this.lookUpEdit1.SelectedText as BaseCodeEntity;
SoContainerLocation ctLEntity = PrepareSave();
//int ret = soQuery.Save(ctLEntity, isNew, GlobeSettings.LoginedUser.WarehouseCode, this.lookUpEdit1.Text);
//if (ret == -1)
//{
// MsgBox.Warn("容器位编号已存在，请改为其他的容器位编号。");
// return false;
//}
//else if (ret == -2)
//{
// MsgBox.Warn("更新失败，该行已经被其他人删除。");
// return false;
//}
//else
bool ret;
if (isNew)
{
ret = SaveAddCTLInfo(ctLEntity, isNew, GlobeSettings.LoginedUser.WarehouseCode, this.lookUpEdit1.Text);
}
else
{
ret = SaveUpdateCTLInfo(ctLEntity, isNew, GlobeSettings.LoginedUser.WarehouseCode, this.lookUpEdit1.Text);
}
if (ret)
{
success = true;
if (DataSourceChanged != null)
{
DataSourceChanged(ctLEntity, null);
}
}
}
catch (Exception ex)
{
MsgBox.Warn(ex.Message);
}
return(success);
}
private void DoEditCtl()
{
SoContainerLocation changeEntity = SelectedRow;
if (changeEntity == null)
{
MsgBox.Warn("请选择要修改的托盘位！");
return;
}
FrmCtlEdit frmCtlEdit = new FrmCtlEdit(changeEntity);
frmCtlEdit.DataSourceChanged += OnCreateChanage;
frmCtlEdit.ShowDialog();
}
/// <summary>
/// 基础管理（容器位维护-添加容器位）
/// </summary>
/// <param name="sclEntity"></param>
/// <param name="isNew"></param>
/// <param name="whCode"></param>
/// <param name="ctlTye"></param>
/// <returns></returns>
public bool SaveAddCTLInfo(SoContainerLocation sclEntity, bool isNew, string whCode, string ctlTye)
{
try
{
#region 请求数据
System.Text.StringBuilder loStr = new System.Text.StringBuilder();
loStr.Append("ctlName=").Append(sclEntity.CTLName).Append("&");
loStr.Append("ctlState=").Append(sclEntity.CTLState).Append("&");
loStr.Append("whCode=").Append(whCode).Append("&");
loStr.Append("ctlType=").Append(ctlTye);
string jsonQuery = WebWork.SendRequest(loStr.ToString(), WebWork.URL_SaveAddCTLInfo);
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 int Save(SoContainerLocation sclEntity, bool isNew, string whCode, string ctlTye)
{
IMapper map = DatabaseInstance.Instance();
if (IsCodeExists(sclEntity))
{
return(-1);
}
int ret = -2;
if (isNew)
{
//检查编号是否已经存在,不存在添加
ret = map.Execute("INSERT INTO wm_container_location(CTL_NAME,CTL_STATE,LAST_UPDATETIME,WH_CODE,CTL_TYPE)" +
"VALUES(@CTL_NAME, @CTL_STATE,NOW(),@WH_CODE,CASE @CTL_TYPE WHEN '托盘位'THEN 'L95'WHEN '笼车位'THEN 'L96' END)",
new
{
CTL_NAME = sclEntity.CTLName,
CTL_STATE = sclEntity.CTLState,
WH_CODE = whCode,
CTL_TYPE = ctlTye
});
}
else
{
//更新
ret = map.Execute("UPDATE wm_container_location wcl " +
" INNER JOIN wm_base_code wbc ON wcl.CTL_TYPE=wbc.ITEM_VALUE " +
"SET CTL_NAME= @CTL_NAME,LAST_UPDATETIME = NOW() " +
"WHERE CTL_NAME = @CTL_NAME_OLD AND wbc.ITEM_DESC=@CTL_TYPE",
new
{
CTL_NAME = sclEntity.CTLName,
CTL_NAME_OLD = sclEntity.CTLName_Old,
CTL_TYPE = ctlTye
});
}
return(ret);
}
public FrmCtlEdit(SoContainerLocation ctlEntity)
: this()
{
this.ctlEntity = ctlEntity;
}
private void OnCreateChanage(object sender, EventArgs e)
{
SoContainerLocation newEntity = (SoContainerLocation)sender;
Reload();
}
