public ReturnType RemoveStockUnitGroup(string stockunitgroupCode)
{
try
{
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
/*List<StockUnitGroup> list = alading.StockUnitGroup.Where(p => p.StockUnitGroupID == stockunitgroupID).ToList();*/
List <StockUnitGroup> list = alading.StockUnitGroup.Where(p => p.StockUnitGroupCode == stockunitgroupCode).ToList();
if (list.Count == 0)
{
return(ReturnType.NotExisted);
}
else
{
StockUnitGroup sy = list.First();
alading.DeleteObject(sy);
alading.SaveChanges();
return(ReturnType.Success);
}
}
}
catch (SqlException sex)
{
return(ReturnType.ConnFailed);
}
catch (System.Exception ex)
{
return(ReturnType.OthersError);
}
}
public ReturnType AddStockUnitGroup(StockUnitGroup stockunitgroup, StockUnit unit)
{
System.Data.Common.DbTransaction tran = null;
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
try
{
alading.Connection.Open();
tran = alading.Connection.BeginTransaction();
alading.AddToStockUnitGroup(stockunitgroup);
alading.AddToStockUnit(unit);
alading.SaveChanges();
tran.Commit();
return(ReturnType.Success);
}
catch (System.Exception ex)
{
if (tran != null)
{
tran.Rollback();
}
return(ReturnType.SaveFailed);
}
finally
{
if (alading != null && alading.Connection.State != System.Data.ConnectionState.Closed)
{
alading.Connection.Close();
}
}
}
}
public ReturnType UpdateStockUnitGroup(StockUnitGroup stockunitgroup)
{
try
{
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
/*StockUnitGroup result = alading.StockUnitGroup.Where(p => p.StockUnitGroupID == stockunitgroup.StockUnitGroupID).FirstOrDefault();*/
StockUnitGroup result = alading.StockUnitGroup.Where(p => p.StockUnitGroupCode == stockunitgroup.StockUnitGroupCode).FirstOrDefault();
if (result == null)
{
return(ReturnType.NotExisted);
}
#region Using Attach() Function Update,Default USE;
//alading.Attach(result);
//alading.ApplyPropertyChanges("StockUnitGroup", stockunitgroup);
#endregion
#region Using All Items Replace To Update ,Default UnUse
result.Remark = stockunitgroup.Remark;
result.StockUnitGroupName = stockunitgroup.StockUnitGroupName;
#endregion
if (alading.SaveChanges() == 1)
{
return(ReturnType.Success);
}
return(ReturnType.OthersError);
}
}
catch (SqlException sex)
{
return(ReturnType.ConnFailed);
}
catch (Exception ex)
{
return(ReturnType.OthersError);
}
}
/*
* public ReturnType UpdateStockUnitGroup(string stockunitgroupCode, StockUnitGroup stockunitgroup)
* {
* try
* {
* using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
* {
* //var result = alading.StockUnitGroup.Where(p => p.StockUnitGroupID == stockunitgroupID).ToList();
* var result = alading.StockUnitGroup.Where(p => p.StockUnitGroupCode == stockunitgroupCode).ToList();
* if (result.Count == 0)
* {
* return ReturnType.NotExisted;
* }
*
* StockUnitGroup ob = result.First();
* ob.StockUnitGroupCode = stockunitgroup.StockUnitGroupCode;
* ob.StockUnitGroupName = stockunitgroup.StockUnitGroupName;
* ob.BaseUnit = stockunitgroup.BaseUnit;
*
* if (alading.SaveChanges() == 1)
* {
* return ReturnType.Success;
* }
* else
* {
* return ReturnType.OthersError;
* }
* }
* }
* catch (SqlException sex)
* {
* return ReturnType.ConnFailed;
* }
* catch (System.Exception ex)
* {
* return ReturnType.OthersError;
* }
* }
*/
public ReturnType UpdateStockUnitGroup(string stockUnitGroupName, StockUnitGroup stockunitgroup)
{
try
{
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
var result = alading.StockUnitGroup.Where(p => p.StockUnitGroupName == stockUnitGroupName).ToList();
if (result.Count == 0)
{
return(ReturnType.NotExisted);
}
StockUnitGroup ob = result.First();
//ob.StockUnitGroupCode = stockunitgroup.StockUnitGroupCode;
ob.StockUnitGroupName = stockunitgroup.StockUnitGroupName;
//ob.BaseUnit = stockunitgroup.BaseUnit;
if (alading.SaveChanges() == 1)
{
return(ReturnType.Success);
}
else
{
return(ReturnType.OthersError);
}
}
}
catch (SqlException sex)
{
return(ReturnType.ConnFailed);
}
catch (System.Exception ex)
{
return(ReturnType.OthersError);
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
WaitDialogForm waitForm = new WaitDialogForm(Constants.OPERATE_DB_DATA);
waitForm.Show();
try
{
#region 验证
if (string.IsNullOrEmpty(textEditGroupName.Text) || string.IsNullOrEmpty(textEditGroupName.Text.Trim()))
{
waitForm.Close();
XtraMessageBox.Show("请输入单位组名称！", Constants.SYSTEM_PROMPT, MessageBoxButtons.OK, MessageBoxIcon.Information);
textEditGroupName.Focus();
return;
}
if (string.IsNullOrEmpty(textEditBaseUnitName.Text) || string.IsNullOrEmpty(textEditBaseUnitName.Text.Trim()))
{
waitForm.Close();
XtraMessageBox.Show("请输入基本单位名称！", Constants.SYSTEM_PROMPT, MessageBoxButtons.OK, MessageBoxIcon.Information);
textEditBaseUnitName.Focus();
return;
}
#endregion
StockUnitGroup sug = new StockUnitGroup();
Alading.Entity.StockUnit unit = new Alading.Entity.StockUnit();
/*基本单位编码*/
if (string.IsNullOrEmpty(textEditBaseUnitCode.Text) || string.IsNullOrEmpty(textEditBaseUnitCode.Text.Trim()))
{
unit.StockUnitCode = System.Guid.NewGuid().ToString();
}
else
{
unit.StockUnitCode = textEditBaseUnitCode.Text;
}
/*单位组编码*/
if (string.IsNullOrEmpty(textEditGroupCode.Text) || string.IsNullOrEmpty(textEditGroupCode.Text.Trim()))
{
sug.StockUnitGroupCode = System.Guid.NewGuid().ToString();
}
else
{
sug.StockUnitGroupCode = textEditGroupCode.Text;
}
if (!StockUnitGroupService.IsCodeOnly(unit.StockUnitCode, sug.StockUnitGroupCode))
{
XtraMessageBox.Show("单位或单位组编码输入与数据库中重复，请重输！", Constants.SYSTEM_PROMPT, MessageBoxButtons.OK, MessageBoxIcon.Information);
waitForm.Close();
return;
}
unit.Conversion = 1;
unit.IsBaseUnit = true;
unit.Remark = memoExEdit1.Text;
unit.StockUnitGroupCode = sug.StockUnitGroupCode;
unit.StockUnitName = textEditBaseUnitName.Text;
unit.StockUnitSource = "手动添加";
sug.StockUnitGroupName = textEditGroupName.Text;
sug.BaseUnit = unit.StockUnitName;//
sug.Remark = memoRemark.Text;
waitForm.Close();
if (StockUnitGroupService.AddStockUnitGroup(sug, unit) == ReturnType.Success)
{
XtraMessageBox.Show("添加单位组成功！", Constants.SYSTEM_PROMPT);
}
else
{
XtraMessageBox.Show("添加单位组失败！", Constants.SYSTEM_PROMPT);
}
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
waitForm.Close();
XtraMessageBox.Show(ex.ToString(), Constants.SYSTEM_PROMPT, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/*
* public static ReturnType UpdateStockUnitGroup(string stockunitgroupCode, StockUnitGroup stockunitgroup)
* {
* return DataProviderClass.Instance().UpdateStockUnitGroup(stockunitgroupCode, stockunitgroup);
* }
*/
public static ReturnType UpdateStockUnitGroup(string stockUnitGroupName, StockUnitGroup stockunitgroup)
{
return(DataProviderClass.Instance().UpdateStockUnitGroup(stockUnitGroupName, stockunitgroup));
}
public static ReturnType AddStockUnitGroup(StockUnitGroup stockunitgroup, StockUnit unit)
{
return(DataProviderClass.Instance().AddStockUnitGroup(stockunitgroup, unit));
}
