/// <summary> /// 绑定控件 /// </summary> private void BindingControls() { try { myDataTable = myBUCMS_VIPClient.VIPSearch(false, string.Empty, string.Empty); //false表示全部查询 this.gridControlVIPInfo.DataSource = myDataTable; myDataTable = myBUCMS_VIPType.GetOrder(false, string.Empty, string.Empty, false); this.lupVIPType.Properties.DataSource = myDataTable; this.lupVIPType.ItemIndex = 0; } catch (Exception ex) { XtraMessageBox.Show(ex.Message); } }
/// <summary> /// 绑定数据到lup下拉框(按账单查询的) /// </summary> private void Bindinglup() { DataTable LupDatatable = new DataTable(); BUCMS_Buffets myBUCMS_Buffets = new BUCMS_Buffets(); BUCMS_VIPType myBUCMS_VIPType = new BUCMS_VIPType(); BUCMS_VIPClient myBUCMS_VIPClient = new BUCMS_VIPClient(); BUCMS_Employee myBUCMS_Employee = new BUCMS_Employee(); BUCMS_ItemDetail myBUCMS_ItemDetail = new BUCMS_ItemDetail(); try { LupDatatable = myBUCMS_Buffets.GetOrder(false, string.Empty, string.Empty, false); ClassAssist.CommonOperator.DataBindingLookUpEdit(this.lupTableName, LupDatatable, "Name", "ID", true); LupDatatable = myBUCMS_VIPType.GetOrder(false, string.Empty, string.Empty, false); ClassAssist.CommonOperator.DataBindingLookUpEdit(lupVIPType, LupDatatable, "Name", "ID", true); LupDatatable = myBUCMS_VIPClient.GetOrder(false, string.Empty, string.Empty, false); ClassAssist.CommonOperator.DataBindingLookUpEdit(lupVIPClient, LupDatatable, "Name", "ID", true); LupDatatable = myBUCMS_Employee.GetOrder(false, string.Empty, string.Empty, false); ClassAssist.CommonOperator.DataBindingLookUpEdit(lupWaiter, LupDatatable, "Name", "ID", true); LupDatatable = myBUCMS_ItemDetail.GetItemByType(VariedItemType.PayType); ClassAssist.CommonOperator.DataBindingLookUpEdit(lupPayment, LupDatatable, "Name", "ID", true); } catch (Exception ex) { XtraMessageBox.Show(ex.ToString()); } }
/// <summary> /// 绑定数据到lup下拉框(按账单查询的) /// </summary> private void Bindinglup() { DataTable LupDatatable = new DataTable(); BUCMS_Buffets myBUCMS_Buffets = new BUCMS_Buffets(); BUCMS_VIPType myBUCMS_VIPType = new BUCMS_VIPType(); BUCMS_VIPClient myBUCMS_VIPClient = new BUCMS_VIPClient(); BUCMS_Employee myBUCMS_Employee = new BUCMS_Employee(); BUCMS_ItemDetail myBUCMS_ItemDetail = new BUCMS_ItemDetail(); try { LupDatatable = myBUCMS_Buffets.GetOrder(false, string.Empty, string.Empty, false); this.lupTableName.Properties.DataSource = LupDatatable; this.lupTableName.ItemIndex = 0; LupDatatable = myBUCMS_VIPType.GetOrder(false, string.Empty, string.Empty, false); this.lupVIPType.Properties.DataSource = LupDatatable; this.lupVIPType.ItemIndex = 0; LupDatatable = myBUCMS_VIPClient.GetOrder(false, string.Empty, string.Empty, false); this.lupVIPClient.Properties.DataSource = LupDatatable; this.lupVIPClient.ItemIndex = 0; LupDatatable = myBUCMS_Employee.GetOrder(false, string.Empty, string.Empty, false); this.lupWaiter.Properties.DataSource = LupDatatable; this.lupWaiter.ItemIndex = 0; LupDatatable = myBUCMS_ItemDetail.GetItemByType(VariedItemType.PayType); this.lupPayment.Properties.DataSource = LupDatatable; this.lupPayment.ItemIndex = 0; } catch (Exception ex) { throw ex; } }
/// <summary> /// 检测会员名称和折扣是否唯一 /// </summary> /// <returns></returns> private int CheckOnlyVIPDiscount(string paramFiledName, string paramVIPDiscount) { BUCMS_VIPType myBUCMS_VIPType = new BUCMS_VIPType(); DataTable myDataTable = new DataTable(); myDataTable = myBUCMS_VIPType.GetOrder(false, paramFiledName, paramVIPDiscount, false); if (myDataTable.Rows.Count > 0) { return(1);//已存在改会员卡 } return(0); }
/// <summary> /// 绑定数据到gridControl表格(会员卡信息) /// </summary> public void InitializeControls() { try { DataTable myDataTable = myBUCMS_VIPType.GetOrder(false, string.Empty, string.Empty, false); this.gridControlMain.DataSource = myDataTable; } catch (Exception ex) { XtraMessageBox.Show(ex.Message); } }
/// <summary> ///绑定数据到会员级别下拉框(会员卡信息) /// </summary> public void InitializeControls() { //获取CMS_VIPType表即会员卡信息表中的数据时直接调用BUCMS_VIPType的这个方法 BUCMS_VIPType myBUCMS_VIPType = new BUCMS_VIPType(); try { DataTable myDataTable = myBUCMS_VIPType.GetOrder(false, string.Empty, string.Empty, false); //绑定到下拉框 this.lkdVIPType.Properties.DataSource = myDataTable; this.lkdVIPType.ItemIndex = 0; } catch (Exception ex) { XtraMessageBox.Show(ex.Message); } }
/// <summary> /// Handles the SelectionChanged event of the gridViewMain control.选中一项时发生 /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="DevExpress.Data.SelectionChangedEventArgs"/> instance containing the event data.</param> /// 整理人:桂书丛 /// 整理时间:2013-02-28 private void gridViewMain_SelectionChanged(object sender, DevExpress.Data.SelectionChangedEventArgs e) { DataRow tempDataRow = this.gridViewMain.GetFocusedDataRow(); //取出选中行的原始数据(在数据库中的)(数据库中的数据不一定全在控件中显示) if (tempDataRow == null) { return; } string myVIPID = tempDataRow["VIPTypeID"].ToString(); BUCMS_VIPType myBUCMS_VIPType = new BUCMS_VIPType(); try { DataTable myDataTable = myBUCMS_VIPType.GetOrder(false, "ID", myVIPID, false); this.txtVIPName.Text = myDataTable.Rows[0]["Name"].ToString(); this.txtDiscount.EditValue = myDataTable.Rows[0]["Discount"]; this.txtVIPCost.EditValue = tempDataRow["VIPCost"]; } catch (Exception ex) { XtraMessageBox.Show(ex.Message); } }
/// <summary> /// 绑定数据到查询条件的控件 /// </summary> private void BindingToSerach() { DataTable myDataTable = new DataTable(); try { //会员卡要从VIPType表中获取 BUCMS_VIPType myBUCMS_VIPType = new BUCMS_VIPType(); myDataTable = myBUCMS_VIPType.GetOrder(false, string.Empty, string.Empty, false); this.lupVIPType.Properties.DataSource = myDataTable; this.lupVIPType.ItemIndex = 0; this.lupVIPType.Properties.DisplayMember = "Name"; //创建人要到User表中获取 BUT_User myBUT_User = new BUT_User(); myDataTable = myBUT_User.GetAllUserInfo(); this.lupCreatePerson.Properties.DataSource = myDataTable; this.lupCreatePerson.ItemIndex = 0; this.lupCreatePerson.Properties.DisplayMember = "USERNAME"; } catch (Exception ex) { XtraMessageBox.Show(ex.Message); } }