public JObject Add(JObject data) { try { DBServer dbserver = new SqlServer(); dbserver.BeginTranscation(); PriorityWatch model = new PriorityWatch(dbserver); JArray data_detail = null; JToken token = null; if (data.TryGetValue("detail", out token) == true) { data_detail = (JArray)token; foreach (JObject items in data_detail) { items.Remove("ID"); items.Add(new JProperty("ID", GUID.NewGuid())); } } if ((model.Save(data_detail) == 0)) { dbserver.Commit(); return(ShowSuccess("保存成功.")); } else { dbserver.Rollback(); return(ShowExecuteError("保存失败.")); } } catch (Exception ex) { return(ShowExecuteError(ex.Message)); } }
public JObject Delete(JObject data) { //if (!LoginCheck()) //{ // return ShowLoginCheckError(); //} //if (!AuthorityCheck("131460")) //{ // return ShowAuthorityCheckError(); //} try { DBServer dbserver = new SqlServer(); PriorityWatch rolemodel = new PriorityWatch(dbserver); string ID = data["data"].ToString().Replace("\"", ""); string filter = String.Format("ID='{0}'", ID); int res = rolemodel.Delete("ID", ID); if (res > 0) { return(ShowSuccess("成功删除" + res + "条记录.")); } else { return(ShowExecuteError("删除失败.")); } } catch (Exception ex) { return(ShowExecuteError(ex.Message)); } }
public JObject PageLoad(long start, long limit, string field, string direction, string searchInfo, string logincode) { try { DBServer dbserver = new SqlServer(); PriorityWatch mybase = new PriorityWatch(dbserver); string filterf = string.Empty; if (searchInfo == null) { filterf = string.Format("nvcLoginCode='{0}'", logincode); return(mybase.Load(filterf)); } else { filterf = string.Format("nvcLoginCode='{0}' and nvcStuNo like '%{1}%' ", logincode, searchInfo); return(mybase.Load(filterf)); } } catch (Exception ex) { return(ShowDataLoadError(ex.Message)); } }