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