private void commitChange(HttpContext context)
{
Yawei.DataAccess.Database db = Yawei.DataAccess.DatabaseFactory.CreateDatabase();
JavaScriptSerializer jsonSerial = new JavaScriptSerializer();
ResultStatus rs = new ResultStatus();
rs.IsSucess = "0";
rs.ErrorInfo = "";
string proGuid = context.Request.Params["changeids"] ?? "";
try
{
string userguid = context.Request.Params["userguid"] ?? "";
string bmguid = context.Request.Params["bmguid"] ?? "";
//tz_projecthistory
if (proGuid != "")
{
proGuid = proGuid.Substring(0, proGuid.Length - 1);
}
string[] id = proGuid.Split(',');
int commitCount = 0;
for (int i = 0; i < id.Length; i++)
{
//只能提交未提交的或者退回的变更
string sql2 = "";
sql2 = " update tz_xmgz set status='1' where guid=" + id[i] + " and (status='0' or status='2')";
int result = db.ExecuteNonQuery(sql2);
if (result != 0)
{
string sql = " insert into tz_changehistory(Guid,changeguid,changeaction,InfoData,CreateDate,CreateUserGuid,CreateDepGuid) values(newid(),@changeguid,@changeaction,@InfoData,getdate(),@CreateUserGuid,@CreateDepGuid)";
var dbcmd = db.CreateCommand(System.Data.CommandType.Text, sql);
db.AddInParameter(dbcmd, "@changeguid", System.Data.DbType.String, proGuid.Replace("'", ""));
db.AddInParameter(dbcmd, "@changeaction", System.Data.DbType.String, "提交");
db.AddInParameter(dbcmd, "@InfoData", System.Data.DbType.String, "提交");
db.AddInParameter(dbcmd, "@CreateUserGuid", System.Data.DbType.String, userguid);
db.AddInParameter(dbcmd, "@CreateDepGuid", System.Data.DbType.String, bmguid);
db.ExecuteNonQuery(dbcmd);
}
//获取成功提交的项目数量
commitCount += result;
}
rs.IsSucess = "1";
rs.Data = commitCount + "";
}
catch (Exception ex)
{
rs.IsSucess = "0";
rs.ErrorInfo = context.Server.HtmlDecode(ex.Message + "\r\n" + ex.StackTrace);
rs.Data = "0";
}
string retinfo = jsonSerial.Serialize(rs);
context.Response.Write(retinfo);
}
private void successChange(HttpContext context)
{
Yawei.DataAccess.Database db = Yawei.DataAccess.DatabaseFactory.CreateDatabase();
JavaScriptSerializer jsonSerial = new JavaScriptSerializer();
ResultStatus rs = new ResultStatus();
rs.IsSucess = "0";
rs.ErrorInfo = "";
string changeid = context.Request.Params["changeguid"] ?? "";
string info = context.Request.Params["info"] ?? "";
try
{
string userguid = context.Request.Params["userguid"] ?? "";
string bmguid = context.Request.Params["depguid"] ?? "";
int commitCount = 0;
string sql = " insert into tz_changehistory(Guid,changeguid,changeaction,InfoData,CreateDate,CreateUserGuid,CreateDepGuid) values(newid(),@changeguid,@changeaction,@InfoData,getdate(),@CreateUserGuid,@CreateDepGuid)";
var dbcmd = db.CreateCommand(System.Data.CommandType.Text, sql);
db.AddInParameter(dbcmd, "@changeguid", System.Data.DbType.String, changeid);
db.AddInParameter(dbcmd, "@changeaction", System.Data.DbType.String, "审核");
db.AddInParameter(dbcmd, "@InfoData", System.Data.DbType.String, info);
db.AddInParameter(dbcmd, "@CreateUserGuid", System.Data.DbType.String, userguid);
db.AddInParameter(dbcmd, "@CreateDepGuid", System.Data.DbType.String, bmguid);
db.ExecuteNonQuery(dbcmd);
//只能提交未提交的或者退回的变更
string sql2 = "";
sql2 = " update tz_xmgz set status='3' where guid='" + changeid + "'";
//获取成功提交的项目数量
commitCount += db.ExecuteNonQuery(sql2);
rs.IsSucess = "1";
rs.Data = commitCount + "";
//将变更同步到项目数据
saveChange(changeid);
}
catch (Exception ex)
{
rs.IsSucess = "0";
rs.ErrorInfo = context.Server.HtmlDecode(ex.Message + "\r\n" + ex.StackTrace);
rs.Data = "0";
}
string retinfo = jsonSerial.Serialize(rs);
context.Response.Write(retinfo);
}
