public NewOrModifyDevice(IDBOperation dbOperation, string company_id, SysDeviceQuery company_query) { InitializeComponent(); flag = 0; this.dbOperation = dbOperation; this.companyId = company_id; this.company = company_query; ProvinceCityTable = Application.Current.Resources["省市表"] as DataTable; DataRow[] rows = ProvinceCityTable.Select("pid = '0001'"); //来源产地 ComboboxTool.InitComboboxSource(_province, rows, "cxtj"); _province.SelectionChanged += new SelectionChangedEventHandler(_province_SelectionChanged); DataTable table = dbOperation.GetDbHelper().GetDataSet(string.Format("select companyName,t_company.deptId,sys_client_sysdept.deptName,areaId,t_company.contacter,t_company.phone " + "from t_company left join sys_client_sysdept " + "on t_company.deptId = sys_client_sysdept.deptId where companyId = '{0}' ", companyId)).Tables[0]; if (table.Rows.Count != 0) { this._companyname.Text = table.Rows[0][0].ToString(); this._deptname.Text = table.Rows[0][2].ToString(); this._phone.Text = table.Rows[0][5].ToString(); this._contacter.Text = table.Rows[0][4].ToString(); //赋值来源产地 for (int i = 0; i < _province.Items.Count; i++) { if ((_province.Items[i] as Label).Tag.ToString() == table.Rows[0][3].ToString().Substring(0, 2)) { _province.SelectedItem = _province.Items[i]; break; } } for (int i = 0; i < _city.Items.Count; i++) { if ((_city.Items[i] as Label).Tag.ToString() == table.Rows[0][3].ToString().Substring(0, 4)) { _city.SelectedItem = _city.Items[i]; break; } } for (int i = 0; i < _region.Items.Count; i++) { if ((_region.Items[i] as Label).Tag.ToString() == table.Rows[0][3].ToString()) { _region.SelectedItem = _region.Items[i]; break; } } } }
public NewOrModifyDevice(IDBOperation dbOperation, SysDeviceQuery company_query) { InitializeComponent(); flag = 1; this.dbOperation = dbOperation; this.company = company_query; ProvinceCityTable = Application.Current.Resources["省市表"] as DataTable; DataRow[] rows = ProvinceCityTable.Select("pid = '0001'"); //来源产地 ComboboxTool.InitComboboxSource(_province, rows, "cxtj"); _province.SelectionChanged += new SelectionChangedEventHandler(_province_SelectionChanged); string dept_name = dbOperation.GetDbHelper().GetSingle(string.Format("select deptName from sys_client_sysdept where deptId = '{0}'", deptId)).ToString(); this._deptname.Text = dept_name; }