//置业顾问
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;
}
}
