public ReturnType AddStockPropValue(StockPropValue stockpropvalue)
{
try
{
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
alading.AddToStockPropValue(stockpropvalue);
if (alading.SaveChanges() == 1)
{
return(ReturnType.Success);
}
else
{
return(ReturnType.PropertyExisted);
}
}
}
catch (SqlException sex)
{
return(ReturnType.ConnFailed);
}
catch (Exception ex)
{
return(ReturnType.OthersError);
}
}
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>
/// 增加新的PropValue
/// </summary>
/// <returns></returns>
bool AddNewStockProp()
{
if (textEditValueName.Text == null || string.IsNullOrEmpty(textEditValueName.Text.Trim()))
{
XtraMessageBox.Show("请输入属性值名！", Constants.SYSTEM_PROMPT);
textEditValueName.Focus();
return(false);
}
WaitDialogForm waitForm = new WaitDialogForm(Constants.OPERATE_DB_DATA);
waitForm.Show();
try
{
string stockVid = textEditVid.Text;
if (StockPropService.GetStockProp(s => s.StockPid == stockVid).Count > 0)
{
waitForm.Close();
XtraMessageBox.Show("属性值编码与数据库中已有属性值编码相同，请重输！", Constants.SYSTEM_PROMPT);
textEditVid.Focus();
return(false);
}
StockPropValue spv = new StockPropValue();
spv.IsParent = false;
spv.Name = textEditValueName.Text;
spv.StockPid = PropPid;
spv.PropName = PropName;
spv.SortOrder = 0;
spv.Status = string.Empty;
spv.StockCid = stockCid;//
spv.StockVid = stockVid;
if (StockPropValueService.AddStockPropValue(spv) == ReturnType.Success)
{
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);
}
}
/// <summary>
/// 修改子属性
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void bbtnModifyStockPropValue_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 = textCatCode.Text;
string catName = textCatName.Text;
StockPropValueAdd spva = new StockPropValueAdd(cid, catName, sp.Name, sp.StockPid, spv.Name, spv.StockVid);
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 RemoveStockPropValue(StockPropValue propvalue)
{
try
{
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
StockPropValue stockPropValue = alading.StockPropValue.FirstOrDefault(p => p.StockPid == propvalue.StockPid && p.StockVid == propvalue.StockVid);
if (stockPropValue == null)
{
return(ReturnType.NotExisted);
}
else
{
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);
alading.SaveChanges();
return(ReturnType.Success);
}
}
}
catch (SqlException sex)
{
return(ReturnType.ConnFailed);
}
catch (System.Exception ex)
{
return(ReturnType.OthersError);
}
}
public ReturnType UpdateStockPropValue(string stockpropvalueCode, StockPropValue stockpropvalue)
{
throw new NotImplementedException();
//try
//{
// using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
// {
// /*var result = alading.StockPropValue.Where(p => p.StockPropValueID == stockpropvalueID).ToList();*/
// var result = alading.StockPropValue.Where(p => p.StockPropValueCode == stockpropvalueCode).ToList();
// if (result.Count == 0)
// {
// return ReturnType.NotExisted;
// }
// StockPropValue ob = result.First();
// ob.StockCid = stockpropvalue.StockCid;
// ob.StockPid = stockpropvalue.StockPid;
// ob.PropName = stockpropvalue.PropName;
// ob.StockVid = stockpropvalue.StockVid;
// ob.Name = stockpropvalue.Name;
// ob.IsParent = stockpropvalue.IsParent;
// ob.Status = stockpropvalue.Status;
// ob.SortOrder = stockpropvalue.SortOrder;
// 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 btnAddStockProp_Click(object sender, EventArgs e)
{
if (flag)
{
if (AddNewStockProp())
{
this.Close();
}
else
{
}
}
else
{
WaitDialogForm waitForm = new WaitDialogForm(Constants.OPERATE_DB_DATA);
waitForm.Show();
try
{
List <StockPropValue> list = StockPropValueService.GetStockPropValue(s => s.StockPid == PropPid && s.StockVid == Vid);
if (list.Count > 0)
{
StockPropValue spv = list.First();
spv.Name = textEditValueName.Text;
StockPropValueService.UpdateStockPropValue(spv);
waitForm.Close();
XtraMessageBox.Show("修改属性值失败！", Constants.SYSTEM_PROMPT);
this.Close();
}
}
catch (Exception ex)
{
waitForm.Close();
XtraMessageBox.Show("修改属性值失败！", Constants.SYSTEM_PROMPT);
}
}
}
public ReturnType UpdateStockPropValue(StockPropValue stockpropvalue)
{
try
{
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
/*StockPropValue result = alading.StockPropValue.Where(p => p.StockPropValueID == stockpropvalue.StockPropValueID).FirstOrDefault();*/
StockPropValue result = alading.StockPropValue.Where(p => p.StockPid == stockpropvalue.StockPid && p.StockVid == stockpropvalue.StockVid).FirstOrDefault();
if (result == null)
{
return(ReturnType.NotExisted);
}
result.Name = stockpropvalue.Name;
result.IsParent = stockpropvalue.IsParent;
alading.SaveChanges();
return(ReturnType.Success);
}
}
catch (SqlException sex)
{
return(ReturnType.ConnFailed);
}
catch (Exception ex)
{
return(ReturnType.OthersError);
}
//try
//{
// using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
// {
// /*StockPropValue result = alading.StockPropValue.Where(p => p.StockPropValueID == stockpropvalue.StockPropValueID).FirstOrDefault();*/
// StockPropValue result = alading.StockPropValue.Where(p => p.StockPropValueCode == stockpropvalue.StockPropValueCode).FirstOrDefault();
// if (result == null)
// {
// return ReturnType.NotExisted;
// }
// #region Using Attach() Function Update,Default USE;
// alading.Attach(result);
// alading.ApplyPropertyChanges("StockPropValue", stockpropvalue);
// #endregion
// #region Using All Items Replace To Update ,Default UnUse
// /*
// result.StockCid = stockpropvalue.StockCid;
// result.StockPid = stockpropvalue.StockPid;
// result.PropName = stockpropvalue.PropName;
// result.StockVid = stockpropvalue.StockVid;
// result.Name = stockpropvalue.Name;
// result.IsParent = stockpropvalue.IsParent;
// result.Status = stockpropvalue.Status;
// result.SortOrder = stockpropvalue.SortOrder;
// */
// #endregion
// if (alading.SaveChanges() == 1)
// {
// return ReturnType.Success;
// }
// }
//}
//catch (SqlException sex)
//{
// return ReturnType.ConnFailed;
//}
//catch (Exception ex)
//{
// return ReturnType.OthersError;
//}
}
/// <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 static ReturnType UpdateStockPropValue(string stockpropvalueCode, StockPropValue stockpropvalue)
{
return(DataProviderClass.Instance().UpdateStockPropValue(stockpropvalueCode, stockpropvalue));
}
public static ReturnType RemoveStockPropValue(StockPropValue propvalue)
{
return(DataProviderClass.Instance().RemoveStockPropValue(propvalue));
}
public static ReturnType AddStockPropValue(StockPropValue stockpropvalue)
{
return(DataProviderClass.Instance().AddStockPropValue(stockpropvalue));
}
