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();
}
