/// <summary>
/// 添加或编辑叉车
/// </summary>
/// <param name="entity"></param>
/// <param name="isNew">添加或编辑</param>
/// <returns></returns>
public int Save(ForkEntity fork, bool isNew)
{
IMapper map = DatabaseInstance.Instance();
int ret = -2;
if (isNew)
{
//检查编号是否已经存在
if (IsCodeExists(fork))
{
return(-1);
}
ret = map.Execute("INSERT INTO WM_FORK(FORK_CODE, FORK_NAME ) VALUES(@COD, @NAM)",
new
{
COD = fork.ForkliftCode,
NAM = fork.ForkliftName
});
}
else
{
//更新
ret = map.Execute("UPDATE WM_FORK SET FORK_NAME = @NAM WHERE FORK_CODE = @COD",
new
{
COD = fork.ForkliftCode,
NAM = fork.ForkliftName
});
}
return(ret);
}
/// <summary>
/// 检查叉车编码是否已存在
/// </summary>
/// <param name="unit"></param>
/// <returns></returns>
private bool IsCodeExists(ForkEntity fork)
{
IMapper map = DatabaseInstance.Instance();
string id = map.ExecuteScalar <string>("SELECT FORK_CODE FROM WM_FORK WHERE FORK_CODE = @COD", new { COD = fork.ForkliftCode });
return(!string.IsNullOrEmpty(id));
}
private void OnCreateChanage(object sender, EventArgs e)
{
ForkEntity newEntity = (ForkEntity)sender;
bindingSource1.Add(newEntity);
bindingSource1.ResetBindings(false);
}
///<summary>
///查询所有叉车
///</summary>
///<returns></returns>
public List <ForkEntity> GetAllFork()
{
List <ForkEntity> list = new List <ForkEntity>();
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_GetAllFork);
if (string.IsNullOrEmpty(jsonQuery))
{
MsgBox.Warn(WebWork.RESULT_NULL);
//LogHelper.InfoLog(WebWork.RESULT_NULL);
return(list);
}
#endregion
#region 正常错误处理
JsonGetAllFork bill = JsonConvert.DeserializeObject <JsonGetAllFork>(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 (JsonGetAllForkResult jbr in bill.result)
{
ForkEntity asnEntity = new ForkEntity();
#region
asnEntity.ForkliftCode = jbr.forkCode;
asnEntity.ForkliftName = jbr.forkName;
#endregion
list.Add(asnEntity);
}
return(list);
#endregion
}
catch (Exception ex)
{
MsgBox.Err(ex.Message);
}
return(list);
}
public ForkEntity PrepareSave()
{
ForkEntity editEntity = forkEntity;
if (editEntity == null)
{
editEntity = new ForkEntity();
}
editEntity.ForkliftCode = txtCode.Text.Trim();
editEntity.ForkliftName = txtName.Text.Trim();
return(editEntity);
}
/// <summary>
/// 编辑
/// </summary>
private void ShowEditFork()
{
ForkEntity editEntity = SelectedForkRow;
if (editEntity == null)
{
MsgBox.Warn("没有要修改的数据。");
return;
}
FrmForkEdit frmEdit = new FrmForkEdit(editEntity);
frmEdit.DataSourceChanged += OnEditChanage;
frmEdit.ShowDialog();
}
private bool Save()
{
if (!IsFieldValueValid())
{
return(false);
}
bool success = false;
try
{
ForkEntity editEntity = PrepareSave();
//int ret = forkDal.Save(editEntity, isNew);
//if (ret == -1)
// MsgBox.Warn("叉车编号或名称已存在，请改为其他的叉车编号或名称。");
//else if (ret == -2)
// MsgBox.Warn("更新失败，该行已经被其他人删除。");
//else
bool ret;
if (isNew)
{
ret = SaveAddForkInfo(editEntity, isNew);
}
else
{
ret = SaveUpdateForkInfo(editEntity, isNew);
}
if (ret)
{
success = true;
if (DataSourceChanged != null)
{
DataSourceChanged(editEntity, null);
}
}
}
catch (Exception ex)
{
MsgBox.Warn(ex.Message);
}
return(success);
}
/// <summary>
/// 添加或编辑叉车
/// </summary>
/// <param name="entity"></param>
/// <param name="isNew">添加或编辑</param>
/// <returns></returns>
public bool SaveAddForkInfo(ForkEntity fork, bool isNew)
{
try
{
#region 请求数据
System.Text.StringBuilder loStr = new System.Text.StringBuilder();
loStr.Append("forkCode=").Append(fork.ForkliftCode).Append("&");
loStr.Append("forkName=").Append(fork.ForkliftName);
string jsonQuery = WebWork.SendRequest(loStr.ToString(), WebWork.URL_SaveAddForkInfo);
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);
}
/// <summary>
/// 删除
/// </summary>
private void DoDeleteSelectedUnit()
{
ForkEntity removeEntity = SelectedForkRow;
if (removeEntity == null)
{
MsgBox.Warn("没有要删除的数据。");
return;
}
if (MsgBox.AskOK(string.Format("确定要删除叉车“({0}){1}”吗？", removeEntity.ForkliftCode, removeEntity.ForkliftName)) == DialogResult.OK)
{
bool ret = DeleteForkInfo(removeEntity.ForkliftCode);
if (ret)
{
bindingSource1.Remove(removeEntity);
}
//else
// MsgBox.Warn("删除失败。");
}
}
private void ShowEditInfo(ForkEntity forkliftEntity)
{
txtCode.Text = forkliftEntity.ForkliftCode;
txtName.Text = forkliftEntity.ForkliftName;
}
public FrmForkEdit(ForkEntity forkEntity)
: this()
{
this.forkEntity = forkEntity;
}
