public void Initdata()
{
dt.Clear();
dt.Columns.Add("ID");
dt.Columns.Add("Name");
dt.Columns.Add("Class");
dt.Columns.Add("FileType");
dt.Columns.Add("Check", typeof(bool));
PSP_ELCPROJECT pr = new PSP_ELCPROJECT();
pr.ProjectID = this.ProjectID;
IList list = Services.BaseService.GetList("SelectPSP_ELCPROJECTList", pr);
foreach (PSP_ELCPROJECT pe in list)
{
DataRow row = dt.NewRow();
row["ID"] = pe.ID;
row["Name"] = pe.Name;
row["Class"] = pe.Class;
row["FileType"] = pe.FileType;
row["Check"] = false;
dt.Rows.Add(row);
}
gridControl1.DataSource = dt;
}
protected override void Edit()
{
TreeListNode node = treeList1.FocusedNode;
if (node != null)
{
string id = node["ID"].ToString();
PSP_ELCPROJECT pd = new PSP_ELCPROJECT();
pd.ID = id;
pd.Name = node["Name"].ToString();
pd.Class = node["Class"].ToString();
pd.FileType = node["FileType"].ToString();
pd.ProjectID = node["ProjectID"].ToString();
frmNewProject frmprojectDLG = new frmNewProject();
frmprojectDLG.Name = pd.Name;
frmprojectDLG.FileType = pd.FileType;
if (frmprojectDLG.ShowDialog() == DialogResult.OK)
{
node["Name"] = frmprojectDLG.Name;
pd.Name = frmprojectDLG.Name;
pd.FileType = frmprojectDLG.FileType;
UCDeviceBase.DataService.Update("UpdatePSP_ELCPROJECT", pd);
SVGFILE svgFile = new SVGFILE();
svgFile.SUID = pd.ID;
svgFile = (SVGFILE)Services.BaseService.GetObject("SelectSVGFILEByKey", svgFile);
if (svgFile != null)
{
svgFile.FILENAME = pd.Name;
UCDeviceBase.DataService.Update <SVGFILE>(svgFile);
}
treeList1.Refresh();
}
}
}
protected override void Del()
{
TreeListNode node = treeList1.FocusedNode;
if (node != null)
{
if (MessageBox.Show("确定删除么?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
string id = node["ID"].ToString();
treeList1.DeleteNode(treeList1.FocusedNode);
PSP_ELCPROJECT pd = new PSP_ELCPROJECT();
pd.ID = id;
UCDeviceBase.DataService.Delete <PSP_ELCPROJECT>(pd);
//删除和其相连的设备记录
string con = "where ProjectSUID = '" + pd.ID + "'";
IList list = Services.BaseService.GetList("SelectPSP_ElcDeviceByCondition", con);
foreach (PSP_ElcDevice pe in list)
{
UCDeviceBase.DataService.Delete <PSP_ElcDevice>(pe);
}
//删除和其相关的图形记录
SVGFILE svgFile = new SVGFILE();
svgFile.SUID = pd.ID;
svgFile = (SVGFILE)Services.BaseService.GetObject("SelectSVGFILEByKey", svgFile);
if (svgFile != null)
{
UCDeviceBase.DataService.Delete <SVGFILE>(svgFile);
}
treeList1.FocusedNode = null;
strID = null;
}
}
}
private void barButtonItem3_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
DataRow node = gridView1.GetDataRow(gridView1.FocusedRowHandle);;
if (node != null)
{
if (MessageBox.Show("确定删除么?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
string id = node["ID"].ToString();
dataSvg.Rows.Remove(node);
PSP_ELCPROJECT pd = new PSP_ELCPROJECT();
pd.ID = id;
UCDeviceBase.DataService.Delete <PSP_ELCPROJECT>(pd);
//删除和其相连的设备记录
string con = "where ProjectSUID = '" + pd.ID + "'";
IList list = Services.BaseService.GetList("SelectPSP_ElcDeviceByCondition", con);
foreach (PSP_ElcDevice pe in list)
{
UCDeviceBase.DataService.Delete <PSP_ElcDevice>(pe);
}
//删除和其相关的图形记录
SVGFILE svgFile = new SVGFILE();
svgFile.SUID = pd.ID;
svgFile = (SVGFILE)Services.BaseService.GetObject("SelectSVGFILEByKey", svgFile);
if (svgFile != null)
{
UCDeviceBase.DataService.Delete <SVGFILE>(svgFile);
}
}
}
}
public void Initdata()
{
PSP_ELCPROJECT pr = new PSP_ELCPROJECT();
pr.ProjectID = this.ProjectID;
IList list = Services.BaseService.GetList("SelectPSP_ELCPROJECTList", pr);
DataTable dataSvg = Itop.Common.DataConverter.ToDataTable(list, typeof(PSP_ELCPROJECT));
gridControl1.DataSource = dataSvg;
}
private void InitGridData_SH(PSP_ELCPROJECT prj)
{
if (!tucengflag)
{
this.ctrlSubstation_Info1.GridView.GroupPanelText = "变压器可靠性检验表";
}
this.ctrlSubstation_Info1.ProjectID = Itop.Client.MIS.ProgUID;
this.ctrlSubstation_Info1.Flag = selectid;
ctrlSubstation_Info1.xmlflag = "guihua";
this.ctrlSubstation_Info1.RefreshData1(prj);
}
public void InitData()
{
PSP_ELCPROJECT pj = new PSP_ELCPROJECT();
pj.ProjectID = ProjectSUID;
IList list = UCDeviceBase.DataService.GetList("SelectPSP_ELCPROJECTList", pj);
DataTable dt = Itop.Common.DataConverter.ToDataTable(list, typeof(PSP_ELCPROJECT));
lookUpEdit1.Properties.DataSource = dt;
lookUpEdit1.ItemIndex = 0;
lookUpEdit1.Properties.DisplayMember = "Name";
lookUpEdit1.Properties.ValueMember = "ID";
}
private void barCopy_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
TreeListNode node = treeList1.FocusedNode;
if (node == null)
{
MessageBox.Show("请先选择电气计算方案！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
else
{
if (MessageBox.Show("是否复制方案：" + node["Name"].ToString() + "?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
string name = "副本" + node["Name"].ToString();
string strC = " Name like '" + name + "%'";
IList list1 = UCDeviceBase.DataService.GetList("SelectPSP_ELCPROJECTByWhere", strC);
if (list1.Count > 0)
{
name = "副本" + node["Name"].ToString() + "-" + list1.Count.ToString();
}
string strCon = " WHERE ProjectSUID = '" + node["ID"].ToString() + "'";
IList list = UCDeviceBase.DataService.GetList("SelectPSP_ElcDeviceByCondition", strCon);
PSP_ELCPROJECT elcPro = new PSP_ELCPROJECT();
elcPro.FileType = node["FileType"].ToString();
elcPro.Name = name;
elcPro.ProjectID = Itop.Client.MIS.ProgUID;
elcPro.Class = System.DateTime.Now.ToString();
DataRow row = datatable.NewRow();
Itop.Common.DataConverter.ObjectToRow(elcPro, row);
datatable.Rows.Add(row);
UCDeviceBase.DataService.Create <PSP_ELCPROJECT>(elcPro);
SVGFILE svg = UCDeviceBase.DataService.GetOneByKey <SVGFILE>(node["ID"].ToString());
SVGFILE svgNew = new SVGFILE();
svgNew.SUID = elcPro.ID;
svgNew.FILENAME = elcPro.Name;
svgNew.SVGDATA = svg.SVGDATA;
UCDeviceBase.DataService.Create <SVGFILE>(svgNew);
foreach (PSP_ElcDevice elcDEV in list)
{
PSP_ElcDevice elcElement = new PSP_ElcDevice();
elcElement.ProjectSUID = elcPro.ID;
elcElement.DeviceSUID = elcDEV.DeviceSUID;
UCDeviceBase.DataService.Create <PSP_ElcDevice>(elcElement);
}
}
return;
}
}
private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
DataRow node = gridView1.GetDataRow(gridView1.FocusedRowHandle);
if (node != null)
{
string id = node["ID"].ToString();
PSP_ELCPROJECT pd = new PSP_ELCPROJECT();
pd.ID = id;
pd.Name = node["Name"].ToString();
pd.Class = node["Class"].ToString();
pd.FileType = node["FileType"].ToString();
pd.BelongYear = node["BelongYear"].ToString();
pd.ProjectID = node["ProjectID"].ToString();
frmNewProject frmprojectDLG = new frmNewProject();
if (pd.FileType == "潮流")
{
frmprojectDLG.flag = false;
}
else
{
frmprojectDLG.flag = true;
}
frmprojectDLG.Name = pd.Name;
frmprojectDLG.FileType = pd.FileType;
frmprojectDLG.BelongYear = pd.BelongYear;
frmprojectDLG.init();
if (frmprojectDLG.ShowDialog() == DialogResult.OK)
{
node["Name"] = frmprojectDLG.Name;
pd.Name = frmprojectDLG.Name;
pd.FileType = frmprojectDLG.FileType;
pd.BelongYear = frmprojectDLG.BelongYear;
node["BelongYear"] = frmprojectDLG.BelongYear;
UCDeviceBase.DataService.Update("UpdatePSP_ELCPROJECT", pd);
SVGFILE svgFile = new SVGFILE();
svgFile.SUID = pd.ID;
svgFile = (SVGFILE)Services.BaseService.GetObject("SelectSVGFILEByKey", svgFile);
if (svgFile != null)
{
svgFile.FILENAME = pd.Name;
UCDeviceBase.DataService.Update <SVGFILE>(svgFile);
}
}
}
}
/// <summary>
/// 刷新表格中的数据
/// </summary>
/// <returns>ture:成功 false:失败</returns>
public bool RefreshData1(PSP_ELCPROJECT proj)
{
try
{
string filepath = "";
// IList<Substation_Info> list = UCDeviceBase.DataService.GetList<Substation_Info>("SelectSubstation_InfoByFlag",flags1);
string con = " AreaID = '" + Itop.Client.MIS.ProgUID + "' AND UID IN (SELECT PSPDEV.SVGUID FROM PSPDEV, PSP_ELCDEVICE WHERE PSPDEV.SUID = PSP_ELCDEVICE.DeviceSUID AND PSP_ELCDEVICE.ProjectSUID = '" + proj.ID + "'AND Type='01')";
IList <Substation_Info> list = UCDeviceBase.DataService.GetList <Substation_Info>("SelectSubstation_InfoByCon", con);
for (int i = 0; i < list.Count; i++)
{
Substation_Info sb = (Substation_Info)list[i];
if (Convert.ToInt32(sb.L2) != 0 && sb.L2 != null)
{
sb.L10 = Convert.ToDouble(Convert.ToDouble(sb.L9) / sb.L2 * 100);
//sb.GetType().GetProperty("L10").SetValue(sb, LL10, null);
}
else
{
sb.L10 = 0;
}
}
if (xmlflag == "guihua")
{
filepath = Path.GetTempPath() + "\\" + Path.GetFileName("SubstationGuiHua.xml");
}
else
{
filepath = Path.GetTempPath() + "\\" + Path.GetFileName("SubstationLayOut11.xml");
}
if (File.Exists(filepath))
{
this.bandedGridView1.RestoreLayoutFromXml(filepath);
}
this.gridControl.DataSource = list;
}
catch (Exception exc)
{
Debug.Fail(exc.Message);
HandleException.TryCatch(exc);
return(false);
}
return(true);
}
public void Initdata(bool flag)
{
PSP_ELCPROJECT pr = new PSP_ELCPROJECT();
pr.ProjectID = this.ProjectID;
if (flag)
{
pr.FileType = "短路";
}
else
{
pr.FileType = "潮流";
}
IList list = Services.BaseService.GetList("SelectPSP_ELCPROJECTByProjectIDandfiletype", pr);
DataTable dataSvg = Itop.Common.DataConverter.ToDataTable(list, typeof(PSP_ELCPROJECT));
gridControl1.DataSource = dataSvg;
}
protected override void Add()
{
frmNewProject frmprojectDLG = new frmNewProject();
frmprojectDLG.Name = "";
if (frmprojectDLG.ShowDialog() == DialogResult.OK)
{
PSP_ELCPROJECT pd = new PSP_ELCPROJECT();
pd.Name = frmprojectDLG.Name;
pd.FileType = frmprojectDLG.FileType;
pd.Class = System.DateTime.Now.ToString();
pd.ProjectID = Itop.Client.MIS.ProgUID;
UCDeviceBase.DataService.Create <PSP_ELCPROJECT>(pd);
DataRow row = datatable.NewRow();
Itop.Common.DataConverter.ObjectToRow(pd, row);
datatable.Rows.Add(row);
}
}
private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
frmNewProject frmprojectDLG = new frmNewProject();
frmprojectDLG.flag = pspflag;
frmprojectDLG.init();
frmprojectDLG.Name = "";
if (frmprojectDLG.ShowDialog() == DialogResult.OK)
{
PSP_ELCPROJECT pd = new PSP_ELCPROJECT();
pd.Name = frmprojectDLG.Name;
pd.FileType = frmprojectDLG.FileType;
pd.Class = System.DateTime.Now.ToString();
pd.BelongYear = frmprojectDLG.BelongYear;
pd.ProjectID = Itop.Client.MIS.ProgUID;
UCDeviceBase.DataService.Create <PSP_ELCPROJECT>(pd);
DataRow row = dataSvg.NewRow();
Itop.Common.DataConverter.ObjectToRow(pd, row);
dataSvg.Rows.Add(row);
}
}
public void Biandianzhan()
{
tucengflag = false;
splitContainerControl1.PanelVisibility = DevExpress.XtraEditors.SplitPanelVisibility.Panel2;
barSubItem1.Visibility = DevExpress.XtraBars.BarItemVisibility.Never;
selectid = "10000"; //为现状变电站
selectname = "现状表";
leixing = "运行";
PSPProject pd = new PSPProject();
pd.ProjectID = this.ProjectUID;
pd.Initdata(false);
if (pd.ShowDialog() == DialogResult.OK)
{
strID = pd.FileSUID;
parentobj = pd.Parentobj;
this.Text = "方案-" + parentobj.Name;
this.Show();
InitGridData_SH(parentobj);
}
}
public void PspProject()
{
this.Show();
this.WindowState = FormWindowState.Maximized;
PSPProject pd = new PSPProject();
pd.ProjectID = this.ProjectUID;
pd.Initdata(false);
filetype = "潮流";
if (pd.ShowDialog() == DialogResult.OK)
{
strID = pd.FileSUID;
parentobj = pd.Parentobj;
this.Text = "潮流计算-" + parentobj.Name;
initbar(true);
}
else
{
this.Close();
}
}
/// <summary>
/// 初始设备分类
/// </summary>
private void InitDeviceType()
{
TreeListColumn column = new TreeListColumn();
column.Caption = "项目名称";
column.FieldName = "Name";
column.VisibleIndex = 0;
column.Width = 180;
column.OptionsColumn.AllowEdit = false;
column.OptionsColumn.AllowSort = false;
this.treeList1.Columns.AddRange(new TreeListColumn[] {
column
});
PSP_ELCPROJECT pj = new PSP_ELCPROJECT();
pj.ProjectID = Itop.Client.MIS.ProgUID;
IList list = UCDeviceBase.DataService.GetList("SelectPSP_ELCPROJECTList", pj);
datatable = Itop.Common.DataConverter.ToDataTable(list, typeof(PSP_ELCPROJECT));
treeList1.DataSource = datatable;
// DeviceTypeHelper.InitDeviceTypes(treeList2);
DeviceTypeHelper.initprojectDeviceTypes_SH(treeList2);
}
