コード例 #1
0
ファイル: AccountAddForm.cs プロジェクト: liwei5946/CEMS
 private void AccountAddForm_Load(object sender, EventArgs e)
 {
     DataSet ds_eqType = null, ds_department = null, ds_Status=null ;
     AccountAdd aa = new AccountAdd();
     ds_eqType = aa.CreateDataSet_EquipmentType();
     ds_department = aa.CreateDataSet_Department();
     ds_Status = aa.CreateDataSet_Status();
     InitComboBox(combo_eqType, ds_eqType, "id", "type_name");
     InitComboBox(combo_depart, ds_department, "id", "departname");
     InitComboBox(combo_status, ds_Status, "id", "status_name");
 }
コード例 #2
0
ファイル: AccountEditForm.cs プロジェクト: liwei5946/CEMS
 public AccountEditForm(string id)
 {
     InitializeComponent();
     accountId = id;
     DataSet ds_eqType = null, ds_department = null, ds_Status = null;
     DataSet ds = null;
        // DataTable data = null;
     AccountAdd aa = new AccountAdd();
     Account ads = new Account();
     //初始化下拉列表用
     ds_eqType = aa.CreateDataSet_EquipmentType();
     ds_department = aa.CreateDataSet_Department();
     ds_Status = aa.CreateDataSet_Status();
     //获取指定id的信息
     ds = ads.queryAccountById(id);
     //ds2.Tables[0].Rows[0][]
     //log.Debug("设备类型是:"+ds.Tables[0].Rows[0][19].ToString());
     InitComboBox(combo_eqType, ds_eqType, "id", "type_name",ds,"type");
     InitComboBox(combo_depart, ds_department, "id", "departname",ds,"department");
     InitComboBox(combo_status, ds_Status, "id", "status_name",ds ,"status");
     text_asset.DataBindings.Add(new Binding("Text", ds.Tables[0], "asset"));
     text_eqname.DataBindings.Add(new Binding("Text",ds.Tables[0],"eqname"));
     text_model.DataBindings.Add(new Binding("Text", ds.Tables[0], "model"));
     text_specification.DataBindings.Add(new Binding("Text", ds.Tables[0], "specification"));
     text_weight.DataBindings.Add(new Binding("Text", ds.Tables[0], "weight"));
     text_brand.DataBindings.Add(new Binding("Text", ds.Tables[0], "brand"));
     text_manufacturer.DataBindings.Add(new Binding("Text", ds.Tables[0], "manufacturer"));
     text_supplier.DataBindings.Add(new Binding("Text", ds.Tables[0], "supplier"));
     maskedText_value.DataBindings.Add(new Binding("Value", ds.Tables[0], "value"));
     numeric_count.DataBindings.Add(new Binding("Value", ds.Tables[0], "count"));
     numeric_electromotor.DataBindings.Add(new Binding("Value", ds.Tables[0], "electromotor"));
     maskedText_power.DataBindings.Add(new Binding("Value", ds.Tables[0], "power"));
     dateTime_manu_date.DataBindings.Add(new Binding("Value", ds.Tables[0], "manu_date"));
     dateTime_produ_date.DataBindings.Add(new Binding("Value", ds.Tables[0], "produ_date"));
     dateTime_filing_date.DataBindings.Add(new Binding("Value", ds.Tables[0], "filing_date"));
     text_address.DataBindings.Add(new Binding("Text", ds.Tables[0], "address"));
     img = (byte[])(ds.Tables[0]).Rows[0][21];
     threeD = (byte[])(ds.Tables[0]).Rows[0][22];
 }