public void LoadData2() { PSP_SubstationUserNum n1 = new PSP_SubstationUserNum(); list1 = Services.BaseService.GetList <PSP_SubstationUserNum>("SelectPSP_SubstationNum2", n1); for (int i = 0; i < list1.Count; i++) { PSP_SubstationUserNum obj = list1[i]; PSP_SubstationUserNum temp = new PSP_SubstationUserNum(); temp.SubStationID = list1[i].SubStationID; IList <PSP_SubstationUserNum> l2 = Services.BaseService.GetList <PSP_SubstationUserNum>("SelectPSP_SubstationNum1", temp); for (int j = 0; j < l2.Count; j++) { if (l2[j].col1 == "是" && l2[j].col2 == "否") { obj.col1 = "一票否决"; list2.Add(obj); list1.RemoveAt(i); break; } } } for (int i = 0; i < list1.Count; i++) { list1[i].col1 = list1[i].num.ToString(); } //list1[i].col1 = list1[i].num.ToString(); for (int i = 0; i < list2.Count; i++) { list1.Add((PSP_SubstationUserNum)list2[i]); } gridControl.DataSource = list1; gridControl.RefreshDataSource(); }
protected override void Edit() { //if(f==null){ // MessageBox.Show("请先计算权值。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); // return; //} decimal a = 0; for (int i = 0; i < list.Count; i++) { PSP_SubstationUserNum p = list[i]; decimal t = 0; if (p.col1 != "") { a = a + Convert.ToDecimal(p.col1); } // a = p.col1; //Services.BaseService.Update<PSP_SubstationUserNum>(list[i]); } if (a != 1) { MessageBox.Show("权重之和不等于1。当前权重之和为" + a.ToString()); return; } if (Create1) { for (int i = 0; i < list.Count; i++) { PSP_SubstationUserNum p = list[i]; p.UID = Guid.NewGuid().ToString(); p.userID = Itop.Client.MIS.UserNumber; p.SubStationID = treeView1.SelectedNode.Tag.ToString(); p.SubParID = p.col4; Services.BaseService.Create <PSP_SubstationUserNum>(p); } } else { for (int i = 0; i < list.Count; i++) { PSP_SubstationUserNum p = list[i]; p.SubStationID = p.col4; Services.BaseService.Update <PSP_SubstationUserNum>(list[i]); } } for (int i = 0; i < list.Count; i++) { PSP_SubstationUserNum _u = list[i]; PSP_SubstationPar _p = Services.BaseService.GetOneByKey <PSP_SubstationPar>(_u.SubParID); _p.col1 = _u.col1; Services.BaseService.Update <PSP_SubstationPar>(_p); } MessageBox.Show("更新完成。"); }
public void LoadData(string id) { PSP_SubstationUserNum num1 = new PSP_SubstationUserNum(); num1.userID = Itop.Client.MIS.UserNumber; num1.SubStationID = id; num1.num = 1; list = Services.BaseService.GetList <PSP_SubstationUserNum>("SelectPSP_SubstationUserNumByUser", num1); if (list.Count == 0) { Create1 = true; PSP_SubstationPar par1 = new PSP_SubstationPar(); par1.type = 1; IList <PSP_SubstationPar> _list = Services.BaseService.GetList <PSP_SubstationPar>("SelectPSP_SubstationParByType", par1); for (int i = 0; i < _list.Count; i++) { PSP_SubstationUserNum n1 = new PSP_SubstationUserNum(); n1.Remark = _list[i].InfoName; n1.col1 = "是"; n1.col2 = "是"; n1.col4 = _list[i].UID; list.Add(n1); } } else { Create1 = false; } gridControl.DataSource = list; num1.num = 2; list2 = Services.BaseService.GetList <PSP_SubstationUserNum>("SelectPSP_SubstationUserNumByUser", num1); if (list2.Count == 0) { Create2 = true; PSP_SubstationPar par1 = new PSP_SubstationPar(); par1.type = 2; IList <PSP_SubstationPar> _list = Services.BaseService.GetList <PSP_SubstationPar>("SelectPSP_SubstationParByType", par1); for (int i = 0; i < _list.Count; i++) { PSP_SubstationUserNum n2 = new PSP_SubstationUserNum(); n2.Remark = _list[i].InfoName; n2.num = 0; n2.col1 = _list[i].col1; n2.col4 = _list[i].UID; list2.Add(n2); } } else { Create2 = false; } gridControl1.DataSource = list2; }
public void LoadData(string uid) { LineList1 line = new LineList1(); line.col1 = uid; IList <LineList1> linelist = Services.BaseService.GetList <LineList1>("SelectLineList1ByRefLineEleID", line); ArrayList val = new ArrayList(); for (int i = 0; i < linelist.Count; i++) { PSP_SubstationUserNum num1 = new PSP_SubstationUserNum(); num1.userID = Itop.Client.MIS.UserNumber; num1.SubStationID = linelist[i].UID; num1.num = 3; IList <PSP_SubstationUserNum> sublist = Services.BaseService.GetList <PSP_SubstationUserNum>("SelectPSP_SubstationUserNumByUser", num1); if (sublist.Count == 0) { MessageBox.Show("线路" + linelist[i].LineName + "还没有评分完成,不能自动计算权值。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } } LineList1 n1 = new LineList1(); n1.col1 = uid; list1 = Services.BaseService.GetList <LineList1>("SelectLineList1ByEleIDToTal", n1); //for (int i = 0; i < list1.Count; i++) //{ // LineInfo line = new LineInfo(); // line.EleID = list1[i].LineEleID; // line.SvgUID = "c5ec3bc7-9706-4cbd-9b8b-632d3606f933"; // line = (LineInfo)Services.BaseService.GetObject("SelectLineInfoByEleID", line); // if (line != null) // { // list1[i].col1 = line.ObligateField6; // list1[i].col2 = line.ObligateField7; // } //} gridControl.DataSource = list1; gridControl.RefreshDataSource(); }
protected override void Add() { //if(treeView1.SelectedNode==null || treeView1.SelectedNode.Parent!=null){ // MessageBox.Show("请选择线路规划方案(第一级树目录)。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); // return; //} string uid = PID; //treeView1.SelectedNode.Tag.ToString(); LineList1 line = new LineList1(); line.col1 = uid; IList <LineList1> linelist = Services.BaseService.GetList <LineList1>("SelectLineList1ByRefLineEleID", line); ArrayList val = new ArrayList(); for (int i = 0; i < linelist.Count; i++) { PSP_SubstationUserNum num1 = new PSP_SubstationUserNum(); num1.userID = Itop.Client.MIS.UserNumber; num1.SubStationID = linelist[i].UID; num1.num = 3; IList <PSP_SubstationUserNum> sublist = Services.BaseService.GetList <PSP_SubstationUserNum>("SelectPSP_SubstationUserNumByUser", num1); if (sublist.Count == 0) { MessageBox.Show("线路" + linelist[i].LineName + "还没有评分完成,不能自动计算权值。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } f = new float[sublist.Count]; float sum = 0f; float[] subnum = new float[sublist.Count]; for (int j = 0; j < sublist.Count; j++) { sum = sum + getNumber(sublist[j].col2); } for (int j = 0; j < sublist.Count; j++) { if (getNumber(sublist[j].col2) == 0) { //subnum[j] = 1 / sum; subnum[j] = 0; } else { subnum[j] = getNumber(sublist[j].col2) / sum; } } val.Add(subnum); } for (int i = 0; i < val.Count; i++) { float[] t = val[i] as float[]; for (int j = 0; j < f.Length; j++) { f[j] = f[j] + t[j]; } } for (int i = 0; i < f.Length; i++) { f[i] = Convert.ToSingle(Math.Round((f[i] / val.Count), 3)); } for (int i = 0; i < linelist.Count; i++) { PSP_SubstationUserNum num1 = new PSP_SubstationUserNum(); num1.userID = Itop.Client.MIS.UserNumber; num1.SubStationID = linelist[i].UID; num1.num = 3; IList <PSP_SubstationUserNum> sublist = Services.BaseService.GetList <PSP_SubstationUserNum>("SelectPSP_SubstationUserNumByUser", num1); for (int j = 0; j < sublist.Count; j++) { PSP_SubstationUserNum t = sublist[j]; t = Services.BaseService.GetOneByKey <PSP_SubstationUserNum>(t); t.col1 = Convert.ToString(f[j]); Services.BaseService.Update <PSP_SubstationUserNum>(t); } } f = null; MessageBox.Show("更新完成。"); LoadData(sss); }
protected override void Edit() { decimal a = 0; for (int i = 0; i < list2.Count; i++) { PSP_SubstationUserNum p = list2[i]; decimal t = 0; if (p.col1 != "") { a = a + Convert.ToDecimal(p.col1); } // a = p.col1; //Services.BaseService.Update<PSP_SubstationUserNum>(list[i]); } if (a != 1) { MessageBox.Show("权重之和不等于1。当前权重之和为" + a.ToString()); return; } if (Create1) { for (int i = 0; i < list.Count; i++) { PSP_SubstationUserNum p = list[i]; p.UID = Guid.NewGuid().ToString(); p.userID = Itop.Client.MIS.UserNumber; p.SubStationID = treeView1.SelectedNode.Tag.ToString(); p.SubParID = p.col4; Services.BaseService.Create <PSP_SubstationUserNum>(p); } Create1 = false; } else { for (int i = 0; i < list.Count; i++) { PSP_SubstationUserNum p = list[i]; //p.SubStationID = p.col4; Services.BaseService.Update <PSP_SubstationUserNum>(list[i]); } } ///////////////////////////////////////////////////// if (Create2) { for (int i = 0; i < list2.Count; i++) { PSP_SubstationUserNum p = list2[i]; p.UID = Guid.NewGuid().ToString(); p.userID = Itop.Client.MIS.UserNumber; p.SubStationID = treeView1.SelectedNode.Tag.ToString(); p.SubParID = p.col4; Services.BaseService.Create <PSP_SubstationUserNum>(p); } Create2 = false; } else { for (int i = 0; i < list2.Count; i++) { PSP_SubstationUserNum p = list2[i]; //p.SubStationID = p.col4; Services.BaseService.Update <PSP_SubstationUserNum>(list2[i]); } } for (int i = 0; i < list2.Count; i++) { PSP_SubstationUserNum _u = list2[i]; PSP_SubstationPar _p = Services.BaseService.GetOneByKey <PSP_SubstationPar>(_u.SubParID); _p.col1 = _u.col1; Services.BaseService.Update <PSP_SubstationPar>(_p); } //PSP_SubstationPar par1 = new PSP_SubstationPar(); //par1.type = 2; //IList<PSP_SubstationPar> _list = Services.BaseService.GetList<PSP_SubstationPar>("SelectPSP_SubstationParByType", par1); MessageBox.Show("保存成功。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); }