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