private void load_defaul_view(DataTable dataTable) { //load number book and year book DataTable data_notary_book = new DataTable(); data_notary_book = bll_contract.GetDataNotaryBook(ref err); foreach (DataRow row in data_notary_book.Rows) { cbo_num_bo.Items.Add(row["Number_Of_Book"]); cbo_year.Items.Add(row["Year_Book"]); } cbo_num_bo.SelectedItem = data_notary_book.Rows[data_notary_book.Rows.Count - 1]["Number_Of_Book"]; cbo_year.SelectedItem = data_notary_book.Rows[data_notary_book.Rows.Count - 1]["Year_Book"]; //load notar number int count = dataTable.Rows.Count; int max = Convert.ToInt32((string)(dataTable.Rows[count - 1]["Notary_Number"])); foreach (DataRow row in dataTable.Rows) { int temp = Convert.ToInt32((string)row["Notary_Number"]); max = max > temp?max:temp; } if (count != 0) { int no_num_int = max + 1; txt_number_no.Text = no_num_int.ToString(); txt_number_no.AutoCompleteCustomSource.Add((string)(dataTable.Rows[count - 1]["Notary_Number"])); } else { txt_number_no.Text = ""; } //load cbo type contract DataTable table_cb_name = new DataTable(); table_cb_name = bll_contract.GetDataConboNameContract(ref err); cbo_name_contract.Items.Add("Hãy chọn hợp đồng"); cbo_name_contract.SelectedItem = "Hãy chọn hợp đồng"; foreach (DataRow row in table_cb_name.Rows) { cbo_name_contract.Items.Add(row["Type_Name_Contract"]); cbo_name_contract.AutoCompleteCustomSource.Add((string)row["Type_Name_Contract"]); } DataTable tb_type = new DataTable(); tb_type = bll_contract.GetDataConboType(ref err); cbo_type_contract.Items.Add("Hãy chọn loại hợp đồng"); cbo_type_contract.SelectedItem = "Hãy chọn loại hợp đồng"; foreach (DataRow row in tb_type.Rows) { cbo_type_contract.Items.Add(row["Name_Type"]); cbo_name_contract.AutoCompleteCustomSource.Add((string)row["Name_Type"]); } //load other control dpk_date_ask.Value = DateTime.Now; dpk_date_sign.Value = DateTime.Now; txt_price.Text = "0"; }
public DataTable LoadDataNoBook() { DataTable data = new DataTable(); return(data = bll_contact.GetDataNotaryBook(ref err)); }