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("�����ʽ����ȷ��"); }
}
