C# (CSharp) GuestHouse Dom_SqlClass.retriveDataの例

コード例 #1

ファイル: expensType.cs プロジェクト: Chimchanoudom/MIS

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

コード例 #2

ファイル: Customer.cs プロジェクト: Chimchanoudom/MIS

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