/// <summary> /// 添加或编辑分类 /// </summary> /// <param name="entity"></param> /// <param name="isNew">添加或编辑</param> /// <returns></returns> public int Save(MaterialTypeEntity entity, bool isNew) { IMapper map = DatabaseInstance.Instance(); int ret = -2; if (isNew) { //检查编号是否已经存在 if (IsCodeExists(entity)) { return(-1); } ret = map.Execute("INSERT INTO WM_SKU_TYPE(TYP_CODE, TYP_NAME, ZN_CODE) VALUES(@COD, @NAM, @ZN_CODE)", new { COD = entity.MaterialTypeCode, NAM = entity.MaterialTypeName, ZN_CODE = entity.ZoneCode }); } else { //更新 ret = map.Execute("UPDATE WM_SKU_TYPE SET TYP_NAME = @NAM, ZN_CODE = @ZN_CODE WHERE TYP_CODE = @COD", new { COD = entity.MaterialTypeCode, NAM = entity.MaterialTypeName, ZN_CODE = entity.ZoneCode }); } return(ret); }
private void OnCreateChanage(object sender, EventArgs e) { MaterialTypeEntity newEntity = (MaterialTypeEntity)sender; bindingSource1.Add(newEntity); bindingSource1.ResetBindings(false); }
/// <summary> /// 检查主分类编码是否已存在 /// </summary> /// <param name="type"></param> /// <returns></returns> private bool IsCodeExists(MaterialTypeEntity type) { IMapper map = DatabaseInstance.Instance(); string id = map.ExecuteScalar <string>("SELECT TYP_CODE FROM WM_SKU_TYPE WHERE TYP_CODE = @COD", new { COD = type.MaterialTypeCode }); return(!string.IsNullOrEmpty(id)); }
public void AddMaterialType(MaterialType materialType) { var entity = new MaterialTypeEntity { MaterialTypeId = materialType.MaterialTypeId, MaterialTypeName = materialType.MaterialTypeName }; _materialTypeRepo.Add(entity); _materialTypeRepo.Save(); }
///<summary> ///查询所有分类 ///</summary> ///<returns></returns> public List <MaterialTypeEntity> GetMaterialTypeAll() { List <MaterialTypeEntity> list = new List <MaterialTypeEntity>(); try { #region 请求数据 System.Text.StringBuilder loStr = new System.Text.StringBuilder(); //loStr.Append("roleId=").Append(roleId); string jsonQuery = WebWork.SendRequest(string.Empty, WebWork.URL_GetMaterialTypeAll); if (string.IsNullOrEmpty(jsonQuery)) { MsgBox.Warn(WebWork.RESULT_NULL); //LogHelper.InfoLog(WebWork.RESULT_NULL); return(list); } #endregion #region 正常错误处理 JsonGetMaterialTypeAll bill = JsonConvert.DeserializeObject <JsonGetMaterialTypeAll>(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 (JsonGetMaterialTypeAllResult jbr in bill.result) { MaterialTypeEntity asnEntity = new MaterialTypeEntity(); #region 11-14 asnEntity.MaterialTypeCode = jbr.typCode; asnEntity.MaterialTypeName = jbr.typName; asnEntity.ZoneCode = jbr.znCode; asnEntity.ZoneName = jbr.znName; #endregion list.Add(asnEntity); } return(list); #endregion } catch (Exception ex) { MsgBox.Err(ex.Message); } return(list); }
/// <summary> /// 编辑 /// </summary> private void ShowEdit() { MaterialTypeEntity editEntity = SelectedHeaderRow; if (editEntity == null) { MsgBox.Warn("没有要修改的数据。"); return; } FrmMaterialTypeEdit frmEdit = new FrmMaterialTypeEdit(editEntity); frmEdit.DataSourceChanged += OnEditChanage; frmEdit.ShowDialog(); }
public MaterialTypeEntity PrepareSave() { MaterialTypeEntity editEntity = mtlTypeEntity; if (editEntity == null) { editEntity = new MaterialTypeEntity(); } editEntity.MaterialTypeCode = txtCode.Text.Trim(); editEntity.MaterialTypeName = txtName.Text.Trim(); editEntity.ZoneCode = ConvertUtil.ToString(listZones.EditValue); editEntity.ZoneName = listZones.Text; return(editEntity); }
private bool Save() { if (!IsFieldValueValid()) { return(false); } bool success = false; try { MaterialTypeEntity editEntity = PrepareSave(); //int ret = mtlTypeDal.Save(editEntity, isNew); //if (ret == -1) // MsgBox.Warn("分类编号已存在,请改为其他的编号。"); //else if (ret == -2) // MsgBox.Warn("更新失败,该行已经被其他人删除。"); //else bool ret; if (isNew) { ret = SaveAddSkuType(editEntity, isNew); } else { ret = SaveUpdateSkuType(editEntity, isNew); } if (ret) { success = true; if (DataSourceChanged != null) { DataSourceChanged(editEntity, null); } } } catch (Exception ex) { MsgBox.Err(ex.Message); } return(success); }
/// <summary> /// 添加或编辑分类 /// </summary> /// <param name="entity"></param> /// <param name="isNew">添加或编辑</param> /// <returns></returns> public bool SaveUpdateSkuType(MaterialTypeEntity entity, bool isNew) { try { #region 请求数据 System.Text.StringBuilder loStr = new System.Text.StringBuilder(); loStr.Append("typCode=").Append(entity.MaterialTypeCode).Append("&"); loStr.Append("typName=").Append(entity.MaterialTypeName).Append("&"); loStr.Append("znCode=").Append(entity.ZoneCode); string jsonQuery = WebWork.SendRequest(loStr.ToString(), WebWork.URL_SaveUpdateSkuType); 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 DoDelete() { MaterialTypeEntity removeEntity = SelectedHeaderRow; if (removeEntity == null) { MsgBox.Warn("没有要删除的数据。"); return; } if (MsgBox.AskOK(string.Format("确定要删除分类{0}({1})吗?", removeEntity.MaterialTypeCode, removeEntity.MaterialTypeName)) == DialogResult.OK) { bool ret = DeleteSkuType(removeEntity.MaterialTypeCode); if (ret) { bindingSource1.Remove(removeEntity); } //else // MsgBox.Warn("删除失败,可能已经被其他人删除。"); } }
public FrmMaterialTypeEdit(MaterialTypeEntity mtlTypeEntity) : this() { this.mtlTypeEntity = mtlTypeEntity; }
private void ShowEditInfo(MaterialTypeEntity mtlTypeEntity) { txtCode.Text = mtlTypeEntity.MaterialTypeCode; txtName.Text = mtlTypeEntity.MaterialTypeName; listZones.EditValue = mtlTypeEntity.ZoneCode; }