public JsonResult GetPlanForF() { var dal = new PlanDAL(); var list = dal.GetPlanList(1, 20, "", "", "", "").Data.ToList(); //list.ForEach(m => //{ // m.Description = FormatStr(m.Description, "p"); //}); return(Json(list, JsonRequestBehavior.AllowGet)); }
static void Main(string[] args) { var dal = new PlanDAL(); DirectoryInfo root = new DirectoryInfo("D:/个人/Cherimoya20161008/Cherimoya20180726/Cherimoya/Mathy.Web/Repository/Plans1"); FileInfo[] files = root.GetFiles(); foreach (var n in files.OrderByDescending(m => m.CreationTime)) { var text = File.ReadAllText(n.FullName, Encoding.UTF8); var plan = Plan.Parse(text); plan.Description = ""; var f = JsonConvert.SerializeObject(plan); dal.AddPlanRepository(n.Name.Replace(".txt", ""), f); } }
public ActionResult InitPlanRepo() { var path = AppDomain.CurrentDomain.BaseDirectory + @"Repository\Plans"; DirectoryInfo root = new DirectoryInfo(path); var list = new List <PlanRepositoryEntity>(); foreach (var n in root.GetFiles()) { var pr = new PlanRepositoryEntity { PlanID = n.Name.Split('.')[0], Text = System.IO.File.ReadAllText(n.FullName) }; var dal = new PlanDAL(); dal.AddPlanRepository(pr.PlanID, pr.Text); list.Add(pr); } return(Content("完成" + list.Count())); }
private object GetPlanList(int?pageIndex, string planName, string begindate, string enddate, string content, string author = "", bool isAuth = true, string category = "") { int pageSize = string.IsNullOrEmpty(author) ? 5 : 5; var pageList = new PlanDAL().GetPlanList(pageIndex.Value, pageSize, planName, begindate, enddate, content, author, isAuth, category); pageList.Data.ToList().ForEach(m => m.SeqNo = m.SeqNo == 0 ? 99999 : m.SeqNo); var list = pageList.Data; ViewBag.pageIndex = pageIndex; var planCount = pageList.Page.TotalCount; ViewBag.TotalPage = planCount / pageSize + 1; ViewBag.planName = planName; ViewBag.begindate = begindate; ViewBag.enddate = enddate; ViewBag.content = content; var dal = new UserDAL(); var users = dal.GetUsers(new Model.Serach.UserSearch()); var setTemp = (from n in list join u in users on n.Author equals u.UserID.ToString() select n.Author = u.Name).ToList(); return(list.Select(i => new PlanListCellVM(i, pageIndex.Value - 1, author)).ToList()); }
public Plan Save(string id, Stream stream) { string content = null; using (StreamReader reader = new StreamReader(stream, System.Text.Encoding.UTF8)) { content = reader.ReadToEnd(); } Plan plan = null; try { plan = Plan.Parse(content); } catch (Exception ex) { throw new Exception("解析试验计划文件错误。\r\n通常是因为实验文件内容错误造成。请检查您的实验文件,或联系相关人员协助解决。\r\n错误信息:\r\n" + ex.Message); } var dal = new PlanDAL(); //dal. dal.AddPlanRepository(id, content); return(plan); }
public Plan Get(string id) { var content = new PlanDAL().GetRepository(id); return(Plan.Parse(content.Text)); }
public List <Plan> TraerPlanesHabilitados() { List <Plan> listaplanes = new List <Plan>(); return(listaplanes = PlanDAL.SelectAll()); }
/// <summary> /// 添加,编辑设备和点检项关联信息 /// </summary> /// <param name="nodeKey"></param> /// <param name="oArea">删除的纪录</param> /// <param name="iArea">添加的纪录</param> /// <param name="errMsg"></param> /// <returns></returns> public bool AddDeviceAndItemRealtion(string nodeKey, string[] oArea, string[] iArea, out string errMsg) { int oCou = 0; int iCou = 0; int count = 0; bool flag = false; object obj = null; DataRow drRou = null; DataRow drDev = null; DataRow drArea = null; errMsg = ""; //查询线路区域设备ID PlanDAL pd = new PlanDAL(); sql = "SELECT T_NODEID,T_PARAENTID FROM T_INFO_ROUTE where T_NODEKEY='" + nodeKey + "'"; drDev = DBdb2.RunDataRow(sql, out errMsg); if (drDev != null) { sql = "SELECT T_NODEID,T_PARAENTID FROM T_INFO_ROUTE where T_NODEKEY='" + drDev["T_PARAENTID"] + "'"; drArea = DBdb2.RunDataRow(sql, out errMsg); if (drArea != null) { sql = "SELECT T_NODEID,T_PARAENTID FROM T_INFO_ROUTE where T_NODEKEY='" + drArea["T_PARAENTID"] + "' and T_DESC='XL'"; drRou = DBdb2.RunDataRow(sql, out errMsg); #region 除点检项关系 if (oArea != null) { string[] route = new string[oArea.Length]; string[] area = new string[oArea.Length]; string[] device = new string[oArea.Length]; string[] item = new string[oArea.Length]; int[] judge = new int[oArea.Length]; //操作类型:创建点检项关系 删除点检项关系 编辑点检项 编辑设备状态 string[] sTimes = new string[oArea.Length]; string[] type = new string[oArea.Length]; string[] count1 = new string[oArea.Length]; string[] devState = new string[oArea.Length]; string[] state = new string[oArea.Length]; for (int i = 0; i < oArea.Length; i++) { route[i] = drRou["T_NODEID"].ToString(); area[i] = drArea["T_NODEID"].ToString(); device[i] = drDev["T_NODEID"].ToString(); sql = "select * from T_BASE_ITEM where ID_KEY=" + oArea[i]; DataRow drItem = DBdb2.RunDataRow(sql, out errMsg); if (drItem != null) { item[i] = drItem["T_ITEMID"].ToString(); judge[i] = 1; //操作类型:创建点检项关系 0 删除点检项关系 1 编辑点检项 2 编辑设备状态3 sTimes[i] = drItem["T_STARTTIME"].ToString(); // itemStartTime; //T_STARTTIME type[i] = drItem["T_PERIODTYPE"].ToString(); //itemPerType; //T_PERIODTYPE count1[i] = drItem["T_PERIODVALUE"].ToString(); // itemPerValue;//T_PERIODVALUE devState[i] = drItem["I_STATUS"].ToString(); // itemStatus;//I_STATUS state[i] = drItem["T_STATUS"].ToString(); // itemStatusQJ;//T_STATUS sql = "delete from T_INFO_ROUTE where T_PARAENTID='" + nodeKey + "' and T_NODEID='" + drItem["T_ITEMID"].ToString() + "' and T_DESC='DJX'"; int j = DBdb2.RunCommand(sql, out errMsg); if (j > 0) { oCou = 1; } } } flag = pd.EditRelation(route[0], area[0], device[0], item, judge);// qc.ManageQuestcomplete(route, area, device, item, judge, sTimes, type, count1, devState, state); //public bool EditRelation(string routeID, string areaID, string deviceID, string[] items, int[] judge) } else { oCou = 1; } #endregion #region 添加点检项关系 if (iArea != null) { string[] route = new string[iArea.Length]; string[] area = new string[iArea.Length]; string[] device = new string[iArea.Length]; string[] item = new string[iArea.Length]; int[] judge = new int[iArea.Length]; //操作类型:创建点检项关系 删除点检项关系 编辑点检项 编辑设备状态 string[] sTimes = new string[iArea.Length]; string[] type = new string[iArea.Length]; string[] count1 = new string[iArea.Length]; string[] devState = new string[iArea.Length]; string[] state = new string[iArea.Length]; for (int i = 0; i < iArea.Length; i++) { route[i] = drRou["T_NODEID"].ToString(); area[i] = drArea["T_NODEID"].ToString(); device[i] = drDev["T_NODEID"].ToString(); sql = "select * from T_BASE_ITEM where ID_KEY=" + iArea[i]; DataRow drItem = DBdb2.RunDataRow(sql, out errMsg); if (drItem != null) { item[i] = drItem["T_ITEMID"].ToString(); judge[i] = 0; //操作类型:创建点检项关系 0 删除点检项关系 1 编辑点检项 2 编辑设备状态3 sTimes[i] = drItem["T_STARTTIME"].ToString(); // itemStartTime; //T_STARTTIME type[i] = drItem["T_PERIODTYPE"].ToString(); //itemPerType; //T_PERIODTYPE count1[i] = drItem["T_PERIODVALUE"].ToString(); // itemPerValue;//T_PERIODVALUE devState[i] = drItem["I_STATUS"].ToString(); // itemStatus;//I_STATUS state[i] = drItem["T_STATUS"].ToString(); // itemStatusQJ;//T_STATUS sql = "select T_NODEKEY from T_INFO_ROUTE order by ID_KEY DESC fetch first 1 rows only "; obj = DBdb2.GetSingle(sql); if (obj != null && obj.ToString() != "") { count = int.Parse(obj.ToString()) + 1; } sql = "insert into T_INFO_ROUTE (T_NODEID,T_NODEKEY,T_PARAENTID,T_DESC) values ('" + drItem["T_ITEMID"].ToString() + "','" + count + "','" + nodeKey + "','DJX')"; int j = DBdb2.RunCommand(sql, out errMsg); if (j > 0) { iCou = 1; } } } flag = pd.EditRelation(route[0], area[0], device[0], item, judge); //flag = qc.ManageQuestcomplete(route, area, device, item, judge, sTimes, type, count1, devState, state); } else { iCou = 1; } #endregion if (iCou == 1 && oCou == 1) { } else { errMsg = "无论新增或删除设备和点检项关系,有一项失败!"; } } } return(flag); }
public PlanBLL() { this.planDAL = new PlanDAL(); }