public string editProject(int ID, string Pname, string deviceList, string appList) { QCTESTEntities QC_DB = new QCTESTEntities(); var u = QC_DB.project.First(t => t.ID == ID); u.Pname = Pname; //设备 var dpm = QC_DB.M_DevProMapping.Where(t => t.PID == ID); List <string> deviceID; if (string.IsNullOrEmpty(deviceList.TrimEnd(','))) { deviceID = new List <string>(); } else { deviceID = deviceList.TrimEnd(',').Split(',').ToList(); } foreach (var d in dpm) { if (deviceID.Contains(d.DeviceID.ToString())) { d.usable = true; deviceID.Remove(d.DeviceID.ToString()); } else { d.usable = false; } } foreach (var d in deviceID) { M_DevProMapping temp = new M_DevProMapping(); temp.PID = ID; temp.DeviceID = Convert.ToInt32(d); temp.usable = true; QC_DB.M_DevProMapping.Add(temp); } //app var papp = QC_DB.project_app.Where(t => t.PID == ID); List <string> appID; if (string.IsNullOrEmpty(appList.TrimEnd(','))) { appID = new List <string>(); } else { appID = appList.TrimEnd(',').Split(',').ToList(); } foreach (var p in papp) { if (appID.Contains(p.appID.ToString())) { p.usable = true; appID.Remove(p.appID.ToString()); } else { p.usable = false; } } foreach (var p in appID) { project_app temp = new project_app(); temp.PID = ID; temp.appID = Convert.ToInt32(p); temp.usable = true; QC_DB.project_app.Add(temp); } QC_DB.SaveChanges(); return(""); }
public string addProject(string Pname, string deviceList, string appList) { QCTESTEntities QC_DB = new QCTESTEntities(); project pro = new project(); pro.Pname = Pname; pro.zidonghua = true; QC_DB.project.Add(pro); //设备 List <string> deviceID; if (string.IsNullOrEmpty(deviceList.TrimEnd(','))) { deviceID = new List <string>(); } else { deviceID = deviceList.TrimEnd(',').Split(',').ToList(); } foreach (var d in deviceID) { M_DevProMapping temp = new M_DevProMapping(); temp.PID = pro.ID; temp.DeviceID = Convert.ToInt32(d); temp.usable = true; QC_DB.M_DevProMapping.Add(temp); } //app List <string> appID; if (string.IsNullOrEmpty(appList.TrimEnd(','))) { appID = new List <string>(); } else { appID = appList.TrimEnd(',').Split(',').ToList(); } foreach (var p in appID) { project_app temp = new project_app(); temp.PID = pro.ID; temp.appID = Convert.ToInt32(p); temp.usable = true; QC_DB.project_app.Add(temp); } QC_DB.SaveChanges(); return(""); }