private void expensType_Load(object sender, EventArgs e)
{
DT = Dom_SqlClass.retriveData("ExpenseType", "Where 1=1", new string[] { "*" });
dataTypeExpens.DataSource = DT;
dom_Design.GenerateColumHeader(new string[] { "លេខកូដសម្គាល់", "ឈ្មោះប្រភេទចំណាយ" }, dataTypeExpens.ColumnCount, dataTypeExpens);
ID = dom_Design.GenerateID(Dom_SqlClass.GetIDFromDB("ExpTypeID", "_", "ExpenseType"), "EXT_00");
txtID.Text = ID;
dataTypeExpens.ClearSelection();
}
private void Customer_Load(object sender, EventArgs e)
{
string[] columnHeaderName = { "លេខកូដសម្គាល់", "នាមត្រកូល", "គោត្តនាម-នាមខ្លួន", "ភេទ", "លេខអត្តសញ្ញាណប័ណ្ណ", "លេខទូរស័ព្ទ" };
DT = Dom_SqlClass.retriveData("Customer", "Where 1=1", new string[] { "*" });
dataCustomer.DataSource = DT;
String[] Name = { "CusID", "FName", "LName", "Gender", "IDNum", "Tel" };
dom_Design.ColumnName(dataCustomer, 6, Name);
dom_Design.GenerateColumHeader(columnHeaderName, dataCustomer.ColumnCount, dataCustomer);
Dom_SqlClass.GetIDFromDB("cusID", "_", "customer");
ID = dom_Design.GenerateID(Dom_SqlClass.GetIDFromDB("cusID", "_", "customer"), "Cus_00");
txtID.Text = ID;
dataCustomer.ClearSelection();
txtFname.Focus();
}
private void cmCustomer_TextChanged(object sender, EventArgs e)
{
if (cmCustomer.SelectedIndex == -1)
{
foreach (String S in cmCustomer.Items)
{
if (cmCustomer.Text.ToLower() != S.ToLower())
{
if (IDCus == "")
{
IDCus = dom_Design.GenerateID(Dom_SqlClass.GetIDFromDB("cusID", "_", "customer"), "Cus_00");
}
else
{
IDCus = dom_Design.GenerateID(IDCus, "Cus_00");
}
txtIDCus.Text = IDCus;
}
}
}
else
{
}
}
private void Expense_Load(object sender, EventArgs e)
{
ID = dom_Design.GenerateID(Dom_SqlClass.GetIDFromDB("ExpID", "_", "Expense"), "EXP_00");
txtID.Text = ID;
Dom_SqlClass.FillItemToCombobox("SELECT ExpTypeID,ExpDesc FROM ExpenseType", "ExpTypeID", "ExpDesc", cmType);
}