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