//置业顾问 public static void SetSales(ComboBox cbx, ComboBoxType type = ComboBoxType.input, bool isOnlySales = false) { string sql = string.Empty; if (isOnlySales) { sql = "select a.SalesID, a.SalesName from sales a " + " inner join JobTrack b on a.SalesID = b.SalesID " + " where b.EndDate is null and a.ProjectID = " + Login.User.ProjectID; } else { sql = "select SalesID, SalesName from Sales where OutDate is null and ProjectID = " + Login.User.ProjectID; } if (type == ComboBoxType.search) { sql = "select '0' as SalesID,'全部' as SalesName union all " + sql; } cbx.DataSource = SqlHelper.ExecuteDataTable(sql); cbx.ValueMember = "SalesID"; cbx.DisplayMember = "SalesName"; if (cbx.Items.Count > 0) { cbx.SelectedIndex = 0; } }
//付款方式 public static void setPayment(ComboBox cbx, ComboBoxType type = ComboBoxType.input) { string sql = "select id, PayName from PaymentMode where ProjectID = " + Login.User.ProjectID + " order by ID"; if (type == ComboBoxType.search) { sql = "select '0' as ID,'全部' as PayName union all " + sql; } cbx.DataSource = SqlHelper.ExecuteDataTable(sql); cbx.DisplayMember = "PayName"; cbx.ValueMember = "id"; if (cbx.Items.Count > 0) { cbx.SelectedIndex = 0; } }
//收款类型 public static void SetReceiptType(ComboBox cbx, ComboBoxType type = ComboBoxType.input) { string sql = "select code, name from DictReceiptType where IsSys = 0 and State = 1 order by Code "; if (type == ComboBoxType.search) { sql = "select '0' as code,'全部' as name union all " + sql; } cbx.DataSource = SqlHelper.ExecuteDataTable(sql); cbx.DisplayMember = "name"; cbx.ValueMember = "code"; if (cbx.Items.Count > 0) { cbx.SelectedIndex = 0; } }
//房产类型 public static void SetItemType(ComboBox cbx, ComboBoxType type = ComboBoxType.input) { string sql = "select code, name from DictItemType where 1=1 and ProjectID = " + Login.User.ProjectID; if (type == ComboBoxType.search) { sql = "select '0' as code,'全部' as name union all " + sql; } cbx.DataSource = SqlHelper.ExecuteDataTable(sql); cbx.DisplayMember = "name"; cbx.ValueMember = "code"; if (cbx.Items.Count > 0) { cbx.SelectedIndex = 0; } }
public void fillComboBox(ComboBox targetComboBox, ComboBoxType comboBoxType, int userID) { Guard.notNull(targetComboBox, "ComboBox"); DataTable retrievedData = new DataTable(); switch (comboBoxType) { case ComboBoxType.CREDITOR_COMBOBOX: retrievedData = retrieveData(sqlStatementSelectCreditors, userID); Guard.notNull(retrievedData, "DataTable"); targetComboBox.DataSource = retrievedData; targetComboBox.DisplayMember = "creditorName"; break; case ComboBoxType.DEBTOR_COMBOBOX: retrievedData = retrieveData(sqlStatementSelectDebtors, userID); Guard.notNull(retrievedData, "DataTable"); targetComboBox.DataSource = retrievedData; targetComboBox.DisplayMember = "debtorName"; break; case ComboBoxType.EXPENSE_TYPE_COMBOBOX: retrievedData = retrieveData(sqlStatementSelectExpenseTypes); Guard.notNull(retrievedData, "DataTable"); targetComboBox.DataSource = retrievedData; targetComboBox.DisplayMember = "categoryName"; break; case ComboBoxType.INCOME_TYPE_COMBOBOX: retrievedData = retrieveData(sqlStatementSelectIncomeTypes); Guard.notNull(retrievedData, "DataTable"); targetComboBox.DataSource = retrievedData; targetComboBox.DisplayMember = "typeName"; break; default: break; } }