/// <summary> /// 修改库存自定义属性 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void bbtnModifyProp_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { StockProp sp = gridViewStockProp.GetFocusedRow() as StockProp; if (sp != null) { string cid = textCatCode.Text; string catName = textCatName.Text; string fParentPid = sp.ParentPid; string fParentName = string.Empty; if (fParentPid != "0") { fParentName = StockPropService.GetStockProp(sp.ParentPid).Name; } string fParentVid = sp.ParentVid; string fParentValueName = string.Empty; if (fParentVid != "0") { fParentValueName = StockPropValueService.GetStockPropValue(sp.ParentVid).Name; } StockPropAdd spa = new StockPropAdd(cid, catName, fParentName, fParentPid, fParentValueName, fParentVid, sp.StockPid, sp.Name); spa.ShowDialog(); WaitDialogForm waitForm = new WaitDialogForm(Constants.OPERATE_DB_DATA); waitForm.Show(); gridCtrlStockProp.DataSource = StockPropService.GetStockProp(c => c.StockCid == cid); waitForm.Close(); } }
public ReturnType AddStockProp(StockProp stockprop) { try { using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString())) { alading.AddToStockProp(stockprop); if (alading.SaveChanges() == 1) { return(ReturnType.Success); } else { return(ReturnType.PropertyExisted); } } } catch (SqlException sex) { return(ReturnType.ConnFailed); } catch (Exception ex) { return(ReturnType.OthersError); } }
/// <summary> /// 点击属性显示其属性值列表 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void gridViewStockProp_RowClick(object sender, DevExpress.XtraGrid.Views.Grid.RowClickEventArgs e) { StockProp sp = gridViewStockProp.GetFocusedRow() as StockProp; if (sp != null) { gridCtrlStockPropValue.DataSource = StockPropValueService.GetStockPropValue(c => c.StockPid == sp.StockPid); } }
public ReturnType DeleteStockPropAndValue(StockProp stockProp) { try { using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString())) { StockProp result = alading.StockProp.FirstOrDefault(c => c.StockPid == stockProp.StockPid); if (result == null) { return(ReturnType.NotExisted); } List <StockPropValue> propValueList = alading.StockPropValue.Where(c => c.StockPid == result.StockPid).ToList(); if (propValueList != null && propValueList.Count > 0) { foreach (StockPropValue stockPropValue in propValueList) { if (stockPropValue.IsParent) { List <StockProp> list = alading.StockProp.Where(c => c.ParentPid == stockPropValue.StockPid && c.ParentVid == stockPropValue.StockVid).ToList(); if (list != null && list.Count > 0) { foreach (StockProp prop in list) { List <StockPropValue> temp = alading.StockPropValue.Where(c => c.StockPid == prop.StockPid).ToList(); if (temp != null && temp.Count > 0) { foreach (StockPropValue t in temp) { alading.DeleteObject(t); } } alading.DeleteObject(prop); } } } alading.DeleteObject(stockPropValue); } } StockPropValue fatherPropValue = alading.StockPropValue.FirstOrDefault(c => c.StockCid == result.StockCid && c.StockPid == result.ParentPid && c.StockVid == result.ParentVid); if (fatherPropValue != null && alading.StockProp.Where(c => c.StockCid == fatherPropValue.StockCid && c.ParentPid == fatherPropValue.StockPid && c.ParentVid == fatherPropValue.StockVid).Count() == 1) { fatherPropValue.IsParent = false; } alading.DeleteObject(result); alading.SaveChanges(); return(ReturnType.Success); } } catch (System.Exception ex) { throw ex; } }
/// <summary> /// 添加 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnAddStockProp_Click(object sender, EventArgs e) { if (flag) { if (AddNewStockProp()) { this.Close(); this.DialogResult = DialogResult.OK; } else { } } else { WaitDialogForm waitForm = new WaitDialogForm(Constants.OPERATE_DB_DATA); waitForm.Show(); try { List <StockProp> list = StockPropService.GetStockProp(s => s.StockPid == pid); if (list.Count > 0) { StockProp sp = list.First(); sp.Name = textEditPropName.Text; if (StockPropService.UpdateStockProp(sp) == ReturnType.Success) { waitForm.Close(); XtraMessageBox.Show("修改成功!", Constants.SYSTEM_PROMPT); this.Close(); this.DialogResult = DialogResult.OK; } else { waitForm.Close(); XtraMessageBox.Show("修改失败!", Constants.SYSTEM_PROMPT); } } else { waitForm.Close(); XtraMessageBox.Show("找不到该属性信息,修改失败!", Constants.SYSTEM_PROMPT); } } catch (Exception ex) { waitForm.Close(); XtraMessageBox.Show("修改失败!", Constants.SYSTEM_PROMPT); } } }
/// <summary> /// 增加属性值 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void bbtnAddStockPropValue_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { StockProp sp = gridViewStockProp.GetFocusedRow() as StockProp; if (sp != null) { string cid = textCatCode.Text; string catName = textCatName.Text; StockPropValueAdd spva = new StockPropValueAdd(cid, catName, sp.Name, sp.StockPid); spva.ShowDialog(); WaitDialogForm waitForm = new WaitDialogForm(Constants.OPERATE_DB_DATA); waitForm.Show(); gridCtrlStockPropValue.DataSource = StockPropValueService.GetStockPropValue(c => c.StockPid == sp.StockPid); waitForm.Close(); } }
public ReturnType UpdateStockProp(string stockpropCode, StockProp stockprop) { throw new NotImplementedException(); //try //{ // using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString())) // { // /*var result = alading.StockProp.Where(p => p.StockPropID == stockpropID).ToList();*/ // var result = alading.StockProp.Where(p => p.StockPropCode == stockpropCode).ToList(); // if (result.Count == 0) // { // return ReturnType.NotExisted; // } // StockProp ob = result.First(); // ob.StockCid = stockprop.StockCid; // ob.StockPid = stockprop.StockPid; // ob.ParentPid = stockprop.ParentPid; // ob.ParentVid = stockprop.ParentVid; // ob.Name = stockprop.Name; // ob.PropValues = stockprop.PropValues; // ob.Status = stockprop.Status; // if (alading.SaveChanges() == 1) // { // return ReturnType.Success; // } // else // { // return ReturnType.OthersError; // } // } //} //catch (SqlException sex) //{ // return ReturnType.ConnFailed; //} //catch (System.Exception ex) //{ // return ReturnType.OthersError; //} }
/// <summary> /// 增加子属性 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void bbtnAddSonStockProp_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { StockProp sp = gridViewStockProp.GetFocusedRow() as StockProp; StockPropValue spv = gridViewStockPropValue.GetFocusedRow() as StockPropValue; if (sp != null && spv != null) { string cid = sp.StockCid; string catName = textCatName.Text; string fParentPid = sp.StockPid; string fParentName = sp.Name; string fParentVid = spv.StockVid; string fParentValueName = spv.Name; StockPropAdd spa = new StockPropAdd(cid, catName, fParentName, fParentPid, fParentValueName, fParentVid, true); spa.ShowDialog(); WaitDialogForm waitForm = new WaitDialogForm(Constants.OPERATE_DB_DATA); waitForm.Show(); gridCtrlStockProp.DataSource = StockPropService.GetStockProp(c => c.StockCid == cid); gridCtrlStockPropValue.DataSource = StockPropValueService.GetStockPropValue(c => c.StockPid == sp.StockPid); waitForm.Close(); } }
/// <summary> /// 添加StockProp /// </summary> /// <returns></returns> bool AddNewStockProp() { if (textEditPropName.Text == null || string.IsNullOrEmpty(textEditPropName.Text.Trim())) { XtraMessageBox.Show("请输入属性名称!", Constants.SYSTEM_PROMPT); textEditPropName.Focus(); return(false); } if (textEditCatCode.Text == null || string.IsNullOrEmpty(textEditCatCode.Text.Trim())) { XtraMessageBox.Show("请输入属性编码!", Constants.SYSTEM_PROMPT); textEditCatCode.Focus(); return(false); } WaitDialogForm waitForm = new WaitDialogForm(Constants.OPERATE_DB_DATA); waitForm.Show(); try { string stockPid = textEditPropPid.Text; if (StockPropService.GetStockProp(s => s.StockPid == stockPid).Count > 0) { waitForm.Close(); XtraMessageBox.Show("属性编码与数据库中已有编码重复,请重输!", Constants.SYSTEM_PROMPT); textEditCatCode.Focus(); return(false); } StockProp sp = new StockProp(); sp.Name = textEditPropName.Text; sp.StockPid = stockPid; sp.ParentPid = fPropPid; sp.ParentVid = fVid; sp.PropValues = string.Empty; sp.Status = string.Empty;// sp.StockCid = stockCid; if (StockPropService.AddStockProp(sp) == ReturnType.Success) { if (sonFlag) { List <StockPropValue> list = StockPropValueService.GetStockPropValue(s => s.StockPid == fPropPid && s.StockVid == fVid); if (list.Count > 0) { StockPropValue spv = list.First(); spv.IsParent = sonFlag; StockPropValueService.UpdateStockPropValue(spv); } } waitForm.Close(); XtraMessageBox.Show("添加属性成功!", Constants.SYSTEM_PROMPT); return(true); } else { waitForm.Close(); XtraMessageBox.Show("添加属性失败!", Constants.SYSTEM_PROMPT); return(false); } } catch (Exception ex) { waitForm.Close(); XtraMessageBox.Show("添加属性失败!", Constants.SYSTEM_PROMPT); return(false); } }
public ReturnType UpdateStockProp(StockProp stockprop) { try { using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString())) { StockProp sp = alading.StockProp.FirstOrDefault(s => s.StockPid == stockprop.StockPid); sp.Name = stockprop.Name; alading.SaveChanges(); return(ReturnType.Success); } } catch (Exception ex) { throw ex; } //try //{ // using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString())) // { // /*StockProp result = alading.StockProp.Where(p => p.StockPropID == stockprop.StockPropID).FirstOrDefault();*/ // StockProp result = alading.StockProp.Where(p => p.StockPropCode == stockprop.StockPropCode).FirstOrDefault(); // if (result == null) // { // return ReturnType.NotExisted; // } // #region Using Attach() Function Update,Default USE; // alading.Attach(result); // alading.ApplyPropertyChanges("StockProp", stockprop); // #endregion // #region Using All Items Replace To Update ,Default UnUse // /* // result.StockCid = stockprop.StockCid; // result.StockPid = stockprop.StockPid; // result.ParentPid = stockprop.ParentPid; // result.ParentVid = stockprop.ParentVid; // result.Name = stockprop.Name; // result.PropValues = stockprop.PropValues; // result.Status = stockprop.Status; // */ // #endregion // if (alading.SaveChanges() == 1) // { // return ReturnType.Success; // } // } //} //catch (SqlException sex) //{ // return ReturnType.ConnFailed; //} //catch (Exception ex) //{ // return ReturnType.OthersError; //} }
public static ReturnType UpdateStockProp(string stockpropCode, StockProp stockprop) { return(DataProviderClass.Instance().UpdateStockProp(stockpropCode, stockprop)); }
public static ReturnType AddStockProp(StockProp stockprop) { return(DataProviderClass.Instance().AddStockProp(stockprop)); }
public static ReturnType DeleteStockPropAndValue(StockProp stockProp) { return(DataProviderClass.Instance().DeleteStockPropAndValue(stockProp)); }