/// <summary> /// �Ľ������ /// </summary> public void UpdateObject() { //��ȡ������� PSP_VolumeBalance_Calc obj = FocusedObject; if (obj == null) { return; } PSP_VolumeBalance_Calc objtemp = new PSP_VolumeBalance_Calc (); objtemp.Title = obj.Title; objtemp.Type = obj.Type; //���������һ������ PSP_VolumeBalance_Calc objCopy = new PSP_VolumeBalance_Calc(); DataConverter.CopyTo<PSP_VolumeBalance_Calc>(obj, objCopy); //ִ���IJ��� using (FrmPSP_VolumeBalance_CalcDialog dlg = new FrmPSP_VolumeBalance_CalcDialog()) { dlg.Object = objCopy; //���� dlg.Type = type; dlg.CtrTitle = ctrtitle; dlg.FormTitle = FormTitle; if (type == "1" && dy == "220") dlg.editorRow2.Visible = true; if (dlg.ShowDialog() != DialogResult.OK) { return; } } //�ø������½������ DataConverter.CopyTo<PSP_VolumeBalance_Calc>(objCopy, obj); //ˢ�±�� SaveSum(); gridControl.RefreshDataSource(); if (objtemp.Title!=obj.Title) if (obj.Type == "1") { IList<PSP_VolumeBalance_Calc> list = Services.BaseService.GetList<PSP_VolumeBalance_Calc>("SelectPSP_VolumeBalance_CalcByTypeTitle", objtemp); foreach (PSP_VolumeBalance_Calc pvm in list) { PSP_VolumeBalance_Calc pvc = new PSP_VolumeBalance_Calc(); pvc = pvm; pvc.Title = obj.Title; Services.BaseService.Update<PSP_VolumeBalance_Calc>(pvc); } } }
/// <summary> /// ˢ�±���е����� /// </summary> /// <returns>ture:�ɹ� false:ʧ��</returns> public bool RefreshData() { try { PSP_VolumeBalance_Calc pvc=new PSP_VolumeBalance_Calc(); pvc.Type=type; pvc.Flag=flag; IList<PSP_VolumeBalance_Calc> list = Services.BaseService.GetList<PSP_VolumeBalance_Calc>("SelectPSP_VolumeBalance_CalcByTypeFlag", pvc); this.gridControl.DataSource = list; SaveSum(); } catch (Exception exc) { Debug.Fail(exc.Message); HandleException.TryCatch(exc); return false; } return true; }
/// <summary> /// ɾ��������� /// </summary> public void DeleteObject() { //��ȡ������� PSP_VolumeBalance_Calc obj = FocusedObject; if (obj == null) { return; } //����ȷ�� if (MsgBox.ShowYesNo(Strings.SubmitDelete) != DialogResult.Yes) { return; } //ִ��ɾ������ try { Services.BaseService.Delete<PSP_VolumeBalance_Calc>(obj); } catch (Exception exc) { Debug.Fail(exc.Message); HandleException.TryCatch(exc); return; } this.gridView.BeginUpdate(); //��ס��ǰ���������� int iOldHandle = this.gridView.FocusedRowHandle; //��������ɾ�� ObjectList.Remove(obj); //ˢ�±�� SaveSum(); gridControl.RefreshDataSource(); //�����µĽ��������� GridHelper.FocuseRowAfterDelete(this.gridView, iOldHandle); this.gridView.EndUpdate(); if (obj.Type == "1") { IList<PSP_VolumeBalance_Calc> list = Services.BaseService.GetList<PSP_VolumeBalance_Calc>("SelectPSP_VolumeBalance_CalcByTypeTitle", obj); foreach (PSP_VolumeBalance_Calc pvm in list) { PSP_VolumeBalance_Calc pvc = new PSP_VolumeBalance_Calc(); pvc = pvm; pvc.Title = pvm.Title; Services.BaseService.Delete<PSP_VolumeBalance_Calc>(pvc); IList<PSP_VolumeBalance_Calc> list1 = Services.BaseService.GetList<PSP_VolumeBalance_Calc>("SelectPSP_VolumeBalance_CalcByTypeFlag", pvm); deleSaveSum(list1, pvc.Flag); } } }
/// <summary> /// ��Ӷ��� /// </summary> public void AddObject() { //�����������Ƿ��Ѿ����� if (ObjectList == null) { return; } //�½����� PSP_VolumeBalance_Calc obj = new PSP_VolumeBalance_Calc(); obj.Flag = flag; obj.Type = type; obj.Col1 = dy; obj.CreateTime = DateTime.Now; //ִ����Ӳ��� using (FrmPSP_VolumeBalance_CalcDialog dlg = new FrmPSP_VolumeBalance_CalcDialog()) { dlg.IsCreate = true; //�����½���־ dlg.Object = obj; dlg.Type = type; dlg.CtrTitle = ctrtitle; dlg.FormTitle = FormTitle; if (type == "1" && dy=="220") dlg.editorRow2.Visible = true; if (dlg.ShowDialog() != DialogResult.OK) { return; } } //���¶�����뵽������ ObjectList.Add(obj); SaveSum(); //ˢ�±���������ж�λ���¶����ϡ� gridControl.RefreshDataSource(); GridHelper.FocuseRow(this.gridView, obj); if (obj.Type == "1") { PSP_VolumeBalance ob = new PSP_VolumeBalance(); //ob.TypeID = dy; ob.UID = obj.Flag; //string s =""; IList<PSP_VolumeBalance> list = Services.BaseService.GetList<PSP_VolumeBalance>("SelectPSP_VolumeBalanceByKey", ob); if(list!=null) if (list.Count == 1) { ob.Flag = list[0].Flag; ob.TypeID = list[0].TypeID; //s = obj.Flag; list.Clear(); list = Services.BaseService.GetList<PSP_VolumeBalance>("SelectPSP_VolumeBalanceByTypeID", ob); foreach (PSP_VolumeBalance pvm in list) { if (pvm.UID == ob.UID) continue; PSP_VolumeBalance_Calc pvc = new PSP_VolumeBalance_Calc(); pvc = obj; pvc.Flag = pvm.UID; pvc.UID = Guid.NewGuid().ToString(); pvc.Vol = 0; pvc.Col2 = ""; Services.BaseService.Create<PSP_VolumeBalance_Calc>(pvc); } } RefreshData(); } }
private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { PSP_VolumeBalance vol = new PSP_VolumeBalance(); vol.TypeID = TypeID; vol.Flag = Flag; IList<PSP_VolumeBalance> listTypes = Services.BaseService.GetList<PSP_VolumeBalance>("SelectPSP_VolumeBalanceByTypeID", vol); FormChooseYears frm = new FormChooseYears(); foreach (PSP_VolumeBalance year in listTypes) frm.ListYearsForChoose.Add(year.Year); frm.NoIncreaseRate = true; if (frm.ShowDialog() == DialogResult.OK) { int k = 0; PSP_VolumeBalance vb = new PSP_VolumeBalance(); vb.TypeID = TypeID; vb.Flag = Flag; IList<PSP_VolumeBalance> pspvb = Services.BaseService.GetList<PSP_VolumeBalance>("SelectPSP_VolumeBalanceByTypeID", vb); string str = ""; PSP_VolumeBalance_Calc vbc = new PSP_VolumeBalance_Calc(); try { vbc.Flag = pspvb[0].UID; } catch { } vbc.Type = "1"; IList<PSP_VolumeBalance_Calc> vbclist = Services.BaseService.GetList<PSP_VolumeBalance_Calc>("SelectPSP_VolumeBalance_CalcByTypeFlag", vbc); DataTable dt = new DataTable(); //dt.Columns.Add("Sort", typeof(int)); dt.Columns.Add("序号", typeof(int)); dt.Columns.Add("项目", typeof(string)); int isort = 0; if (TypeID == "220") { foreach (GridColumn i in ctrlPSP_VolumeBalance1.GridView.Columns) { if (i.Caption != "年度" && i.Caption != "小电厂需备用容量" && i.Caption != "外网供电" && i.FieldName != "S2" && i.FieldName != "S3") { if (i.FieldName == "S4") i.Caption = "注:"; if (isort == 2) { foreach (PSP_VolumeBalance_Calc pspvbc in vbclist) { DataRow drow = dt.NewRow(); //drow["序号"] = isort + 1; drow["项目"] = pspvbc.Title; dt.Rows.Add(drow); DataRow drow1 = dt.NewRow(); drow1["项目"] = "注:"; dt.Rows.Add(drow1); } isort++; k = isort + vbclist.Count; } else if (isort == 10) { DataRow drow = dt.NewRow(); //drow["序号"] = isort + 1; drow["项目"] = "注:"; dt.Rows.Add(drow); isort++; } else if (isort == 12) { DataRow drow = dt.NewRow(); //drow["序号"] = isort + 1; drow["项目"] = "注:"; dt.Rows.Add(drow); isort++; } DataRow dr = dt.NewRow(); //dr["序号"] = isort + 1; dr["项目"] = i.Caption; //dr["Sort"] = isort + 1; dt.Rows.Add(dr); isort++; } } } if (TypeID == "35") { foreach (GridColumn i in ctrlPSP_VolumeBalance1.GridView.Columns) { if (i.Caption != "年度" && i.Caption != "小电厂需备用容量" && i.Caption != "110kV及以下小电源直接供电负荷" && i.FieldName != "S3") { if(i.FieldName== "S2"|| i.FieldName == "S4") i.Caption = "注:"; if (isort == 10) { DataRow drow = dt.NewRow(); //drow["序号"] = isort + 1; drow["项目"] = "注:"; dt.Rows.Add(drow); isort++; } else if (isort == 12) { DataRow drow = dt.NewRow(); //drow["序号"] = isort + 1; drow["项目"] = "注:"; dt.Rows.Add(drow); isort++; } DataRow dr = dt.NewRow(); //dr["序号"] = isort + 1; dr["项目"] = i.Caption; if (dr["项目"]!=null) if (dr["项目"].ToString().Contains("(负荷同时率" + Ensureloadrate() + ")")) dr["项目"]=dr["项目"].ToString().Replace("(负荷同时率" + Ensureloadrate() + ")", ""); //dr["Sort"] = isort + 1; dt.Rows.Add(dr); isort++; } } } if (TypeID == "110") { foreach (GridColumn i in ctrlPSP_VolumeBalance1.GridView.Columns) { if (i.Caption != "年度" && i.Caption != "小电厂需备用容量" ) { if (i.FieldName == "S2" || i.FieldName == "S4" || i.FieldName == "S3") i.Caption = "注:"; if (isort == 12) { DataRow drow = dt.NewRow(); //drow["序号"] = isort + 1; drow["项目"] = "注:"; dt.Rows.Add(drow); isort++; } else if (isort == 14) { DataRow drow = dt.NewRow(); //drow["序号"] = isort + 1; drow["项目"] = "注:"; dt.Rows.Add(drow); isort++; } DataRow dr = dt.NewRow(); //dr["序号"] = isort + 1; dr["项目"] = i.Caption; //dr["Sort"] = isort + 1; dt.Rows.Add(dr); isort++; } } } isort = 1; foreach (System.Data.DataRow row in dt.Rows) { row["序号"] = isort; isort++; } foreach (ChoosedYears i in frm.ListChoosedYears) { dt.Columns.Add(i.Year + "年", typeof(string)); } //if (TypeID == "220") //{ // dt.Rows.RemoveAt(vbclist.Count + 14); //} foreach (ChoosedYears i in frm.ListChoosedYears) { foreach (PSP_VolumeBalance balan in pspvb) { if (balan.Year == i.Year) { int j = 0; dt.Rows[0][i.Year + "年"] = balan.L1; dt.Rows[1][i.Year + "年"] = balan.L2; PSP_VolumeBalance_Calc vbcalc = new PSP_VolumeBalance_Calc(); vbcalc.Flag = balan.UID; vbcalc.Type = "1"; IList<PSP_VolumeBalance_Calc> vbclist1 = Services.BaseService.GetList<PSP_VolumeBalance_Calc>("SelectPSP_VolumeBalance_CalcByTypeFlag", vbcalc); if (TypeID == "220") { foreach (PSP_VolumeBalance_Calc pspvbc in vbclist1) { dt.Rows[j+2][i.Year + "年"] = pspvbc.Vol.ToString(); j++; dt.Rows[j + 2][i.Year + "年"] = pspvbc.Col2.ToString(); j++; } dt.Rows[j + 2][i.Year + "年"] = balan.L5; dt.Rows[j + 3][i.Year + "年"] = balan.S4; dt.Rows[j + 4][i.Year + "年"] = balan.L6; dt.Rows[j + 5][i.Year + "年"] = balan.L7; dt.Rows[j + 6][i.Year + "年"] = balan.L8; dt.Rows[j + 7][i.Year + "年"] = balan.L9; dt.Rows[j + 8][i.Year + "年"] = balan.L10; str = ""; vbcalc.Type = "2"; IList<PSP_VolumeBalance_Calc> vbclist2 = Services.BaseService.GetList<PSP_VolumeBalance_Calc>("SelectPSP_VolumeBalance_CalcByTypeFlag", vbcalc); foreach (PSP_VolumeBalance_Calc pspvbc in vbclist2) { if (pspvbc.LX1 == "新建") str += pspvbc.LX1 + "" + pspvbc.Title + "" + pspvbc.LX2; else str += pspvbc.Title + "" + pspvbc.LX1 + "" + pspvbc.LX2; if (pspvbc.UID != vbclist2[vbclist2.Count - 1].UID) str += ","; } dt.Rows[j + 9][i.Year + "年"] = str; dt.Rows[j + 10][i.Year + "年"] = balan.L11; str = ""; vbcalc.Type = "3"; IList<PSP_VolumeBalance_Calc> vbclist3 = Services.BaseService.GetList<PSP_VolumeBalance_Calc>("SelectPSP_VolumeBalance_CalcByTypeFlag", vbcalc); foreach (PSP_VolumeBalance_Calc pspvbc in vbclist3) { if (pspvbc.LX1 == "新建") str += pspvbc.LX1 + "" + pspvbc.Title + "" + pspvbc.LX2; else str += pspvbc.Title + "" + pspvbc.LX1 + "" + pspvbc.LX2; if (pspvbc.UID != vbclist3[vbclist3.Count - 1].UID) str += ","; } dt.Rows[j + 11][i.Year + "年"] = str; dt.Rows[j + 12][i.Year + "年"] = balan.L12; dt.Rows[j + 13][i.Year + "年"] = balan.L13; dt.Rows[j + 14][i.Year + "年"] = balan.L14; } else if (TypeID == "110") { //foreach (PSP_VolumeBalance_Calc pspvbc in vbclist1) //{ // str = "(" + pspvbc.Title + "," + pspvbc.LX1 + "," + pspvbc.LX2 + ") " + str; //} dt.Rows[2][i.Year + "年"] = balan.S2; dt.Rows[j + 3][i.Year + "年"] = balan.L4; dt.Rows[j + 4][i.Year + "年"] = balan.S3; dt.Rows[j + 5][i.Year + "年"] = balan.L5; dt.Rows[j + 6][i.Year + "年"] = balan.S4; dt.Rows[j + 7][i.Year + "年"] = balan.L6; dt.Rows[j + 8][i.Year + "年"] = balan.L7; dt.Rows[j + 9][i.Year + "年"] = balan.L8; dt.Rows[j + 10][i.Year + "年"] = balan.L9; dt.Rows[j + 11][i.Year + "年"] = balan.L10; str = ""; vbcalc.Type = "2"; IList<PSP_VolumeBalance_Calc> vbclist2 = Services.BaseService.GetList<PSP_VolumeBalance_Calc>("SelectPSP_VolumeBalance_CalcByTypeFlag", vbcalc); foreach (PSP_VolumeBalance_Calc pspvbc in vbclist2) { if (pspvbc.LX1 == "新建") str += pspvbc.LX1 + "" + pspvbc.Title + "" + pspvbc.LX2; else str += pspvbc.Title + "" + pspvbc.LX1 + "" + pspvbc.LX2; if (pspvbc.UID != vbclist2[vbclist2.Count - 1].UID) str += ","; } dt.Rows[j + 12][i.Year + "年"] = str; dt.Rows[j + 13][i.Year + "年"] = balan.L11; str = ""; vbcalc.Type = "3"; IList<PSP_VolumeBalance_Calc> vbclist3 = Services.BaseService.GetList<PSP_VolumeBalance_Calc>("SelectPSP_VolumeBalance_CalcByTypeFlag", vbcalc); foreach (PSP_VolumeBalance_Calc pspvbc in vbclist3) { if (pspvbc.LX1 == "新建") str += pspvbc.LX1 + "" + pspvbc.Title + "" + pspvbc.LX2; else str += pspvbc.Title + "" + pspvbc.LX1 + "" + pspvbc.LX2; if (pspvbc.UID != vbclist3[vbclist3.Count - 1].UID) str += ","; } dt.Rows[j + 14][i.Year + "年"] = str; dt.Rows[j + 15][i.Year + "年"] = balan.L12; dt.Rows[j + 16][i.Year + "年"] = balan.L13; dt.Rows[j + 17][i.Year + "年"] = balan.L14; } else if (TypeID == "35") { dt.Rows[j+2][i.Year + "年"] = balan.S2; dt.Rows[j + 3][i.Year + "年"] = balan.L5; dt.Rows[j + 4][i.Year + "年"] = balan.S4; dt.Rows[j + 5][i.Year + "年"] = balan.L6; dt.Rows[j + 6][i.Year + "年"] = balan.L7; dt.Rows[j + 7][i.Year + "年"] = balan.L8; dt.Rows[j + 8][i.Year + "年"] = balan.L9; dt.Rows[j + 9][i.Year + "年"] = balan.L10; //dt.Rows[j + 8][i.Year + "年"] = balan.L10; str = ""; vbcalc.Type = "2"; IList<PSP_VolumeBalance_Calc> vbclist2 = Services.BaseService.GetList<PSP_VolumeBalance_Calc>("SelectPSP_VolumeBalance_CalcByTypeFlag", vbcalc); foreach (PSP_VolumeBalance_Calc pspvbc in vbclist2) { if (pspvbc.LX1 == "新建") str += pspvbc.LX1 + "" + pspvbc.Title + "" + pspvbc.LX2; else str += pspvbc.Title + "" + pspvbc.LX1 + "" + pspvbc.LX2; if (pspvbc.UID != vbclist2[vbclist2.Count - 1].UID) str += ","; } dt.Rows[j + 10][i.Year + "年"] = str; dt.Rows[j + 11][i.Year + "年"] = balan.L11; str = ""; vbcalc.Type = "3"; IList<PSP_VolumeBalance_Calc> vbclist3 = Services.BaseService.GetList<PSP_VolumeBalance_Calc>("SelectPSP_VolumeBalance_CalcByTypeFlag", vbcalc); foreach (PSP_VolumeBalance_Calc pspvbc in vbclist3) { if (pspvbc.LX1 == "新建") str += pspvbc.LX1 + "" + pspvbc.Title + "" + pspvbc.LX2; else str += pspvbc.Title + "" + pspvbc.LX1 + "" + pspvbc.LX2; if (pspvbc.UID != vbclist3[vbclist3.Count - 1].UID) str += ","; } dt.Rows[j + 12][i.Year + "年"] = str; dt.Rows[j + 13][i.Year + "年"] = balan.L12; dt.Rows[j + 14][i.Year + "年"] = balan.L13; } } } } FormPSP_VolumeBalance_Print fr = new FormPSP_VolumeBalance_Print(); fr.GridDataTable = dt; //if (TypeID == "220") //{ fr.Text = this.Text; fr.gridView1.GroupPanelText = this.Text; fr.PRintRight = PrintRight; //} fr.ShowDialog(); } }
private void AddFuHe(PSP_VolumeBalance obj) { PSP_VolumeBalance pvc = new PSP_VolumeBalance(); pvc.TypeID = type; pvc.Flag = flag; pvc.Year = EnsureBaseYear(); IList<PSP_VolumeBalance> list = Services.BaseService.GetList<PSP_VolumeBalance>("SelectPSP_VolumeBalanceByTypeIDAndYear", pvc); if (list != null) if (list.Count == 1) { PSP_VolumeBalance_Calc pvc2 = new PSP_VolumeBalance_Calc(); pvc2.Type ="1"; pvc2.Flag = list[0].UID; IList<PSP_VolumeBalance_Calc> list2 = Services.BaseService.GetList<PSP_VolumeBalance_Calc>("SelectPSP_VolumeBalance_CalcByTypeFlag", pvc2); PSP_VolumeBalance_Calc pvc3 = new PSP_VolumeBalance_Calc(); pvc3.Type = "1"; pvc3.Flag = obj.UID; IList<PSP_VolumeBalance_Calc> list3 = Services.BaseService.GetList<PSP_VolumeBalance_Calc>("SelectPSP_VolumeBalance_CalcByTypeFlag", pvc3); if (list2 != null) if (list2.Count > 0) { foreach (PSP_VolumeBalance_Calc pvctemp in list2) { if (list3 != null) if (list3.Count == list2.Count) break; PSP_VolumeBalance_Calc _obj = new PSP_VolumeBalance_Calc(); _obj = pvctemp; _obj.Flag = obj.UID; _obj.Vol = 0; _obj.UID = Guid.NewGuid().ToString(); Services.BaseService.Create<PSP_VolumeBalance_Calc>(_obj); } } } }