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