/// <summary> /// ��Ӷ��� /// </summary> public void AddObject() { //�����������Ƿ��Ѿ����� if (ObjectList == null) { return; } //�½����� BurdenMonth obj = new BurdenMonth(); obj.UID = Guid.NewGuid().ToString() + "|" + Itop.Client.MIS.ProgUID; //ִ����Ӳ��� using (FrmBurdenMonthDialog dlg = new FrmBurdenMonthDialog()) { dlg.TitleName = this.gridView.GroupPanelText; dlg.IsCreate = true; //�����½���־ dlg.Object = obj; if (dlg.ShowDialog() != DialogResult.OK) { return; } } //���¶�����뵽������ ObjectList.Add(obj); //ˢ�±���������ж�λ���¶����ϡ� gridControl.RefreshDataSource(); GridHelper.FocuseRow(this.gridView, obj); }
private void barButtonItem4_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { try { DataTable dts = new DataTable(); OpenFileDialog op = new OpenFileDialog(); op.Filter = "Excel�ļ�(*.xls)|*.xls"; if (op.ShowDialog() == DialogResult.OK) { dts = GetExcel(op.FileName); for (int k = 0; k < dts.Rows.Count; k++) { string year = dts.Rows[k][1].ToString(); //string da = dts.Rows[1][1].ToString(); //string jj = da.Substring(0, 2); //string day = year + da.Substring(2, da.Length - 2).Replace("(", "").Replace(")", "").Replace("��", "").Replace("��", ""); BurdenMonth bl = new BurdenMonth(); bl.UID = bl.UID + "|" + Itop.Client.MIS.ProgUID; bl.CreateDate = DateTime.Now; bl.UpdateDate= DateTime.Now; bl.BurdenYear = int.Parse(year); //try //{ // bl. = DateTime.Parse(year); //} //catch //{ // bl.BurdenDate = DateTime.Now; //} string pjt = " ProjectID='" + MIS.ProgUID + "'and Title='" + dts.Rows[k][0].ToString() + "'"; PS_Table_AreaWH lt = (PS_Table_AreaWH)Common.Services.BaseService.GetObject("SelectPS_Table_AreaWHByConn", pjt); if (lt != null) { bl.AreaID = lt.ID; } bl.Title="BurdenYear ='" +bl.BurdenYear+"' and uid like '%" + Itop.Client.MIS.ProgUID + "%' and AreaID='"+bl.AreaID+"'"; IList<BurdenMonth> lis = Common.Services.BaseService.GetList<BurdenMonth>("SelectBurdenMonthByWhere", bl.Title); foreach (BurdenMonth bltemp in lis) { bl.UID = bltemp.UID; bl.CreateDate = bltemp.CreateDate; bl.UpdateDate = bltemp.UpdateDate; break; } try{ bl.Month1 = double.Parse(dts.Rows[k][2].ToString()); } catch { } try{ bl.Month2 = double.Parse(dts.Rows[k][3].ToString()); } catch { } try{ bl.Month3 = double.Parse(dts.Rows[k][4].ToString()); } catch { } try{ bl.Month4 = double.Parse(dts.Rows[k][5].ToString()); } catch { } try{ bl.Month5 = double.Parse(dts.Rows[k][6].ToString()); } catch { } try{ bl.Month6 = double.Parse(dts.Rows[k][7].ToString()); } catch { } try{ bl.Month7 = double.Parse(dts.Rows[k][8].ToString()); } catch { } try{ bl.Month8 = double.Parse(dts.Rows[k][9].ToString()); } catch { } try{ bl.Month9 = double.Parse(dts.Rows[k][10].ToString()); } catch { } try{ bl.Month10 = double.Parse(dts.Rows[k][11].ToString()); } catch { } try{ bl.Month11 = double.Parse(dts.Rows[k][12].ToString()); } catch { } try{ bl.Month12 = double.Parse(dts.Rows[k][13].ToString()); } catch { } double minData = 0; double maxData = 0; double sumData = 0; Common.Services.BaseService.Delete<BurdenMonth>(bl); Common.Services.BaseService.Create<BurdenMonth>(bl); ctrlBurdenMonth1.ObjectList.Add(bl); } ctrlBurdenMonth1.RefreshData(); UpdataChart(); MsgBox.Show("�ѵ���ɹ���"); } } catch { MsgBox.Show("�����ʽ����ȷ��"); } }
/// <summary> /// �Ľ������ /// </summary> public void UpdateObject() { //��ȡ������� BurdenMonth obj = FocusedObject; if (obj == null) { return; } //���������һ������ BurdenMonth objCopy = new BurdenMonth(); DataConverter.CopyTo<BurdenMonth>(obj, objCopy); //ִ���IJ��� using (FrmBurdenMonthDialog dlg = new FrmBurdenMonthDialog()) { dlg.TitleName = this.gridView.GroupPanelText; dlg.Object = objCopy; //���� if (dlg.ShowDialog() != DialogResult.OK) { return; } } //�ø������½������ DataConverter.CopyTo<BurdenMonth>(objCopy, obj); //ˢ�±�� gridControl.RefreshDataSource(); }
//��ȡ���� private void LoadValues() { PSP_ForecastValues psp_Value = new PSP_ForecastValues(); psp_Value.ForecastID = forecastReport.ID; IList<PSP_ForecastValues> listValues = Common.Services.BaseService.GetList<PSP_ForecastValues>("SelectPSP_ForecastValuesByForecastID", psp_Value); if (listValues.Count == 0) { BurdenMonth bm1 = new BurdenMonth(); bm1.BurdenYear = forecastReport.StartYear; BurdenMonth bm = (BurdenMonth)Common.Services.BaseService.GetObject("SelectBurdenMonthByBurdenYear", bm1); if (bm != null) { //TreeListNode node = treeList1.FindNodeByFieldValue("TypeID", value.TypeID); //if (node != null) //{ // node.SetValue(value.Year + "��", value.Value); //} treeList1.MoveFirst(); TreeListNode node = treeList1.FocusedNode; node.SetValue("1��", bm.Month1); node.SetValue("2��", bm.Month2); node.SetValue("3��", bm.Month3); node.SetValue("4��", bm.Month4); node.SetValue("5��", bm.Month5); node.SetValue("6��", bm.Month6); node.SetValue("7��", bm.Month7); node.SetValue("8��", bm.Month8); node.SetValue("9��", bm.Month9); node.SetValue("10��", bm.Month10); node.SetValue("11��", bm.Month11); node.SetValue("12��", bm.Month12); double bmsum=bm.Month1+bm.Month2+bm.Month3+bm.Month4+bm.Month5+bm.Month6; bmsum+=bm.Month7+bm.Month8+bm.Month9+bm.Month10+bm.Month11+bm.Month12; double bmmax = Math.Max(bm.Month1, bm.Month2); bmmax = Math.Max(bmmax, bm.Month3); bmmax = Math.Max(bmmax, bm.Month4); bmmax = Math.Max(bmmax, bm.Month5); bmmax = Math.Max(bmmax, bm.Month6); bmmax = Math.Max(bmmax, bm.Month7); bmmax = Math.Max(bmmax, bm.Month8); bmmax = Math.Max(bmmax, bm.Month9); bmmax = Math.Max(bmmax, bm.Month10); bmmax = Math.Max(bmmax, bm.Month11); bmmax = Math.Max(bmmax, bm.Month12); node.SetValue("13��", bmsum); node.SetValue("14��", bmmax); node.SetValue("15��", bmsum / (bmmax*12)); } } else { foreach (PSP_ForecastValues value in listValues) { TreeListNode node = treeList1.FindNodeByFieldValue("TypeID", value.TypeID); if (node != null) { node.SetValue(value.Year + "��", value.Value); } } } }