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