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