private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { DataRow obj = this.gridView1.GetDataRow(this.gridView1.FocusedRowHandle); if (obj == null) return; PSP_P_Values ppv = new PSP_P_Values(); ppv.Flag2 = Convert.ToInt32(obj["ID"]); ppv.TypeID =80003; li = Services.BaseService.GetList<PSP_P_Values>("SelectPSP_P_ValuesByTypeIDFlag2", ppv); this.DialogResult = DialogResult.OK; }
private void GetFFData(int sid,string type,string title) { FormXiaoshi_Fs ffs = new FormXiaoshi_Fs(); ffs.Type = type; ffs.ForecastReports = forecastReport; if (ffs.ShowDialog() != DialogResult.OK) return; Hashtable hs = ffs.HS; if (hs.Count != 3) return; int uid = (int)hs["H1"]; TreeListNode tn = (TreeListNode)hs["H2"]; bool bool1 = (bool)hs["H3"]; PSP_P_Types pt=new PSP_P_Types(); if (bool1) { PSP_Types pt1 = Services.BaseService.GetOneByKey<PSP_Types>(uid); InitTypes(pt1, pt); } else { pt = Services.BaseService.GetOneByKey<PSP_P_Types>(uid); } #region �趨types string str2 = " ID=" + sid + " and Flag='" + typeFlag + "' and Flag2='" + forecastReport.ID + "' "; IList listTypes = Common.Services.BaseService.GetList("SelectPSP_P_TypesByWhere", str2); if (listTypes.Count != 0) { PSP_P_Values ppvvv = new PSP_P_Values(); ppvvv.TypeID = sid; ppvvv.Flag2 = forecastReport.ID; Services.BaseService.Update("DeletePSP_P_ValuesByType", ppvvv); } pt.ID = sid; pt.Flag2 = forecastReport.ID; pt.Flag = typeFlag; pt.Title = title; Services.BaseService.Create<PSP_P_Types>(pt); #endregion #region �趨year value Hashtable hta = new Hashtable(); ArrayList al = new ArrayList(); foreach (TreeListColumn tlc in tn.TreeList.Columns) { if (tlc.FieldName.IndexOf("��") >= 0) { int year = 0; try { year=int.Parse(tlc.FieldName.Replace("��", "")); } catch { } if (year != 0 && year > forecastReport.EndYear) continue; hta.Add(Guid.NewGuid().ToString(), year); try { PSP_P_Values pv = new PSP_P_Values(); pv.Year=year; pv.TypeID=sid; try { pv.Value = double.Parse(tn[tlc.FieldName].ToString()); } catch { } pv.Flag2 = forecastReport.ID; Services.BaseService.Create<PSP_P_Values>(pv); } catch { } try { PSP_P_Years ppy = new PSP_P_Years(); ppy.Flag = forecastReport.ID; ppy.Flag2 = typeFlag; ppy.Year = year; Services.BaseService.Create<PSP_P_Years>(ppy); } catch (Exception ex) { //MessageBox.Show(ex.Message); } } } for (int m = forecastReport.StartYear; m <= forecastReport.EndYear; m++) { if (!hta.ContainsValue(m)) { try { PSP_P_Years ppy = new PSP_P_Years(); ppy.Flag = forecastReport.ID; ppy.Flag2 = typeFlag; ppy.Year = m; Services.BaseService.Create<PSP_P_Years>(ppy); } catch (Exception ex) { //MessageBox.Show(ex.Message); } } } #endregion Application.DoEvents(); this.Cursor = Cursors.WaitCursor; treeList1.BeginUpdate(); LoadData(); treeList1.EndUpdate(); this.Cursor = Cursors.Default; Compute(); RefreshChart(); }
private void barButtonItem13_ItemClick_1(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { //ɾ�� if (treeList1.FocusedColumn == null) { return; } //��������� if (treeList1.FocusedColumn.FieldName.IndexOf("��") == -1) { return; } ////if (!base.DeleteRight) ////{ //// MsgBox.Show("��û��Ȩ���д��������"); //// return; ////} if (MsgBox.ShowYesNo("�Ƿ�ɾ�� " + treeList1.FocusedColumn.FieldName + " ��������������ݣ�") != DialogResult.Yes) { return; } PSP_P_Values psp_Values = new PSP_P_Values(); psp_Values.ID = forecastReport.ID;//����ID���Դ��Flag2 psp_Values.Year = (int)treeList1.FocusedColumn.Tag; try { //DeletePSP_ValuesByYearɾ�����ݺ���� int colIndex = treeList1.FocusedColumn.AbsoluteIndex; Common.Services.BaseService.Update("DeletePSP_P_ValuesByYear", psp_Values); dataTable.Columns.Remove(treeList1.FocusedColumn.FieldName); treeList1.Columns.Remove(treeList1.FocusedColumn); if (colIndex >= treeList1.Columns.Count) { colIndex--; } treeList1.FocusedColumn = treeList1.Columns[colIndex]; RefreshChart(); } catch (Exception ex) { MsgBox.Show("ɾ�������" + ex.Message); } }
//�ѽڵ����ݴ�ŵ������У������List private void AddNodeDataToList(TreeListNode node, IList<PSP_P_Values> list) { foreach (TreeListColumn col in treeList1.Columns) { if (col.FieldName.IndexOf("��") > 0) { object obj = node.GetValue(col.FieldName); if (obj != DBNull.Value) { PSP_P_Values v = new PSP_P_Values(); v.Flag2 = forecastReport.ID; v.TypeID = (int)node.GetValue("ID"); v.Caption = node.GetValue("Title").ToString() + "," + v.TypeID; v.Year = Convert.ToInt32(col.FieldName.Replace("��", "")); v.Value = (double)node.GetValue(col.FieldName); list.Add(v); } } } }
private void InitValues(PSP_Values pv, PSP_P_Values pv1) { pv1.ID = pv.ID; pv1.TypeID = pv.TypeID; pv1.Flag2 = typeFlag2; pv1.Value = pv.Value; pv1.Year = pv.Year; }
private void Compute() { int year=0; double d1=0; double d2=0; double d3=0; double d4=0; foreach (DataColumn dc in dataTable.Columns) { if (dc.ColumnName.IndexOf("��") >= 0) { try { year = int.Parse(dc.ColumnName.Replace("��", "")); if (year <= forecastReport.StartYear) { //try //{d1 = (double)dataTable.Rows[0][dc.ColumnName];} //catch { } if (dataTable.Rows[0][dc.ColumnName] != DBNull.Value && dataTable.Rows[0][dc.ColumnName] != null) if (dataTable.Rows[0][dc.ColumnName].ToString() == "") d1 = 0; else d1 = Convert.ToInt32(dataTable.Rows[0][dc.ColumnName]); //try //{d3 = (double)dataTable.Rows[2][dc.ColumnName];} //catch { } if (dataTable.Rows[2][dc.ColumnName] != DBNull.Value && dataTable.Rows[2][dc.ColumnName] != null) if (dataTable.Rows[2][dc.ColumnName].ToString() == "") d3 = 0; else d3 = Convert.ToInt32(dataTable.Rows[2][dc.ColumnName]); if (d3 != 0) { PSP_P_Values value = new PSP_P_Values(); value.Year = year; value.TypeID = 80005; value.Flag2 = forecastReport.ID; value.Value = Math.Round(d1 / d3); Services.BaseService.Update<PSP_P_Values>(value); if(dataTable.Rows.Count>3) dataTable.Rows[3][dc.ColumnName] = Math.Round(d1 / d3); } //try //{ // if (d3 != 0) // { // PSP_P_Values value = new PSP_P_Values(); // value.Year = year; // value.TypeID = 80005; // value.Flag2 = forecastReport.ID; // value.Value = Math.Round(d1 / d3); // Services.BaseService.Update<PSP_P_Values>(value); // dataTable.Rows[3][dc.ColumnName] = Math.Round(d1 / d3); // } //} //catch { } } else { //try //{d1 = (double)dataTable.Rows[0][dc.ColumnName];} //catch { } if (dataTable.Rows[0][dc.ColumnName] != DBNull.Value && dataTable.Rows[0][dc.ColumnName] != null) if (dataTable.Rows[0][dc.ColumnName].ToString() == "") d1 = 0; else d1 = Convert.ToInt32(dataTable.Rows[0][dc.ColumnName]); if (dataTable.Rows.Count > 3) { if (dataTable.Rows[3][dc.ColumnName] != DBNull.Value && dataTable.Rows[3][dc.ColumnName] != null) if (dataTable.Rows[3][dc.ColumnName].ToString() == "") d3 = 0; else d3 = Convert.ToInt32(dataTable.Rows[3][dc.ColumnName]); } else d3 = 0; //try //{d3 = (double)dataTable.Rows[3][dc.ColumnName];} //catch { d3 = 0; } //try //{ // if (d3 != 0) // dataTable.Rows[2][dc.ColumnName] = Math.Round( d1 / d3); //} //catch { } if (d3 != 0) { dataTable.Rows[2][dc.ColumnName] = Math.Round(d1 / d3); } } } catch { } } } }
//��ȡ���� private void LoadValues() { PSP_P_Values PSP_P_Values = new PSP_P_Values(); PSP_P_Values.ID = typeFlag2;//��ID�ֶδ��Flag2��ֵ IList<PSP_P_Values> listValues = Common.Services.BaseService.GetList<PSP_P_Values>("SelectPSP_P_ValuesListByFlag2", PSP_P_Values); foreach (PSP_P_Values value in listValues) { TreeListNode node = treeList1.FindNodeByFieldValue("ID", value.TypeID); if (node != null) { node.SetValue(value.Year + "��", value.Value); } } }