public void Delete(Model.ProductUnit productUnit)
{
//
// todo:add other logic here
//
this.Delete(productUnit.ProductUnitId);
}
private void simpleButton1_Click(object sender, EventArgs e)
{
if (this.bindingSourceUnitGroup.Current != null)
{
try
{
new BL.ProductUnitManager().Delete(this.bindingSourceUnitGroup.Current as Book.Model.ProductUnit);
}
catch
{
MessageBox.Show(Properties.Resources.DeleteError, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
this._unitGroup.Details.Remove(this.bindingSourceUnitGroup.Current as Book.Model.ProductUnit);
if (this._unitGroup.Details.Count == 0)
{
Model.ProductUnit detail = new Model.ProductUnit();
detail.UnitGroupId = Guid.NewGuid().ToString();
detail.CnName = "";
detail.ConvertRate = 1;
detail.IsMainUnit = false;
this._unitGroup.Details.Add(detail);
this.bindingSourceUnitGroup.Position = this.bindingSourceUnitGroup.IndexOf(detail);
}
this.gridControl1.RefreshDataSource();
}
}
/// <summary>
/// Insert a ProductUnit.
/// </summary>
public void Insert(Model.ProductUnit productUnit)
{
//
// todo:add other logic here
//
// this.Validate(productUnit);
//if (this.Exists(productUnit.Id))
//{
// throw new Helper.InvalidValueException(Model.ProductUnit.PROPERTY_ID);
//}
//if (this.GetByTw(productUnit.CnName) != null)
//{
// throw new Helper.InvalidValueException(Model.ProductUnit.PROPERTY_CNNAME);
//}
//if (this.HasRows(productUnit.ProductUnitId))
//{
// throw new Helper.InvalidValueException(Model.ProductUnit.PROPERTY_PRODUCTUNITID);
//}
//productUnit.ProductUnitId = Guid.NewGuid().ToString();
//productUnit.UnitGroupId = productUnit.UnitGroup.UnitGroupId;
productUnit.InsertTime = DateTime.Now;
productUnit.UpdateTime = DateTime.Now;
if (productUnit.IsMainUnit != null && productUnit.IsMainUnit.Value)
{
this.Updates(productUnit.UnitGroup);
}
accessor.Insert(productUnit);
}
public bool ExistsExcept(Model.ProductUnit e)
{
Hashtable paras = new Hashtable();
paras.Add("newId", e.Id);
paras.Add("oldId", Get(e.ProductUnitId).Id);
return(sqlmapper.QueryForObject <bool>("ProductUnit.existsexcept", paras));
}
protected override void MovePrev()
{
Model.ProductUnit ProductUnit = this.productUnitManager.GetPrev(this._productUnit);
if (ProductUnit == null)
{
throw new InvalidOperationException(Properties.Resources.ErrorNoMoreRows);
}
this._productUnit = ProductUnit;
}
public void MyClick(ref ChooseItem item)
{
ChooseProductUnitForm f = new ChooseProductUnitForm(unitGroupId);
if (f.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
productUnit = f.SelectedItem as Model.ProductUnit;
item = new ChooseItem(productUnit, productUnit.ProductUnitId, productUnit.CnName);
}
}
private void simpleButton2_Click(object sender, EventArgs e)
{
if (this.action != "view")
{
Model.ProductUnit detail = new Model.ProductUnit();
detail.UnitGroupId = Guid.NewGuid().ToString();
detail.CnName = "";
detail.ConvertRate = 1;
detail.IsMainUnit = false;
this._unitGroup.Details.Add(detail);
this.bindingSourceUnitGroup.Position = this.bindingSourceUnitGroup.IndexOf(detail);
this.gridControl1.RefreshDataSource();
}
}
public void MyLeave(ref ChooseItem item)
{
BL.ProductUnitManager manager = new Book.BL.ProductUnitManager();
Model.ProductUnit unit = manager.Get(productUnit.ProductUnitId);
if (unit != null)
{
item.EditValue = unit;
item.LabelText = string.Empty;
item.ButtonText = unit.CnName;
}
else
{
item.ErrorMessage = "单位错误";
}
}
/// <summary>
/// Update a ProductUnit.
/// </summary>
public void Update(Model.ProductUnit productUnit)
{
//
// todo: add other logic here.
//
this.Validate(productUnit);
if (this.ExistsExcept(productUnit))
{
throw new Helper.InvalidValueException(Model.ProductUnit.PROPERTY_ID);
}
productUnit.UnitGroupId = productUnit.UnitGroup.UnitGroupId;
productUnit.UpdateTime = DateTime.Now;
if (productUnit.IsMainUnit != null && productUnit.IsMainUnit.Value)
{
this.Updates(productUnit.UnitGroup);
}
accessor.Update(productUnit);
}
private void Validate(Model.ProductUnit unit)
{
if (string.IsNullOrEmpty(unit.Id))
{
throw new Helper.RequireValueException(Model.ProductUnit.PROPERTY_ID);
}
if (string.IsNullOrEmpty(unit.CnName))
{
throw new Helper.RequireValueException(Model.ProductUnit.PROPERTY_CNNAME);
}
if (string.IsNullOrEmpty(unit.UnitBarCode))
{
throw new Helper.RequireValueException(Model.ProductUnit.PROPERTY_UNITBARCODE);
}
if (unit.UnitGroup == null)
{
throw new Helper.RequireValueException(Model.ProductUnit.PROPERTY_UNITGROUPID);
}
}
private void gridView1_KeyDown(object sender, KeyEventArgs e)
{
if (this.action == "insert" || this.action == "update")
{
if (e.KeyData == Keys.Enter)
{
Model.ProductUnit detail = new Model.ProductUnit();
detail.UnitGroupId = Guid.NewGuid().ToString();
detail.CnName = "";
detail.ConvertRate = 1;
detail.IsMainUnit = false;
this._unitGroup.Details.Add(detail);
this.bindingSourceUnitGroup.Position = this.bindingSourceUnitGroup.IndexOf(detail);
}
if (e.KeyData == Keys.Delete)
{
this.simpleButton1.PerformClick();
}
this.gridControl1.RefreshDataSource();
}
}
protected override void Delete()
{
if (this._productUnit == null)
{
return;
}
if (MessageBox.Show(Properties.Resources.ConfirmToDelete, this.Text, MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK)
{
return;
}
try
{
this.productUnitManager.Delete(this._productUnit.ProductUnitId);
this._productUnit = this.productUnitManager.GetNext(this._productUnit);
if (this._productUnit == null)
{
this._productUnit = this.productUnitManager.GetLast();
}
}
catch
{
throw;
}
}
/*
* /// <summary>
* /// 分页获取数据列表
* /// </summary>
* public DataSet GetList(int PageSize,int PageIndex,string strWhere)
* {
* SqlParameter[] parameters = {
* new SqlParameter("@tblName", SqlDbType.VarChar, 255),
* new SqlParameter("@fldName", SqlDbType.VarChar, 255),
* new SqlParameter("@PageSize", SqlDbType.Int),
* new SqlParameter("@PageIndex", SqlDbType.Int),
* new SqlParameter("@IsReCount", SqlDbType.Bit),
* new SqlParameter("@OrderType", SqlDbType.Bit),
* new SqlParameter("@strWhere", SqlDbType.VarChar,1000),
* };
* parameters[0].Value = "ProductUnit";
* parameters[1].Value = "ID";
* parameters[2].Value = PageSize;
* parameters[3].Value = PageIndex;
* parameters[4].Value = 0;
* parameters[5].Value = 0;
* parameters[6].Value = strWhere;
* return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds");
* }*/
#endregion BasicMethod
#region ExtensionMethod
public bool Edit(List <Model.ProductUnit> insertList, List <Model.ProductUnit> updateList, List <Model.ProductUnit> delList, long id)
{
ArrayList arr = new ArrayList();
StringBuilder sbSql = new StringBuilder();
for (int i = 0; i < delList.Count; i++)
{
sbSql = new StringBuilder();
Model.ProductUnit model = delList[i];
sbSql.Append("delete from ProductUnit where ID=" + model.ID);
arr.Add(sbSql.ToString());
}
for (int i = 0; i < updateList.Count; i++)
{
sbSql = new StringBuilder();
Model.ProductUnit model = updateList[i];
sbSql.Append("update ProductUnit set UnitName='" + model.UnitName + "'");
sbSql.Append(",UpdateUser='******',UpdateDate=getdate()");
sbSql.Append(" where ID=" + model.ID);
arr.Add(sbSql.ToString());
}
for (int i = 0; i < insertList.Count; i++)
{
sbSql = new StringBuilder();
Model.ProductUnit model = insertList[i];
sbSql.Append("insert into ProductUnit(UnitName,CreateUser,CreateDate) ");
sbSql.Append(" values ( ");
sbSql.Append("'" + model.UnitName + "','" + id + "',getdate()");
sbSql.Append(" ) ");
arr.Add(sbSql.ToString());
}
DbHelperSQL.ExecuteSqlTran(arr);
return(true);
}
protected override void AddNew()
{
this._productUnit = new Model.ProductUnit();
this._productUnit.UnitGroup = this.unitGroup;
}
public EditForm(Model.ProductUnit productunit, string action)
: this()
{
this._productUnit = productunit;
this.action = action;
}
public EditForm(Model.ProductUnit productunit)
: this()
{
this._productUnit = productunit;
this.action = "update";
}
public bool HasRowsBefore(Model.ProductUnit e)
{
return(sqlmapper.QueryForObject <bool>("ProductUnit.has_rows_before", e));
}
public bool HasRowsBefore(Model.ProductUnit e)
{
return(accessor.HasRowsBefore(e));
}
public void UpdateProductUnit(Model.ProductUnit unit)
{
var existing = this.GetById(unit.Id);
existing.ProductId = unit.ProductId;
}
public Model.ProductUnit GetNext(Model.ProductUnit e)
{
return(sqlmapper.QueryForObject <Model.ProductUnit>("ProductUnit.get_next", e));
}
public override void Refresh()
{
if (this._unitGroup == null)
{
this._unitGroup = new Book.Model.UnitGroup();
this._unitGroup.Details = new List <Model.ProductUnit>();
this.action = "insert";
}
else
{
if (this.action == "view")
{
this._unitGroup = this.unitGroupManager.GetDetails(_unitGroup.UnitGroupId);
}
}
if (this.action == "insert" || (this.action == "update" && this._unitGroup.Details.Count == 0))
{
Model.ProductUnit detail = new Model.ProductUnit();
detail.UnitGroupId = Guid.NewGuid().ToString();
detail.CnName = "";
detail.ConvertRate = 1;
detail.IsMainUnit = false;
this._unitGroup.Details.Add(detail);
this.bindingSourceUnitGroup.Position = this.bindingSourceUnitGroup.IndexOf(detail);
}
this.bindingSourceUnitGroup.DataSource = this._unitGroup.Details;
this.gridControl1.RefreshDataSource();
flag = 1;
if (this.action != "view")
{
TreeLoad();
}
//this.textEditId.Text = this._unitGroup.Id;
this.textEditUnitGroupName.EditValue = this._unitGroup.UnitGroupName;
this.comboBoxEditUnitGroupType.Text = this._unitGroup.UnitGroupType;
flag = 0;
switch (this.action)
{
case "insert":
// this.textEditId.Properties.ReadOnly = false;
this.textEditUnitGroupName.Properties.ReadOnly = false;
this.comboBoxEditUnitGroupType.Properties.ReadOnly = false;
this.gridView1.OptionsBehavior.Editable = true;
this.simpleButton1.Enabled = true;
this.simpleButton2.Enabled = true;
break;
case "update":
// this.textEditId.Properties.ReadOnly = false ;
this.textEditUnitGroupName.Properties.ReadOnly = false;
this.comboBoxEditUnitGroupType.Properties.ReadOnly = false;
this.gridView1.OptionsBehavior.Editable = true;
this.simpleButton1.Enabled = true;
this.simpleButton2.Enabled = true;
break;
case "view":
// this.textEditId.Properties.ReadOnly = true;
this.textEditUnitGroupName.Properties.ReadOnly = true;
this.comboBoxEditUnitGroupType.Properties.ReadOnly = true;
this.gridView1.OptionsBehavior.Editable = false;
this.simpleButton1.Enabled = false;
this.simpleButton2.Enabled = false;
break;
default:
break;
}
base.Refresh();
}
public Model.ProductUnit GetPrev(Model.ProductUnit e)
{
return(sqlmapper.QueryForObject <Model.ProductUnit>("ProductUnit.get_prev", e));
}
public Model.ProductUnit GetNext(Model.ProductUnit e)
{
return(accessor.GetNext(e));
}
public Model.ProductUnit GetPrev(Model.ProductUnit e)
{
return(accessor.GetPrev(e));
}
public bool HasRowsAfter(Model.ProductUnit e)
{
return(accessor.HasRowsAfter(e));
}
public void Update(Model.ProductUnit e)
{
this.Update <Model.ProductUnit>(e);
}
public void Insert(Model.ProductUnit e)
{
this.Insert <Model.ProductUnit>(e);
}
public bool HasRowsAfter(Model.ProductUnit e)
{
return(sqlmapper.QueryForObject <bool>("ProductUnit.has_rows_after", e));
}
protected override void MoveLast()
{
this._productUnit = this.productUnitManager.GetLast();
}
public bool ExistsExcept(Model.ProductUnit e)
{
return(accessor.ExistsExcept(e));
}
