private void barButtonItem3_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (gridView1.FocusedRowHandle < 0) { return; } if (!base.DeleteRight) { MsgBox.Show("您没有权限进行此项操作!"); return; } if (MsgBox.ShowYesNo("是否删除 " + gridView1.GetDataRow(gridView1.FocusedRowHandle)["ListName"]) == DialogResult.No) { return; } PowerEachList report = Itop.Common.DataConverter.RowToObject<PowerEachList>(gridView1.GetDataRow(gridView1.FocusedRowHandle)); try { Common.Services.BaseService.Update("DeletePowerEachList_BigUser", report); PSP_BigUser_Types psp_Type = new PSP_BigUser_Types(); psp_Type.S2 = "S2 LIKE '%" + (Convert.ToInt32(report.ListName)) + "%' and ItemID=" + ItemID; IList listTypes = Common.Services.BaseService.GetList("SelectPSP_BigUser_TypesByItemID", psp_Type); foreach (PSP_BigUser_Types psp_Typetemp in listTypes) { psp_Type = psp_Typetemp; string[] yearitem = psp_Typetemp.S2.Split(','); if (yearitem.Length == 1) //DeletePSP_ValuesByType里面删除数据和分类 Common.Services.BaseService.Delete<PSP_BigUser_Types>(psp_Typetemp); else { psp_Type.S2 = ""; foreach (string strtemp in yearitem) { if (strtemp != report.ListName) { if (psp_Type.S2 == "") { psp_Type.S2 = strtemp; } else psp_Type.S2 += "," + strtemp; } } Common.Services.BaseService.Update<PSP_BigUser_Types>(psp_Type); } } gridView1.DeleteRow(gridView1.FocusedRowHandle); } catch (Exception ex) { MsgBox.Show("删除出错:" + ex.Message); } }
private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (!base.AddRight) { MsgBox.Show("您没有权限进行此项操作!"); return; } FormForecastReport_BigUser frm = new FormForecastReport_BigUser(); frm.IsEdit = false; frm.TypeFlag = typeFlag; frm.Text = "添加项目计划表名称"; // frm.TypeText = "负荷"; if (frm.ShowDialog() == DialogResult.OK) { DataRow newRow = dataTable.NewRow(); Itop.Common.DataConverter.ObjectToRow(frm.Psp_ForecastReport, newRow); dataTable.Rows.Add(newRow); gridView1.FocusedRowHandle = gridView1.RowCount - 1; PSP_BigUser_Types psp_Type = new PSP_BigUser_Types(); psp_Type.S2 = "S2 LIKE '%" + (Convert.ToInt32(frm.Psp_ForecastReport.ListName) - 1)+ "%' and ItemID="+ItemID; IList listTypes = Common.Services.BaseService.GetList("SelectPSP_BigUser_TypesByItemID", psp_Type); foreach (PSP_BigUser_Types psp_Typetemp in listTypes) { psp_Type = psp_Typetemp; if (psp_Type.S2 != "" && !psp_Type.S2.Contains(frm.Psp_ForecastReport.ListName)) { psp_Type.S2 += "," + frm.Psp_ForecastReport.ListName; } Common.Services.BaseService.Update<PSP_BigUser_Types>(psp_Type); } } }
private void barButtonItem3_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (treeList1.FocusedNode == null) { return; } if (treeList1.FocusedNode.HasChildren) { MsgBox.Show("�˷��������ӷ��࣬����ɾ���ӷ��࣡"); return; } if (!DeleteRight) { MsgBox.Show("��û��Ȩ���д��������"); return; } if (MsgBox.ShowYesNo("�Ƿ�ɾ������ " + treeList1.FocusedNode.GetValue("Title") + "��") == DialogResult.Yes) { PSP_BigUser_Types psp_Type = new PSP_BigUser_Types(); Class1.TreeNodeToDataObject<PSP_BigUser_Types>(psp_Type, treeList1.FocusedNode); PSP_BigUser_Values psp_Values = new PSP_BigUser_Values(); psp_Values.TypeID = psp_Type.ID; psp_Values.Flag2 = typeFlag; psp_Values.ItemID = ItemID; try { string[] yearitem = psp_Type.S2.Split(','); if (yearitem.Length == 1) //DeletePSP_ValuesByType����ɾ�����ݺͷ��� Common.Services.BaseService.Update("DeletePSP_BigUser_ValuesByType", psp_Values); else { psp_Type.S2 = ""; foreach(string strtemp in yearitem) { if (strtemp != typeFlag.ToString()) { if (psp_Type.S2 == "") { psp_Type.S2 = strtemp; } else psp_Type.S2 += "," + strtemp; } } Common.Services.BaseService.Update<PSP_BigUser_Types>(psp_Type); Common.Services.BaseService.Update("DeletePSP_BigUser_ValuesByType2", psp_Values); } //TreeListNode brotherNode = null; //if (treeList1.FocusedNode.ParentNode.Nodes.Count > 1) //{ // brotherNode = treeList1.FocusedNode.PrevNode; // if (brotherNode == null) // { // brotherNode = treeList1.FocusedNode.NextNode; // } //} treeList1.DeleteNode(treeList1.FocusedNode); //ɾ�������ͬ�������������࣬�����¼������������������ //if (brotherNode != null) //{ // foreach (TreeListColumn column in treeList1.Columns) // { // if (column.FieldName.IndexOf("��") > 0) // { // CalculateSum(brotherNode, column); // } // } //} } catch (Exception ex) { MsgBox.Show("ɾ�������" + ex.Message); } } }
private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (treeList1.FocusedNode == null) { return; } if (!EditRight) { MsgBox.Show("��û��Ȩ���д��������"); return; } FormTypeTitleRemark frm = new FormTypeTitleRemark(); frm.TypeTitle = treeList1.FocusedNode.GetValue("Title").ToString(); if(treeList1.FocusedNode.GetValue("S1")!=DBNull.Value) frm.TypeRemark = treeList1.FocusedNode.GetValue("S1").ToString(); frm.Text = "�ķ�����"; PSP_BigUser_Types psp_Type = new PSP_BigUser_Types(); psp_Type.S1 = frm.TypeRemark; psp_Type.Title = frm.TypeTitle; psp_Type.ItemID = ItemID; psp_Type.S2 = Convert.ToString(treeList1.FocusedNode.GetValue("S2")); psp_Type.ID =Convert.ToInt32( treeList1.FocusedNode.GetValue("ID")); if (frm.ShowDialog() == DialogResult.OK) { psp_Type.Title = frm.TypeTitle; psp_Type.S1 = frm.TypeRemark; PSP_BigUser_Types psp_Typetemp = new PSP_BigUser_Types(); psp_Typetemp=(PSP_BigUser_Types)Common.Services.BaseService.GetObject("SelectPSP_BigUser_TypesByTitleItemID", psp_Type); if (psp_Typetemp != null) { if (psp_Type.ID != psp_Typetemp.ID) { MsgBox.Show("�������û��Ѿ�����"); return; } } try { Common.Services.BaseService.Update<PSP_BigUser_Types>(psp_Type); treeList1.FocusedNode.SetValue("Title", frm.TypeTitle); } catch (Exception ex) { MsgBox.Show("�ij����" + ex.Message); } } }
private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (!AddRight) { MsgBox.Show("��û��Ȩ���д��������"); return; } FormTypeTitleRemark frm = new FormTypeTitleRemark(); frm.Text = "���Ӵ��û�"; if (frm.ShowDialog() == DialogResult.OK) { PSP_BigUser_Types psp_Type = new PSP_BigUser_Types(); PSP_BigUser_Types psp_Type2 = new PSP_BigUser_Types(); psp_Type.Title = frm.TypeTitle; psp_Type.S1 = frm.TypeRemark; psp_Type.ItemID = ItemID; if (Common.Services.BaseService.GetObject("SelectPSP_BigUser_TypesByTitleItemID", psp_Type) == null) { try { psp_Type.S2 = typeFlag.ToString(); Common.Services.BaseService.Create("InsertPSP_BigUser_Types", psp_Type); psp_Type2 = (PSP_BigUser_Types)Common.Services.BaseService.GetObject("SelectPSP_BigUser_TypesByTitleItemID", psp_Type); psp_Type.ID = psp_Type2.ID; dataTable.Rows.Add(Itop.Common.DataConverter.ObjectToRow(psp_Type, dataTable.NewRow())); } catch (Exception ex) { MsgBox.Show("���Ӵ��û������" + ex.Message); } } else { psp_Type2 =(PSP_BigUser_Types)Common.Services.BaseService.GetObject("SelectPSP_BigUser_TypesByTitleItemID", psp_Type); if(psp_Type2.S2.Contains(typeFlag.ToString())) { MsgBox.Show("�������û��Ѿ�����"); return; } else { psp_Type.ID = psp_Type2.ID; if (psp_Type2.S2 != "") psp_Type.S2 = psp_Type2.S2 + "," + typeFlag.ToString(); Common.Services.BaseService.Update<PSP_BigUser_Types>(psp_Type); dataTable.Rows.Add(Itop.Common.DataConverter.ObjectToRow(psp_Type, dataTable.NewRow())); } } } }
private void LoadData() { string baseyear = ""; if (dataTable != null) { dataTable.Columns.Clear(); treeList1.Columns.Clear(); } PSP_BigUser_Types psp_Type = new PSP_BigUser_Types(); psp_Type.S2 = "S2 LIKE '%" + typeFlag + "%' and ItemID='" + ItemID+"'"; IList listTypes = Common.Services.BaseService.GetList("SelectPSP_BigUser_TypesByItemID", psp_Type); dataTable = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(PSP_BigUser_Types)); treeList1.DataSource = dataTable; treeList1.Columns["Title"].Caption = "�����"; treeList1.Columns["Title"].Width = 180; treeList1.Columns["Title"].OptionsColumn.AllowEdit = false; treeList1.Columns["Title"].OptionsColumn.AllowSort = false; treeList1.Columns["Flag"].VisibleIndex = -1; treeList1.Columns["Flag"].OptionsColumn.ShowInCustomizationForm = false; treeList1.Columns["Flag2"].VisibleIndex = -1; treeList1.Columns["Flag2"].OptionsColumn.ShowInCustomizationForm = false; treeList1.Columns["S1"].VisibleIndex = -1; treeList1.Columns["S1"].OptionsColumn.ShowInCustomizationForm = false; treeList1.Columns["S2"].VisibleIndex = -1; treeList1.Columns["S2"].OptionsColumn.ShowInCustomizationForm = false; treeList1.Columns["S3"].VisibleIndex = -1; treeList1.Columns["S3"].OptionsColumn.ShowInCustomizationForm = false; treeList1.Columns["S4"].VisibleIndex = -1; treeList1.Columns["S4"].OptionsColumn.ShowInCustomizationForm = false; treeList1.Columns["S5"].VisibleIndex = -1; treeList1.Columns["S5"].OptionsColumn.ShowInCustomizationForm = false; treeList1.Columns["ItemID"].VisibleIndex = -1; treeList1.Columns["ItemID"].OptionsColumn.ShowInCustomizationForm = false; PSP_BigUser_Years psp_Year = new PSP_BigUser_Years(); IList<PSP_BigUser_Years> listYears; psp_Year.Flag = typeFlag; psp_Year.ItemID= ItemID; listYears = Common.Services.BaseService.GetList<PSP_BigUser_Years>("SelectPSP_BigUser_YearsListByFlag", psp_Year); foreach (PSP_BigUser_Years item in listYears) { AddColumn(item.Year); } Application.DoEvents(); LoadValues(true); treeList1.ExpandAll(); }
private void InsertSubstation_Info() { string columnname = ""; try { DataTable dts = new DataTable(); OpenFileDialog op = new OpenFileDialog(); op.Filter = "Excel�ļ�(*.xls)|*.xls"; if (op.ShowDialog() == DialogResult.OK) { WaitDialogForm wait = new WaitDialogForm("", "���ڵ�������, ���Ժ�..."); dts = GetExcel(op.FileName); //DateTime s8 = DateTime.Now; for (int i = 0; i < dts.Rows.Count; i++) { PSP_BigUser_Values l1 = new PSP_BigUser_Values(); int treelistid=0; if (dts.Rows[i]["Title"] != null) if(dts.Rows[i]["Title"].ToString()!="") { PSP_BigUser_Types psp_Type = new PSP_BigUser_Types(); PSP_BigUser_Types psp_Type2 = new PSP_BigUser_Types(); psp_Type.Title = dts.Rows[i]["Title"].ToString(); psp_Type.ItemID = ItemID; if (Common.Services.BaseService.GetObject("SelectPSP_BigUser_TypesByTitleItemID", psp_Type) == null) { psp_Type.S2 = typeFlag.ToString(); Common.Services.BaseService.Create("InsertPSP_BigUser_Types", psp_Type); } else { psp_Type2 = (PSP_BigUser_Types)Common.Services.BaseService.GetObject("SelectPSP_BigUser_TypesByTitleItemID", psp_Type); if (!psp_Type2.S2.Contains(typeFlag.ToString())) { psp_Type.ID = psp_Type2.ID; if (psp_Type2.S2 != "") psp_Type.S2 = psp_Type2.S2 + "," + typeFlag.ToString(); Common.Services.BaseService.Update<PSP_BigUser_Types>(psp_Type); } } psp_Type = (PSP_BigUser_Types)Common.Services.BaseService.GetObject("SelectPSP_BigUser_TypesByTitleItemID", psp_Type); if(psp_Type!=null) treelistid=psp_Type.ID; } foreach (DataColumn dc in dts.Columns) { columnname = dc.ColumnName; if (dts.Rows[i][dc.ColumnName].ToString() == "") continue; PSP_BigUser_Years biguseryear = new PSP_BigUser_Years(); if (columnname != "Title") { biguseryear.Year = columnname ; biguseryear.Flag = typeFlag; biguseryear.ItemID = ItemID; if (Common.Services.BaseService.GetObject("SelectPSP_BigUser_YearsByYearFlag", biguseryear) == null) { Common.Services.BaseService.Create<PSP_BigUser_Years>(biguseryear); // AddColumn(columnname); } } switch (dc.ColumnName) { case "Title": break; default: double LL2 = 0; try { LL2 = Convert.ToDouble(dts.Rows[i][dc.ColumnName].ToString()); if (columnname != "Title") { l1.Value= LL2; l1.ItemID=ItemID; l1.TypeID=treelistid; l1.Flag2=typeFlag; l1.Year= columnname; Common.Services.BaseService.Update<PSP_BigUser_Values>(l1); } } catch { } break; } } } wait.Close(); //foreach (Substation_Info lwl in lii) //{ // Substation_Info l1 = new Substation_Info(); // // l1.AreaName = lwl.AreaName; // l1.Title = lwl.Title; // l1.Flag = lwl.Flag; // //l1.L1 = lwl.L1; // object obj = Services.BaseService.GetObject("SelectSubstation_InfoByTitleFlag", l1); // if (obj != null) // { // lwl.UID = ((Substation_Info)obj).UID; // lwl.Code = ((Substation_Info)obj).Code; // Services.BaseService.Update("UpdateSubstation_InfoAreaName", lwl); // } // else // { // Services.BaseService.Create<Substation_Info>(lwl); // } //} //this.ctrlSubstation_Info_TongLing1.RefreshData1(); wait = new WaitDialogForm("", "���ڼ�������, ���Ժ�..."); this.Cursor = Cursors.WaitCursor; LoadData(); this.Cursor = Cursors.Default; wait.Close(); } } catch (Exception ex) { MsgBox.Show(columnname + ex.Message); MsgBox.Show("�����ʽ����ȷ��"); } }