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