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