// ============= KANBAN ==================// private void get_db_insert_kanban_local() { WebReference.WebService_kanban mytagdata = new WebReference.WebService_kanban(); DataTable dt = mytagdata.get_m_kanban(); rows_db = dt.Rows.Count; // MessageBox.Show(rows_db.ToString()); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { srct_code_kanban = (string)dt.Rows[i]["SRCT_Code"]; customer_Code_kanban = (string)dt.Rows[i]["Customer_Code"]; attension_point_kanban = (string)dt.Rows[i]["Attension_point"]; part_Number_kanban = (string)dt.Rows[i]["Part_Number"]; part_Name_kanban = (string)dt.Rows[i]["Part_Name"]; model_kanban = (string)dt.Rows[i]["Model"]; package_kanban = (int)dt.Rows[i]["Package"]; customer_kanban = (string)dt.Rows[i]["Customer"]; line_kanban = (string)dt.Rows[i]["Line"]; store_Address_kanban = (string)dt.Rows[i]["Store_Address"]; part_Ilustration_kanban = (string)dt.Rows[i]["Part_Ilustration"]; part_Ilustration_Path_kanban = (string)dt.Rows[i]["Part_Ilustration_Path"]; dock_Code_kanban = (string)dt.Rows[i]["Dock_Code"]; location_kanban = (string)dt.Rows[i]["Location"]; kb_running_kanban = (int)dt.Rows[i]["KB_running"]; insert_data_kanban_to_local(); } } }
}// end method check_dupicate(Parameter) // ========== Count Rows From DB ==========// private void count_rows_db_m_kanban() { try { WebReference.WebService_kanban mytagdata = new WebReference.WebService_kanban(); DataTable dt = mytagdata.get_m_kanban(); rows_db = dt.Rows.Count; MessageBox.Show("rows DB :" + rows_db.ToString()); /* * if (dt.Rows.Count > 0) * { * * } * */ } catch (Exception ex) { MessageBox.Show(ex.Message); } }