public Guid Insert(Pre_arrangedPlanning entityToInsert)
 {
     using (Conn)
     {
         return(Conn.Insert <Guid>(entityToInsert));
     }
 }
 public int Delete(Pre_arrangedPlanning entityToInsert)
 {
     using (Conn)
     {
         return(Conn.Delete(entityToInsert));
     }
 }
Exemple #3
0
 private void button4_Click(object sender, EventArgs e)
 {
     if (dataGridView1.CurrentCell != null)
     {
         if (radioButton1.Checked == false && radioButton2.Checked == false && radioButton3.Checked == false)
         {
             MessageBox.Show("请选择具体的时间设置类型!");
             return;
         }
         int index = dataGridView1.CurrentCell.RowIndex;
         AlarmMessageForAll   temp_AlarmMessageForAll   = new AlarmMessageForAll();
         Pre_arrangedPlanning temp_Pre_arrangedPlanning = new Pre_arrangedPlanning();
         string temp_PlanDeviceID = dataGridView1.Rows[index].Cells[9].Value.ToString();
         temp_Pre_arrangedPlanning = ClassPlan.pre_arrangedPlanning.Find(_ => _.PlanDeviceID.ToString() == temp_PlanDeviceID);
         if (temp_Pre_arrangedPlanning == null)
         {
             return;
         }
         temp_AlarmMessageForAll.StartDate    = Start_data1.Value.Date.ToString("yyyy/MM/dd");
         temp_AlarmMessageForAll.StartWeek    = Start_data1.Value.DayOfWeek.ToString();
         temp_AlarmMessageForAll.StartTime    = Start_time1.Text;
         temp_AlarmMessageForAll.EndDate      = Start_data2.Value.Date.ToString("yyyy/MM/dd");
         temp_AlarmMessageForAll.EndWeek      = Start_data2.Value.DayOfWeek.ToString();
         temp_AlarmMessageForAll.EndTime      = Start_time2.Text;
         temp_AlarmMessageForAll.Description  = temp_Pre_arrangedPlanning.Description;
         temp_AlarmMessageForAll.DeviceID     = temp_Pre_arrangedPlanning.DeviceID.ToString();
         temp_AlarmMessageForAll.DeviceType   = temp_Pre_arrangedPlanning.DeviceType.ToString();
         temp_AlarmMessageForAll.Mark         = temp_Pre_arrangedPlanning.Mark;
         temp_AlarmMessageForAll.PlanDeviceID = temp_Pre_arrangedPlanning.PlanDeviceID.ToString();
         temp_AlarmMessageForAll.PlanType     = temp_Pre_arrangedPlanning.PlanType;
         temp_AlarmMessageForAll.PlanTypeID   = temp_Pre_arrangedPlanning.PlanTypeID;
         if (radioButton1.Checked == true)
         {
             temp_AlarmMessageForAll.TimeType = "1";
         }
         else if (radioButton2.Checked == true)
         {
             temp_AlarmMessageForAll.TimeType = "2";
         }
         else if (radioButton3.Checked == true)
         {
             temp_AlarmMessageForAll.TimeType = "3";
         }
         classplan.PlanRevise(temp_AlarmMessageForAll);
     }
     //classplan = new ClassPlan();
     classplan.PlanInit();//重新获取所有预案数据
     DataLoad();
 }
        public override void ExecuteCommand(AppSession session, StringRequestInfo requestInfo)
        {
            PlanData           data       = new PlanData();
            AlarmMessageForAll dataForOne = new AlarmMessageForAll();

            switch (requestInfo[0])
            {
            case "Add":    //添加
            {
                string str = requestInfo.Body.Substring(4);
                dataForOne = JsonConvert.DeserializeObject <AlarmMessageForAll>(str);
                try
                {
                    //插入预案数据
                    Pre_arrangedPlanning temp_Pre_arrangedPlanning = new Pre_arrangedPlanning();
                    temp_Pre_arrangedPlanning.PlanDeviceID = new Guid(dataForOne.PlanDeviceID);
                    temp_Pre_arrangedPlanning.PlanType     = dataForOne.PlanType;
                    temp_Pre_arrangedPlanning.PlanTypeID   = dataForOne.PlanTypeID;
                    temp_Pre_arrangedPlanning.DeviceID     = dataForOne.DeviceID;
                    temp_Pre_arrangedPlanning.DeviceType   = int.Parse(dataForOne.DeviceType);
                    temp_Pre_arrangedPlanning.StartDate    = dataForOne.StartDate;
                    temp_Pre_arrangedPlanning.StartTime    = dataForOne.StartTime;
                    temp_Pre_arrangedPlanning.StartWeek    = dataForOne.StartWeek;
                    temp_Pre_arrangedPlanning.TimeType     = dataForOne.TimeType;
                    temp_Pre_arrangedPlanning.EndDate      = dataForOne.EndDate;
                    temp_Pre_arrangedPlanning.EndTime      = dataForOne.EndTime;
                    temp_Pre_arrangedPlanning.EndWeek      = dataForOne.EndWeek;
                    temp_Pre_arrangedPlanning.Description  = dataForOne.Description;
                    temp_Pre_arrangedPlanning.Mark         = dataForOne.Mark;
                    Pre_arrangedPlanning.Insert(temp_Pre_arrangedPlanning);
                    //插入联动数据
                    LinkageData Trigger_LinkageData = dataForOne.Trigger_LinkageData;        //联动数据
                    if (Trigger_LinkageData != null)
                    {
                        LinkageDataComand.Insert(Trigger_LinkageData);
                    }
                    LinkageData Disposal_LinkageData = dataForOne.Disposal_LinkageData;        //处置数据
                    if (Disposal_LinkageData != null)
                    {
                        LinkageDataComand.Insert(Disposal_LinkageData);
                    }
                    LinkageData Untreated_LinkageData = dataForOne.Untreated_LinkageData;        //未处置数据
                    if (Untreated_LinkageData != null)
                    {
                        LinkageDataComand.Insert(Untreated_LinkageData);
                    }
                }
                catch (Exception ex)
                {
                    Console.WriteLine(ex.ToString());
                }
            }
            break;

            case "Del":    //删除
            {
                string str = requestInfo.Body.Substring(4);
                dataForOne = JsonConvert.DeserializeObject <AlarmMessageForAll>(str);
                try
                {
                    Pre_arrangedPlanning.Delete(new Guid(dataForOne.PlanDeviceID));
                    LinkageData Trigger_LinkageData = dataForOne.Trigger_LinkageData;        //联动数据
                    if (Trigger_LinkageData != null)
                    {
                        LinkageDataComand.Delete(Trigger_LinkageData);
                    }
                    LinkageData Disposal_LinkageData = dataForOne.Disposal_LinkageData;        //处置数据
                    if (Disposal_LinkageData != null)
                    {
                        LinkageDataComand.Delete(Disposal_LinkageData);
                    }
                    LinkageData Untreated_LinkageData = dataForOne.Untreated_LinkageData;        //未处置数据
                    if (Untreated_LinkageData != null)
                    {
                        LinkageDataComand.Delete(Untreated_LinkageData);
                    }
                }
                catch (Exception)
                {
                    throw;
                }
            }
            break;

            case "Revise":    //修改
            {
                string str = requestInfo.Body.Substring(7);
                dataForOne = JsonConvert.DeserializeObject <AlarmMessageForAll>(str);
                try
                {
                    //插入预案数据
                    Pre_arrangedPlanning temp_Pre_arrangedPlanning = new Pre_arrangedPlanning();
                    temp_Pre_arrangedPlanning.PlanDeviceID = new Guid(dataForOne.PlanDeviceID);
                    temp_Pre_arrangedPlanning.PlanType     = dataForOne.PlanType;
                    temp_Pre_arrangedPlanning.PlanTypeID   = dataForOne.PlanTypeID;
                    temp_Pre_arrangedPlanning.DeviceID     = dataForOne.DeviceID;
                    temp_Pre_arrangedPlanning.DeviceType   = int.Parse(dataForOne.DeviceType);
                    temp_Pre_arrangedPlanning.StartDate    = dataForOne.StartDate;
                    temp_Pre_arrangedPlanning.StartTime    = dataForOne.StartTime;
                    temp_Pre_arrangedPlanning.StartWeek    = dataForOne.StartWeek;
                    temp_Pre_arrangedPlanning.TimeType     = dataForOne.TimeType;
                    temp_Pre_arrangedPlanning.EndDate      = dataForOne.EndDate;
                    temp_Pre_arrangedPlanning.EndTime      = dataForOne.EndTime;
                    temp_Pre_arrangedPlanning.EndWeek      = dataForOne.EndWeek;
                    temp_Pre_arrangedPlanning.Description  = dataForOne.Description;
                    temp_Pre_arrangedPlanning.Mark         = dataForOne.Mark;
                    Pre_arrangedPlanning.Update(temp_Pre_arrangedPlanning);
                    //插入联动数据
                    LinkageData Trigger_LinkageData = dataForOne.Trigger_LinkageData;        //联动数据
                    if (Trigger_LinkageData != null)
                    {
                        LinkageDataComand.Update(Trigger_LinkageData);
                    }
                    LinkageData Disposal_LinkageData = dataForOne.Disposal_LinkageData;        //处置数据
                    if (Disposal_LinkageData != null)
                    {
                        LinkageDataComand.Update(Disposal_LinkageData);
                    }
                    LinkageData Untreated_LinkageData = dataForOne.Untreated_LinkageData;        //未处置数据
                    if (Untreated_LinkageData != null)
                    {
                        LinkageDataComand.Update(Untreated_LinkageData);
                    }
                }
                catch (Exception)
                {
                    throw;
                }
            }
            break;

            case "Query":    //查询
            {
                List <Pre_arrangedPlanning> pre_arrangedPlanning;
                List <ArmAndDisarmList>     armAndDisarmList;
                List <LinkageData>          linkageData;
                List <CameraList>           cameraList;
                List <StreamMediaList>      streamMediaList;
                List <StreamServerList>     streamServerList;
                //获取数据库的所有设备信息
                pre_arrangedPlanning = Pre_arrangedPlanning.GetList();
                armAndDisarmList     = ArmAndDisArm.GetList();
                linkageData          = LinkageDataComand.GetList();
                cameraList           = CameraList.GetList();
                streamMediaList      = StreamMediaList.GetList();
                streamServerList     = StreamServerList.GetList();
                //组装数据
                data.pre_arrangedPlanning = pre_arrangedPlanning;
                data.armAndDisarmList     = armAndDisarmList;
                data.linkageData          = linkageData;
                data.cameraList           = cameraList;
                data.streamMediaList      = streamMediaList;
                data.streamServerList     = streamServerList;
                //转json
                string str = JsonConvert.SerializeObject(data);
                session.Send(str);
            }
            break;

            case "Query1":
                List <Pre_arrangedPlanning> pre_arrangedPlanning1;
                pre_arrangedPlanning1 = Pre_arrangedPlanning.GetList();
                for (int i = 0; i < pre_arrangedPlanning1.Count; i++)
                {
                    if (pre_arrangedPlanning1[i].PlanType != 2)
                    {
                        pre_arrangedPlanning1.Remove(pre_arrangedPlanning1[i]);
                    }
                }
                //转json
                string str1 = JsonConvert.SerializeObject(pre_arrangedPlanning1);
                session.Send(str1);
                break;
            }
        }