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