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 Add(JObject data)
{
DBServer dbserver = new SqlServer();
try
{
String gbl_ID = String.Empty;
dbserver.BeginTranscation();
Major model = new Major(dbserver);
Detail model_D = new Detail(dbserver);
JToken token = null;
JArray data_detail = null;
JObject data_mian = null;
if (data.TryGetValue("main", out token) == true)
{
data_mian = (JObject)token;
data_mian.Add(new JProperty("ID", GUID.NewGuid()));
gbl_ID = data_mian["ID"].ToString().Replace("\"", "").Trim();
}
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()));
items.Add(new JProperty("nvcAttendanceID", gbl_ID));
}
}
if (model.Create(data_mian) && (model_D.Save(data_detail) == 0))
{
dbserver.Commit();
return(ShowSuccess("保存成功."));
}
else
{
dbserver.Rollback();
return(ShowExecuteError("保存失败."));
}
}
catch (Exception ex)
{
dbserver.Rollback();
return(ShowExecuteError(ex.Message));
}
}
/// <summary>
/// 执行考勤结果提交 2015-08-18 15:06:07
/// </summary>
/// <param name="context"></param>
public void AttendanceAtt(HttpContext context)
{
string json = "{\"success\":false}";
string nvcElectiveNum = context.Request.Form["nvcElectiveNum"];
string nvcLoginCode = context.Request.Form["nvcLoginCode"];
string absentNo = context.Request.Form["absentNo"];
string nvcIP = context.Request.Form["nvcIP"];
string nvcTerminal = context.Request.Form["nvcTerminal"];
string[] students = absentNo.Split(';');
DBServer dbserver = new SqlServer();
try
{
dbserver.BeginTranscation();
string cmd = string.Format("insert into {0} (nvcElectiveNum,nvcLoginCode,nvcRollWay,intRollCount,nvcIP,nvcTerminal) output inserted.ID Values('{1}','{2}','全点',(select MAX(intRollCount) from {0} where nvcElectiveNum='{1}')+1,'{3}','{4}');", AMTable, nvcElectiveNum, nvcLoginCode, nvcIP, nvcTerminal);
DataRow row = dbserver.ExecuteRow(cmd);
string attendanceID = row["ID"].ToString();
int n = 0;
if (students[0] != "")
{
for (int i = 0; i < students.Length; i++)
{
string[] temp = students[i].Split(',');
string cmdText = string.Format("insert into {0} (nvcAttendanceID,nvcStuNo,nvcReason)Values('{1}','{2}','{3}');", ADTable, attendanceID, temp[0], temp[1]);
n += dbserver.ExecuteNonQuery(cmdText);
}
}
dbserver.Commit();
json = "{\"success\":true,\"index\":\"" + n + "\"}";
}
catch
{
dbserver.Rollback();
}
context.Response.Write(json);
}