/// <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; }