private void BindTextEdit(ServiceTicketRule _currentSTR) { if (_currentSTR == null) { _currentSTR = new ServiceTicketRule(); } this.Btn_TicketRule.EditValue = _currentSTR.TicketRuleCode; this.txt_Count.EditValue = _currentSTR.Count; }
/// <summary> /// 得到一个对象实体 /// </summary> public ServiceTicketRule GetModel(int ServiceID, int TicketRuleID) { var strSql = new StringBuilder(); strSql.Append(@"REPOS:Ticket.ServiceTicketRule.GetModel"); var parameters = new List <QfParameter>(); parameters.Add(new QfParameter("@ServiceID", ServiceID)); parameters.Add(new QfParameter("@TicketRuleID", TicketRuleID)); var model = new ServiceTicketRule(); var ds = Query(strSql.ToString(), parameters.ToArray()); return(ModelConvert.ToModel <ServiceTicketRule>(ds)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(ServiceTicketRule model) { var strSql = new StringBuilder(); strSql.Append(@"REPOS:Ticket.ServiceTicketRule.Update"); var parameters = new List <QfParameter>(); parameters.Add(new QfParameter("@ServiceID", model.ServiceID)); parameters.Add(new QfParameter("@TicketRuleID", model.TicketRuleID)); parameters.Add(new QfParameter("@Count", model.Count)); parameters.Add(new QfParameter("@OperateID", model.OperateID)); parameters.Add(new QfParameter("@OperateTime", model.OperateTime)); try { var rows = ExecuteSql(strSql.ToString(), parameters.ToArray()); return(rows > 0); } catch (QfException ex) { throw ex; } }
private void barButtonItem_add_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (e.Item == barButtonItem_add) { txt_Count.Enabled = true; Btn_TicketRule.Enabled = true; ServiceTicketRule ticket = new ServiceTicketRule(); ticket.TicketRuleID = -1; this._currentSTR.TicketRuleID = ticket.TicketRuleID; this.strlist.Add(ticket); this.gc_service_ticket_rule.DataSource = this.strlist; this.gc_service_ticket_rule.RefreshDataSource(); this.gv_service_ticket_rule.FocusedRowHandle = this.gv_service_ticket_rule.GetRowHandle(this.strlist.Count - 1); this.formState = FormState.New; } else if (e.Item == barButtonItem_delete) { if (strlist.Count == 0) { MsgBox.ShowInfo("请选中一条数据"); return; } else { ServiceTicketRule item = (ServiceTicketRule)gv_service_ticket_rule.GetFocusedRow(); new ServiceTicketRuleDao().Delete(item.ServiceID, item.TicketRuleID); strlist.Remove(item); MsgBox.ShowInfo("删除成功"); } this.gc_service_ticket_rule.RefreshDataSource(); } else if (e.Item == barButtonItem_edit) { this._currentSTR = this.gv_service_ticket_rule.GetFocusedRow() as ServiceTicketRule; if (this._currentSTR != null) { this._itemcopy = (ServiceTicketRule)this._currentSTR.Copy();//保存副本,防止取消编辑 if (this._itemcopy != null) { this.ChangeControlState("Modify"); } } } else if (e.Item == barButtonItem_save) { if (txt_Count.Text == "") { MsgBox.ShowInfo("赠送数量不为空"); return; } if (Btn_TicketRule.Text == null) { MsgBox.ShowInfo("规则编号不为空"); return; } this._currentSTR.Count = Convert.ToInt32(txt_Count.Text); this._currentSTR.TicketRuleCode = ValueConvert.ToString(Btn_TicketRule.EditValue); _currentSTR.OperateID = Program.CurrentEmployee.EmployeeID; _currentSTR.OperateTime = DateTime.Now; _currentSTR.ServiceID = iServiceID; bool result = false; if (this.formState == FormState.New) { if (_currentSTR.TicketRuleID == -1) { _currentSTR.TicketRuleID = Convert.ToInt32(this.Btn_TicketRule.Tag); } if (new ServiceTicketRuleDao().Exist(_currentSTR.ServiceID, _currentSTR.TicketRuleID)) { MsgBox.ShowInfo("已经存在选中数据!"); return; } else { result = new ServiceTicketRuleDao().Add(_currentSTR); } } else //保存修改 { result = new ServiceTicketRuleDao().Update(_currentSTR); } if (result) { this.formState = FormState.Normal; int _index = this.gv_service_ticket_rule.GetFocusedDataSourceRowIndex(); this.gc_service_ticket_rule.RefreshDataSource(); this.gv_service_ticket_rule.FocusedRowHandle = _index; MsgBox.ShowInfo("保存成功"); } else { MsgBox.ShowInfo("保存失败"); } } }
private void gv_service_ticket_rule_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e) { this._currentSTR = this.gv_service_ticket_rule.GetFocusedRow() as ServiceTicketRule; this.BindTextEdit(_currentSTR); }