public void InitData(string vr) { WireCategory wirewire = new WireCategory(); wirewire.WireLevel = wirel; IList list2 = Services.BaseService.GetList("SelectWireCategoryList", wirewire); foreach (WireCategory wirewire2 in list2) { if (wirewire2.WireLevel != null) { if (!WireLevel.Items.Contains(wirewire2.WireLevel)) { wirewire2.WireLevel = ""; } } Services.BaseService.Update <WireCategory>(wirewire2); } //IList list = Services.BaseService.GetList("SelectWireCategoryListBYWireLevel", wirewire); IList list = Services.BaseService.GetList("SelectWireCategoryList", wirewire); DataTable dt = Itop.Common.DataConverter.ToDataTable(list, typeof(WireCategory)); this.Text = vr; dataGridView1.DataSource = dt; }
private void spinEdit6_EditValueChanged(object sender, EventArgs e) { //显示所在位置的名称 object obj = null; if (string.IsNullOrEmpty(dev.AreaID) && !string.IsNullOrEmpty(parentid)) { obj = DeviceHelper.GetDevice <PSPDEV>(parentid); dev.AreaID = parentid; } else { obj = DeviceHelper.GetDevice <PSPDEV>(dev.AreaID); } if (obj != null) { spinEdit19.Value = (decimal)((PSPDEV)obj).HuganTQ4 * spinEdit6.Value; spinEdit20.Value = (decimal)((PSPDEV)obj).HuganTQ5; } WireCategory rc = new WireCategory(); rc.WireLevel = dev.RateVolt.ToString(); rc.WireType = dev.LineType; rc.Type = "40"; rc = (WireCategory)UCDeviceBase.DataService.GetObject("SelectWireCategoryByKeyANDWireLevel", rc); if (rc != null) { spinEdit19.Value = (decimal)(rc.gzl) * spinEdit6.Value; spinEdit20.Value = (decimal)rc.xftime; } }
public frmLineParamWJ() { InitializeComponent(); dataGridView1.DataError += new DataGridViewDataErrorEventHandler(dataGridView1_DataError); dataGridView1.CellValueChanged += new DataGridViewCellEventHandler(dataGridView1_CellValueChanged); WireCategory wirewire = new WireCategory(); IList list1 = Services.BaseService.GetList("SelectWireCategoryList", wirewire); IList list2 = null; foreach (WireCategory sub in list1) { list2.Add(sub); lineTypeDataGridViewTextBoxColumn.Items.Add(sub.WireType); foreach (WireCategory sub2 in list2) { if (sub2 == sub) { list2.Remove(sub2); lineTypeDataGridViewTextBoxColumn.Items.Remove(sub.WireType); } } } }
public frmLinenew(PSPDEV pspDev) { InitializeComponent(); mc.Select(); WireCategory wirewire = new WireCategory(); wirewire.WireLevel = pspDev.VoltR.ToString(); IList list1 = Services.BaseService.GetList("SelectWireCategoryListBYWireLevel", wirewire); foreach (WireCategory sub in list1) { comboBox22.Properties.Items.Add(sub.WireType); } InitData(pspDev); this.comboBox22.SelectedIndexChanged += new System.EventHandler(this.comboBox22_SelectedIndexChanged); this.textBox11.Leave += new System.EventHandler(this.textBox11_Leave); this.textBox11.TextChanged += new System.EventHandler(this.textBox11_TextChanged); this.comboBoxEdit1.SelectedIndexChanged += new System.EventHandler(this.comboBoxEdit1_SelectedIndexChanged); this.comboBoxEdit1.Leave += new System.EventHandler(this.comboBoxEdit1_Leave); object[] o = new object[30]; for (int i = 0; i < 30; i++) { o[i] = 2009 + i; } this.tyear.Properties.Items.AddRange(o); //this.tyear.Visible = false; }
private void comboBoxEdit1_SelectedIndexChanged(object sender, EventArgs e) { if (comboBoxEdit1.Text == "") { comboBoxEdit1.Text = "0"; } if (comboBoxEdit1.Text == leel.VoltR.ToString()) { } else { WireCategory wirewire = new WireCategory(); wirewire.WireLevel = comboBoxEdit1.Text; IList list1 = Services.BaseService.GetList("SelectWireCategoryListBYWireLevel", wirewire); comboBox22.Properties.Items.Clear(); foreach (WireCategory sub in list1) { comboBox22.Properties.Items.Add(sub.WireType); } //if (list1.Count == 0) comboBox22.Text = ""; leel.LineLength = Convert.ToDouble(textBox11.Text); leel.LineType = comboBox22.Text; leel.Name = mc.Text; leel.LineStatus = comboBox44.Text; leel.LineLevel = "单回路"; string tempp = comboBoxEdit1.Text.Replace("KV", "");; int tel = tempp.Length; //tempp = tempp.Substring(0, tel-2); //pspDev.VoltR = Convert.ToDouble(tempp); leel.VoltR = Convert.ToDouble(tempp); if (comboBoxEdit8.Text == "" || comboBoxEdit8.Text == null) { comboBoxEdit8.Text = "0"; } // WireCategory wirewire = new WireCategory(); // wirewire.WireType = comboBox22.Text; // WireCategory wirewire2 = new WireCategory(); // wirewire2 = (WireCategory)Services.BaseService.GetObject("SelectWireCategoryByKey", wirewire); // if (wirewire2 != null) // { // leel.LineR = Convert.ToDouble(leel.LineLength) * wirewire2.WireR; // leel.LineTQ = Convert.ToDouble(leel.LineLength) * wirewire2.WireTQ; // leel.LineGNDC = Convert.ToDouble(leel.LineLength) * wirewire2.WireGNDC; // } // //textBox2.Text= leel.ReferenceVolt = Convert.ToDouble(comboBoxEdit8.Text); InitData(leel); } }
public void InitCom() { comboBoxEdit9.Properties.Items.Add("新建"); comboBoxEdit9.Properties.Items.Add("扩建"); comboBoxEdit9.Properties.Items.Add("改造"); comboBoxEdit9.SelectedIndex = 0; for (int i = yAnge.BeginYear; i <= yAnge.EndYear; i++) { comboBoxEdit1.Properties.Items.Add(i.ToString()); comboBoxEdit2.Properties.Items.Add(i.ToString()); } comboBoxEdit1.Text = DateTime.Now.Year.ToString(); comboBoxEdit2.Text = DateTime.Now.AddYears(1).Year.ToString(); IList <string> strList = oper.GetLineS1("S5='1'"); foreach (string str in strList) { comboBoxEdit5.Properties.Items.Add(str); } comboBoxEdit5.SelectedIndex = 0; strList = oper.GetLineS1("S5='2'"); foreach (string str in strList) { comboBoxEdit6.Properties.Items.Add(str); } comboBoxEdit6.SelectedIndex = 0; strList = oper.GetLineName("S5='2' and S1='" + comboBoxEdit6.Text + "' and name like'%" + comboBoxEdit9.Text + "%'"); if (strList.Count != 0) { comboBoxEdit4.Text = strList[0].ToString(); } IList <string> areatyplist = null; if (Common.Services.BaseService.GetList <string>("SelectBuildProDifAreaType", "") != null) { areatyplist = Common.Services.BaseService.GetList <string>("SelectBuildProDifAreaType", ""); for (int j = 0; j < areatyplist.Count; j++) { comboBoxEdit11.Properties.Items.Add(areatyplist[j]); } } //导线型号 WireCategory wc = new WireCategory(); wc.Type = "40"; IList <WireCategory> list = Common.Services.BaseService.GetList <WireCategory>("SelectWireCategoryList", wc); for (int k = 0; k < list.Count; k++) { comboBoxEdit14.Properties.Items.Add(list[k].WireType); } }
public frmLineParamDL(string svgUID) { InitializeComponent(); dataGridView1.DataError += new DataGridViewDataErrorEventHandler(dataGridView1_DataError); dataGridView1.CellValueChanged += new DataGridViewCellEventHandler(dataGridView1_CellValueChanged); WireCategory wirewire = new WireCategory(); IList list1 = Services.BaseService.GetList("SelectWireCategoryList", wirewire); IList list2 = Services.BaseService.GetList("SelectWireCategoryList", wirewire); list2.Clear(); foreach (WireCategory sub in list1) { list2.Add(sub); lineTypeDataGridViewTextBoxColumn.Items.Add(sub.WireType); int i = 1; foreach (WireCategory sub2 in list2) { if (sub2.WireType == sub.WireType) { i++; if (i > 2) { lineTypeDataGridViewTextBoxColumn.Items.Remove(sub.WireType); } //list2.Remove(sub2); } } Refresh(); } PSPDEV dev = new PSPDEV(); //dev.Number = pspDev.FirstNode; dev.SvgUID = svgUID; dev.Type = "Polyline"; IList list = Services.BaseService.GetList("SelectPSPDEVBySvgUIDAndType", dev); foreach (PSPDEV sub in list) { if (sub.Lable == "支路") { huganLine1DataGridViewTextBoxColumn.Items.Add(sub.Name); huganLine2DataGridViewTextBoxColumn.Items.Add(sub.Name); huganLine3DataGridViewTextBoxColumn.Items.Add(sub.Name); huganLine4DataGridViewTextBoxColumn.Items.Add(sub.Name); } } InitData(svgUID); //huganLine1DataGridViewTextBoxColumn.Items.Add(" "); //huganLine2DataGridViewTextBoxColumn.Items.Add(" "); //huganLine3DataGridViewTextBoxColumn.Items.Add(" "); //huganLine4DataGridViewTextBoxColumn.Items.Add(" "); }
/// <summary> /// 根据查询条件,重新选择设备 /// </summary> public override void SelDevices() { datatable1 = null; WireCategory wc = new WireCategory(); wc.Type = "40"; IList list = DataService.GetList("SelectWireCategoryList", wc); datatable1 = Itop.Common.DataConverter.ToDataTable(list, typeof(WireCategory)); gridControl1.DataSource = datatable1; }
public frmLinenew() { InitializeComponent(); WireCategory wirewire = new WireCategory(); IList list1 = Services.BaseService.GetList("SelectWireCategoryList", wirewire); foreach (WireCategory sub in list1) { comboBox22.Properties.Items.Add(sub.WireType); } //textBox1.Text = null; //textBox1.Select(); }
void dataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e) { DataTable dt = dataGridView1.DataSource as DataTable; DataRow dr = dt.Rows[e.RowIndex]; if (dr != null) { if ((e.ColumnIndex == 23) || (e.ColumnIndex == 21) || (e.ColumnIndex == 22)) { string temp = dr[26].ToString(); if (temp != "") { dr[16] = Convert.ToDouble(temp.Substring(0, temp.Length - 2)); } WireCategory wirewire = new WireCategory(); wirewire.WireType = dr[27].ToString(); wirewire.WireLevel = dr[16].ToString() + "KV"; WireCategory wirewire2 = new WireCategory(); //wirewire2 = (WireCategory)Services.BaseService.GetObject("SelectWireCategoryByKey", wirewire); wirewire2 = (WireCategory)Services.BaseService.GetObject("SelectWireCategoryByKeyANDWireLevel", wirewire); if (wirewire2 != null) { if (dr[25].ToString() == "") { dr[25] = 0; } dr[18] = Convert.ToDouble(dr[25]) * wirewire2.WireR; dr[19] = Convert.ToDouble(dr[25]) * wirewire2.WireTQ; dr[20] = Convert.ToDouble(dr[25]) * wirewire2.WireGNDC; dr[21] = wirewire2.WireChange; } if (wirewire2 == null) { dr[18] = 0; dr[19] = 0; dr[20] = 0; dr[21] = 0; } //leel.LineGNDC = Convert.ToDouble(dr[25]) * wirewire2.WireGNDC; //dr[18] = 100; } PSPDEV obj = Itop.Common.DataConverter.RowToObject <PSPDEV>(dr); Services.BaseService.Update <PSPDEV>(obj); } //InitData(dr[7].ToString()); dataGridView1.Update(); Refresh(); }
public override void Add() { frmDXXHdlg dlg = new frmDXXHdlg(); if (dlg.ShowDialog() == DialogResult.OK) { //增加记录 WireCategory dev = dlg.DeviceMx; DataService.Create <WireCategory>(dev); DataRow row = datatable1.NewRow(); Itop.Common.DataConverter.ObjectToRow(dev, row); datatable1.Rows.Add(row); } }
public frmLineParamDL() { InitializeComponent(); dataGridView1.DataError += new DataGridViewDataErrorEventHandler(dataGridView1_DataError); dataGridView1.CellValueChanged += new DataGridViewCellEventHandler(dataGridView1_CellValueChanged); WireCategory wirewire = new WireCategory(); IList list1 = Services.BaseService.GetList("SelectWireCategoryList", wirewire); foreach (WireCategory sub in list1) { lineTypeDataGridViewTextBoxColumn.Items.Add(sub.WireType); } //huganLine1DataGridViewTextBoxColumn.Items.Add }
public override void Delete() { DataRow row = gridView1.GetDataRow(gridView1.FocusedRowHandle); if (row != null) { WireCategory dev = Itop.Common.DataConverter.RowToObject <WireCategory>(row); DialogResult dr = Itop.Common.MsgBox.ShowYesNo("是否确认删除导线型号[" + dev.WireType + "]?"); if (dr == DialogResult.Yes) { DataService.Delete <WireCategory>(dev); ((DataTable)gridControl1.DataSource).Rows.Remove(row); } } }
private void textBox11_Leave(object sender, EventArgs e) { if (textBox11.Text == "") { textBox11.Text = "0"; } //MessageBox.Show("hello"); if (textBox11.Text == leel.LineLength.ToString()) { } else { leel.LineLength = Convert.ToDouble(textBox11.Text); leel.LineType = comboBox22.Text; leel.Name = mc.Text; leel.LineStatus = comboBox44.Text; leel.LineLevel = "单回路"; WireCategory wirewire = new WireCategory(); wirewire.WireType = comboBox22.Text; WireCategory wirewire2 = new WireCategory(); wirewire.WireLevel = comboBoxEdit5.Text; wirewire2 = (WireCategory)Services.BaseService.GetObject("SelectWireCategoryByKeyANDWireLevel", wirewire); if (wirewire2 != null) { leel.LineR = Convert.ToDouble(leel.LineLength) * wirewire2.WireR; leel.LineTQ = Convert.ToDouble(leel.LineLength) * wirewire2.WireTQ; leel.LineGNDC = Convert.ToDouble(leel.LineLength) * wirewire2.WireGNDC; leel.PositiveTQ = Convert.ToDouble(leel.LineLength) * wirewire2.WireTQ; leel.ZeroTQ = leel.PositiveTQ * 3; } //textBox2.Text= string tempp = comboBoxEdit5.Text; int tel = tempp.Length; //tempp = tempp.Substring(0, tel - 2); //pspDev.VoltR = Convert.ToDouble(tempp); leel.VoltR = Convert.ToDouble(tempp); InitData(leel); } }
public void InitCom() { comboBoxEdit9.Properties.Items.Add("新建"); comboBoxEdit9.Properties.Items.Add("扩建"); comboBoxEdit9.Properties.Items.Add("改造"); comboBoxEdit9.SelectedIndex = 0; for (int i = yAnge.BeginYear; i <= yAnge.EndYear; i++) { comboBoxEdit1.Properties.Items.Add(i.ToString()); comboBoxEdit2.Properties.Items.Add(i.ToString()); } comboBoxEdit1.Text = DateTime.Now.Year.ToString(); comboBoxEdit2.Text = DateTime.Now.AddYears(1).Year.ToString(); string conn = "ProjectID='" + projectID + "' order by Sort"; IList <PS_Table_AreaWH> list1 = Common.Services.BaseService.GetList <PS_Table_AreaWH>("SelectPS_Table_AreaWHByConn", conn); foreach (PS_Table_AreaWH area in list1) { comboBoxEdit10.Properties.Items.Add(area.Title); } //导线型号 WireCategory wc = new WireCategory(); wc.Type = "40"; IList <WireCategory> list = Common.Services.BaseService.GetList <WireCategory>("SelectWireCategoryList", wc); for (int k = 0; k < list.Count; k++) { combDXXH.Properties.Items.Add(list[k].WireType); } //网区类型 IList <string> areatyplist = null; if (Common.Services.BaseService.GetList <string>("SelectBuildProDifAreaType", "") != null) { areatyplist = Common.Services.BaseService.GetList <string>("SelectBuildProDifAreaType", ""); for (int j = 0; j < areatyplist.Count; j++) { combWQFL.Properties.Items.Add(areatyplist[j]); } } }
public override void Edit() { frmDXXHdlg dlg = new frmDXXHdlg(); DataRow row = gridView1.GetDataRow(gridView1.FocusedRowHandle); if (row != null) { WireCategory dev = Itop.Common.DataConverter.RowToObject <WireCategory>(row); dlg.DeviceMx = dev; if (dlg.ShowDialog() == DialogResult.OK) { //更新记录 dev = dlg.DeviceMx; DataService.Update <WireCategory>(dev); Itop.Common.DataConverter.ObjectToRow(dev, row); } } }
private void simpleButton1_Click(object sender, EventArgs e) { wireType wiretype = new wireType(wirel); if (wiretype.ShowDialog() == DialogResult.OK) { WireCategory wirewire = new WireCategory(); wirewire.WireType = wiretype.WireType; wirewire.WireR = Convert.ToDouble(wiretype.WireR); wirewire.WireTQ = Convert.ToDouble(wiretype.WireTQ); wirewire.WireGNDC = Convert.ToDouble(wiretype.WireGNDC); wirewire.WireChange = Convert.ToInt32(wiretype.WireChange); //wirewire.WireLevel = wirel; wirewire.WireLevel = wiretype.WireLevel; wirewire.SUID = Guid.NewGuid().ToString(); Services.BaseService.Create <WireCategory>(wirewire); } InitData(vri); }
private void spinEdit5_EditValueChanged(object sender, EventArgs e) { comboBoxEdit2.Properties.Items.Clear(); WireCategory wirewire = new WireCategory(); wirewire.Type = "40"; IList list1 = null; wirewire.WireLevel = spinEdit5.Value.ToString(); list1 = UCDeviceBase.DataService.GetList("SelectWireCategoryListBYWireLevel", wirewire); foreach (WireCategory sub in list1) { if (comboBoxEdit2.Properties.Items.IndexOf(sub.WireType) == -1) { comboBoxEdit2.Properties.Items.Add(sub.WireType); } } }
protected void setXL() { WireCategory rc = new WireCategory(); rc.WireLevel = DeviceMx.RateVolt.ToString(); rc.WireType = DeviceMx.LineType; rc.Type = "40"; rc = (WireCategory)UCDeviceBase.DataService.GetObject("SelectWireCategoryByKeyANDWireLevel", rc); if (rc != null) { spinEdit1.Value = (decimal)rc.WireR; spinEdit7.Value = (decimal)rc.WireTQ; spinEdit9.Value = (decimal)rc.WireGNDC; spinEdit13.Value = (decimal)rc.ZeroR; spinEdit12.Value = (decimal)rc.ZeroTQ; spinEdit10.Value = (decimal)rc.ZeroGNDC; spinEdit17.Value = (decimal)rc.WireChange; } }
protected void Init() { object o = new object(); for (int i = -30; i <= 30; i++) { o = System.DateTime.Now.Year + i; comboBoxEdit1.Properties.Items.Add(o); } string con = " where Type='05'AND ProjectID ='" + this.ProjectSUID + "' order by name"; IList list = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con); foreach (PSPDEV dev in list) { if (comboBoxEdit4.Properties.Items.IndexOf(dev.Name) == -1) { comboBoxEdit4.Properties.Items.Add(dev.Name); comboBoxEdit7.Properties.Items.Add(dev.Name); } } WireCategory wirewire = new WireCategory(); wirewire.Type = "65"; IList list1 = null; if (DeviceMx.RateVolt != 0) { wirewire.WireLevel = DeviceMx.RateVolt.ToString(); list1 = UCDeviceBase.DataService.GetList("SelectWireCategoryListBYWireLevel", wirewire); } else { list1 = UCDeviceBase.DataService.GetList("SelectWireCategoryList", wirewire); } foreach (WireCategory sub in list1) { if (comboBoxEdit2.Properties.Items.IndexOf(sub.WireType) == -1) { comboBoxEdit2.Properties.Items.Add(sub.WireType); } } }
private void comboBox22_SelectedIndexChanged(object sender, EventArgs e) { leel.LineLength = Convert.ToDouble(textBox11.Text); leel.LineType = comboBox22.Text; leel.Name = mc.Text; leel.LineStatus = comboBox44.Text; leel.LineLevel = "单回路"; WireCategory wirewire = new WireCategory(); wirewire.WireType = comboBox22.Text; WireCategory wirewire2 = new WireCategory(); wirewire.WireLevel = comboBoxEdit1.Text; wirewire2.WireType = comboBox22.Text; wirewire2 = (WireCategory)Services.BaseService.GetObject("SelectWireCategoryByKeyANDWireLevel", wirewire); if (wirewire2 != null) { leel.LineR = Convert.ToDouble(leel.LineLength) * wirewire2.WireR; leel.LineTQ = Convert.ToDouble(leel.LineLength) * wirewire2.WireTQ; leel.LineGNDC = Convert.ToDouble(leel.LineLength) * wirewire2.WireGNDC; } string tempp = comboBoxEdit1.Text; int tel = tempp.Length; if (tempp.Contains("kV") || tempp.Contains("KV") || tempp.Contains("kv") || tempp.Contains("Kv")) { tempp = tempp.Substring(0, tel - 2); } //pspDev.VoltR = Convert.ToDouble(tempp); leel.VoltR = Convert.ToDouble(tempp); if (comboBoxEdit8.Text == "" || comboBoxEdit8.Text == null) { comboBoxEdit8.Text = "0"; } leel.ReferenceVolt = Convert.ToDouble(comboBoxEdit8.Text); //textBox2.Text= InitData(leel); }
public frmLine(PSPDEV pspDev) { InitializeComponent(); mc.Select(); WireCategory wirewire = new WireCategory(); wirewire.WireLevel = pspDev.VoltR.ToString(); IList list1 = Services.BaseService.GetList("SelectWireCategoryListBYWireLevel", wirewire); foreach (WireCategory sub in list1) { comboBox22.Properties.Items.Add(sub.WireType); } InitData(pspDev); this.comboBox22.SelectedIndexChanged += new System.EventHandler(this.comboBox22_SelectedIndexChanged); this.comboBoxEdit5.SelectedIndexChanged += new System.EventHandler(this.comboBoxEdit5_SelectedIndexChanged); this.textBox11.Leave += new System.EventHandler(this.textBox11_Leave); this.textBox11.TextChanged += new System.EventHandler(this.textBox11_TextChanged); }
private void simpleButton3_Click(object sender, EventArgs e) { if (dataGridView1.CurrentRow != null) { if ((MessageBox.Show(this, "确定要删除线路型号:" + dataGridView1.CurrentRow.Cells[1].Value + "?", "请确认", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes)) { DataTable dt = dataGridView1.DataSource as DataTable; DataRow dr = dt.Rows[rows]; if (dr != null) { WireCategory obj = Itop.Common.DataConverter.RowToObject <WireCategory>(dr); Services.BaseService.Delete <WireCategory>(obj); } InitData(vri); } else { return; } } }
public chaoliuResult() { InitializeComponent(); //gridControl1.DataError += new DataGridViewDataErrorEventHandler(dataGridView1_DataError); //dataGridView1.CellValueChanged += new DataGridViewCellEventHandler(dataGridView1_CellValueChanged); WireCategory wirewire = new WireCategory(); IList list1 = Services.BaseService.GetList("SelectWireCategoryList", wirewire); foreach (WireCategory sub in list1) { repositoryItemComboBox2.Items.Add(sub.WireType); //repositoryItemComboBox2.Items. //repositoryItemComboBox2.add //repositoryItemComboBox1 //lineTypeDataGridViewTextBoxColumn.Items.Add(sub.WireType); //colLineType.ColumnEdit. } string svgUID = "78ea0682-ad15-423b-8c61-68e7d5a6c29b"; InitData(svgUID); }
void dataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex == 0) { DataTable dt = dataGridView1.DataSource as DataTable; DataRow dr = dt.Rows[e.RowIndex]; if (dr != null) { WireCategory obj = Itop.Common.DataConverter.RowToObject <WireCategory>(dr); Services.BaseService.Update <WireCategory>(obj); } // WireCategory wirewire = new WireCategory(); // wirewire.WireType = dataGridView1.EditingControl.Text; // wirewire.WireLevel = wirel; // IList list2 = Services.BaseService.GetList("SelectWireCategoryByKeyANDWireLevel", wirewire); // if (list2.Count == 0) // { // wirewire.SUID = Guid.NewGuid().ToString(); // Services.BaseService.Create<WireCategory>(wirewire); // } ////int temp = dataGridView1.CurrentRow.Index; // InitData(vri); //dataGridView1.CurrentRow.Index = temp; } else { DataTable dt = dataGridView1.DataSource as DataTable; DataRow dr = dt.Rows[e.RowIndex]; if (dr != null) { WireCategory obj = Itop.Common.DataConverter.RowToObject <WireCategory>(dr); Services.BaseService.Update <WireCategory>(obj); } } }
private void comboBox22_SelectedIndexChanged(object sender, EventArgs e) { leel.LineLength = Convert.ToDouble(textBox11.Text); leel.LineType = comboBox22.Text; leel.Name = mc.Text; leel.LineStatus = comboBox44.Text; leel.LineLevel = "单回路"; WireCategory wirewire = new WireCategory(); wirewire.WireType = comboBox22.Text; WireCategory wirewire2 = new WireCategory(); wirewire.WireLevel = comboBoxEdit5.Text; wirewire2.WireType = comboBox22.Text; wirewire2 = (WireCategory)Services.BaseService.GetObject("SelectWireCategoryByKeyANDWireLevel", wirewire); if (wirewire2 != null) { leel.LineR = Convert.ToDouble(leel.LineLength) * wirewire2.WireR; leel.LineTQ = Convert.ToDouble(leel.LineLength) * wirewire2.WireTQ; leel.LineGNDC = Convert.ToDouble(leel.LineLength) * wirewire2.WireGNDC; leel.PositiveTQ = Convert.ToDouble(leel.LineLength) * wirewire2.WireTQ; leel.ZeroTQ = leel.PositiveTQ * 3; } string tempp = comboBoxEdit5.Text; int tel = tempp.Length; //tempp = tempp.Substring(0, tel - 2); //pspDev.VoltR = Convert.ToDouble(tempp); leel.VoltR = Convert.ToDouble(tempp); //textBox2.Text= InitData(leel); }
protected void setXL() { WireCategory rc = new WireCategory(); rc.WireLevel = DeviceMx.RateVolt.ToString(); rc.WireType = DeviceMx.LineType; rc.Type = "40"; rc = (WireCategory)UCDeviceBase.DataService.GetObject("SelectWireCategoryByKeyANDWireLevel", rc); if (rc != null) { spinEdit1.Value = (decimal)rc.WireR; spinEdit7.Value = (decimal)rc.WireTQ; spinEdit9.Value = (decimal)rc.WireGNDC; spinEdit13.Value = (decimal)rc.ZeroR; spinEdit12.Value = (decimal)rc.ZeroTQ; spinEdit10.Value = (decimal)rc.ZeroGNDC; spinEdit17.Value = (decimal)rc.WireChange; if (radioGroup3.SelectedIndex == 0) { spinEdit16.Value = spinEdit1.Value * spinEdit6.Value * 100 / (spinEdit11.Value * spinEdit11.Value); spinEdit15.Value = spinEdit7.Value * spinEdit6.Value * 100 / (spinEdit11.Value * spinEdit11.Value); spinEdit14.Value = spinEdit9.Value * spinEdit6.Value * (spinEdit11.Value * spinEdit11.Value) / 100000000 / 2; spinEdit4.Value = spinEdit13.Value * spinEdit6.Value * 100 / (spinEdit11.Value * spinEdit11.Value); spinEdit3.Value = spinEdit12.Value * spinEdit6.Value * 100 / (spinEdit11.Value * spinEdit11.Value); spinEdit2.Value = spinEdit10.Value * spinEdit6.Value * (spinEdit11.Value * spinEdit11.Value) / 100000000 / 2; } else { spinEdit16.Value = spinEdit1.Value * spinEdit6.Value; spinEdit15.Value = spinEdit7.Value * spinEdit6.Value; spinEdit14.Value = spinEdit9.Value * spinEdit6.Value / 2; spinEdit4.Value = spinEdit13.Value * spinEdit6.Value; spinEdit3.Value = spinEdit12.Value * spinEdit6.Value; spinEdit2.Value = spinEdit10.Value * spinEdit6.Value / 2; } } }
private void initcom() { if (type == "line") { label3.Text = "线路名称"; label2.Text = "线路长度"; label15.Visible = true; comboBoxEdit8.Visible = true; label1.Visible = false; spinEdit2.Visible = false; WireCategory wirewire = new WireCategory(); IList list1 = null; if (volt != 0) { wirewire.WireLevel = ((int)volt).ToString(); list1 = Services.BaseService.GetList("SelectWireCategoryListBYWireLevel", wirewire); } else { list1 = Services.BaseService.GetList("SelectWireCategoryList", wirewire); } foreach (WireCategory sub in list1) { comboBoxEdit8.Properties.Items.Add(sub.WireType); } } else if (type == "sub") { label3.Text = "变电站名称"; label2.Text = "容量"; label15.Visible = false; comboBoxEdit8.Visible = false; label1.Visible = true; spinEdit2.Visible = true; } this.gridControl1.DataSource = dt; }
private void simpleButton1_MouseDown(object sender, MouseEventArgs e) { if (textBox1.Text == "" || textBox1.Text == null) { MessageBox.Show("名称不能为空。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } else { WireCategory wirewire = new WireCategory(); wirewire.WireLevel = WireLevel; IList list = Services.BaseService.GetList("SelectWireCategoryListBYWireLevel", wirewire); foreach (WireCategory wire in list) { if (wire.WireType == textBox1.Text) { MessageBox.Show("型号不能重复。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } } this.DialogResult = DialogResult.OK; } }
public override void UpdateIn(DataTable table) { for (int i = 0; i < table.Rows.Count; i++) { if (table.Rows[i][0].ToString().IndexOf("合计") > 0 || table.Rows[i][1].ToString().IndexOf("合计") > 0) { continue; } WireCategory area = new WireCategory(); area.Type = "40"; foreach (DataColumn col in table.Columns) { if (table.Rows[i][col] != null) { Type type = area.GetType().GetProperty(col.ColumnName).PropertyType; //.GetValue(area, null).GetType(); if (type == typeof(int)) { area.GetType().GetProperty(col.ColumnName).SetValue(area, int.Parse(table.Rows[i][col].ToString()), null); } else if (type == typeof(string)) { area.GetType().GetProperty(col.ColumnName).SetValue(area, table.Rows[i][col], null); } else if (type == typeof(decimal)) { area.GetType().GetProperty(col.ColumnName).SetValue(area, decimal.Parse(table.Rows[i][col].ToString()), null); } else { area.GetType().GetProperty(col.ColumnName).SetValue(area, double.Parse(table.Rows[i][col].ToString()), null); } } } DataService.Create <WireCategory>(area); } }