public ActionResult Create([Bind(Include = "ModGUID,ModName,ModUid,ModPassword,ModDataBase,ModServer,ModDataSource,ModRemark")] DSTreeModel dSTreeModel)
{
if (ModelState.IsValid)
{
dSTreeModel.ModGUID = Guid.NewGuid();
dSTreeModel.ModStatus = "等待执行";
db.DSTreeModel.Add(dSTreeModel);
db.SaveChanges();
SQLHelper sqdb = new SQLHelper(dSTreeModel.GetConnString());
string sDataSource = "select top 1 * from (" + dSTreeModel.ModDataSource + ") tmp";
DataTable dt = sqdb.GetTable(sDataSource);
if (dt != null)
{
int ic = dt.Columns.Count;
DataTable dtCNPy = NPy.getDtCNPy(dt, ic);
List <DSTreeCEMap> ldstcm = new List <DSTreeCEMap>();
for (int i = 0; i < ic; i++)
{
DSTreeCEMap dstcm = new DSTreeCEMap();
dstcm.CEMapGUID = Guid.NewGuid();
dstcm.ModGUID = dSTreeModel.ModGUID;
dstcm.CCellName = dt.Columns[i].ColumnName;
dstcm.ECellName = dtCNPy.Select("cnC='" + dstcm.CCellName + "'")[0][1].ToString();
db.DSTreeCEMap.Add(dstcm);
}
db.SaveChanges();
}
return(RedirectToAction("Index", new { ModGUID = dSTreeModel.ModGUID }));
}
return(View(dSTreeModel));
}
public JsonResult ListSave(List <DSTreeCEMap> dscemlist)
{
foreach (DSTreeCEMap dscem in dscemlist)
{
db.Entry(dscem).State = EntityState.Modified;
db.SaveChanges();
}
return(Json("success"));
}
public ActionResult Create([Bind(Include = "DSTreeGUID,ModGUID,ID,PID,FactorName,FactorNameCn,Operator,OperatorCn,FactorValue,FactorValueCn,Describe,DescribeCn,Result,ResultCn,CoverCount,ErroCount")] DSTree dSTree)
{
if (ModelState.IsValid)
{
dSTree.DSTreeGUID = Guid.NewGuid();
db.DSTree.Add(dSTree);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(dSTree));
}
public HttpResponseMessage Post([FromBody] Registration registration)
{
try
{
using (DSEntities entities = new DSEntities())
{
entities.Registrations.Add(registration);
entities.SaveChanges();
var message = Request.CreateResponse(HttpStatusCode.Created, registration);
message.Headers.Location = new Uri(Request.RequestUri + registration.ID.ToString());
return(message);
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}