private void QueryDailyReportList(HttpContext context) { string U_ID = context.Request["U_ID"]; string DR_Date = context.Request["DR_Date"]; if (string.IsNullOrEmpty(DR_Date)) { DR_Date = DateTime.Now.ToString("yyyy-MM-dd"); } else { DR_Date = Convert.ToDateTime(DR_Date).ToString("yyyy-MM-dd"); } BLL.V_DailyReport bll = new BLL.V_DailyReport(); DataSet ds = bll.GetList(string.Format("DR_Resources={0} and DR_UpdateDate='{1}'", U_ID, DR_Date)); List <Model.V_DailyReport> list = new List <Model.V_DailyReport>(); foreach (DataRow dr in ds.Tables[0].Rows) { list.Add(new Model.V_DailyReport() { //DR_UpdateDate = dr["DR_UpdateDate"] DR_Type = dr["DR_Type"].ToString(), BTT_Title = dr["BTT_Title"].ToString(), BTT_Status = dr["BTT_Status"].ToString(), BTT_Progress = dr["BTT_Progress"].ToString() == "N/A" ? "N/A" : dr["BTT_Progress"].ToString() + '%', BTT_Owner = dr["BTT_Owner"].ToString(), DR_ResourcesName = dr["DR_ResourcesName"].ToString() }); } JavaScriptSerializer jss = new JavaScriptSerializer(); string strJson = jss.Serialize(list); context.Response.Write(strJson); }
private void UpdataTaskProgress(HttpContext context) { int TD_ID = Convert.ToInt32(context.Request["TD_ID"]); string TD_CardType = context.Request["TD_CardType"]; string dragFrom = context.Request["dragFrom"]; string dropTo = context.Request["dropTo"]; string TimeStart = context.Request["TimeStart"]; if (!string.IsNullOrEmpty(TimeStart)) { TimeStart = Convert.ToDateTime(TimeStart).ToString("yyyy-MM-dd HH:mm:ss"); } string TimeEnd = context.Request["TimeEnd"]; if (!string.IsNullOrEmpty(TimeEnd)) { TimeEnd = Convert.ToDateTime(TimeEnd).ToString("yyyy-MM-dd HH:mm:ss"); } string SR_CasePassed = context.Request["SR_CasePassed"]; string SR_CaseFailed = context.Request["SR_CaseFailed"]; string SR_CaseNA = context.Request["SR_CaseNA"]; string SR_CaseRedmond = context.Request["SR_CaseRedmond"]; string TD_Progress = context.Request["TD_Progress"]; string TD_CompleteReason = context.Request["TD_CompleteReason"]; string ResourcesID = context.Request["User_ID"]; BLL.V_TaskDetailSimple bll = new BLL.V_TaskDetailSimple(); // Refresh:刷新Middle和RightPanel; TaskStart:任务开始;SaveSuccess:进度保存成功 // Update Fail:数据库更新错误;Data Fail:数据参数错误 string UpdateRes = bll.UpdateTaskProgress(dragFrom, dropTo, TD_ID, TD_CardType, TimeStart, TimeEnd, SR_CasePassed, SR_CaseFailed, SR_CaseNA, SR_CaseRedmond, TD_Progress, TD_CompleteReason); if (TD_CardType == "private" || (dragFrom == "LeftPanel" && dropTo == "MiddlePanel")) { } else { // 当public的任务且不是ToDo到Doing的时候,更新Case的进度。 int TT_ID = Convert.ToInt32(context.Request["TT_ID"]); string SR_CasePassedGrow = context.Request["SR_CasePassedGrow"]; string SR_CaseFailedGrow = context.Request["SR_CaseFailedGrow"]; string SR_CaseNAGrow = context.Request["SR_CaseNAGrow"]; string SR_CaseRedmondGrow = context.Request["SR_CaseRedmondGrow"]; bll.UpdateCaseNumTotalDaily(TT_ID, SR_CasePassedGrow, SR_CaseFailedGrow, SR_CaseNAGrow, SR_CaseRedmondGrow); } // Add Daily Report BLL.V_DailyReport bllDR = new BLL.V_DailyReport(); bllDR.Add(ResourcesID, TD_ID, TD_CardType == "private" ? "TP" : "TT"); context.Response.Write(UpdateRes); }
private void ReOpenBugIssue(HttpContext context) { int BI_ID = Convert.ToInt32(context.Request["BI_ID"]); int User_ID = Convert.ToInt32(context.Request["User_ID"]); BLL.BugIssue bll = new BLL.BugIssue(); bool ReOpenRes = bll.ReOpenBugIssue(BI_ID, User_ID); if (ReOpenRes) { // Add Daily Report BLL.V_DailyReport bllDR = new BLL.V_DailyReport(); bllDR.Add(User_ID.ToString(), BI_ID, "BI"); context.Response.Write("success"); } else { context.Response.Write("fail"); } }
private void AddBugIssue(HttpContext context) { Model.BugIssue model = new Model.BugIssue(); BLL.BugIssue bll = new BLL.BugIssue(); model.BI_FK_SR_ID = Convert.ToInt32(string.IsNullOrEmpty(context.Request["BI_FK_SR_ID"]) ? "0" : context.Request["BI_FK_SR_ID"]); model.BI_FK_S_ID = Convert.ToInt32(string.IsNullOrEmpty(context.Request["BI_FK_S_ID"]) ? "0" : context.Request["BI_FK_S_ID"]); model.BI_FK_TT_ID = Convert.ToInt32(string.IsNullOrEmpty(context.Request["BI_FK_TT_ID"]) ? "0" : context.Request["BI_FK_TT_ID"]); model.BI_Title = context.Request["BI_Title"]; model.BI_Type = context.Request["BI_Type"]; model.BI_Content = context.Request["BI_Content"]; model.BI_EnvironmentServer = context.Request["BI_EnvironmentServer"]; model.BI_TopologyName = context.Request["BI_TopologyName"]; model.BI_Remark = ""; model.BI_CaseNumber = context.Request["BI_CaseNumber"]; model.BI_CreateDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); model.BI_Status = "Open"; model.BI_Owner = Convert.ToInt32(context.Request["BI_Owner"]); model.BI_CloseTime = ""; model.BI_ReferenceBIID = 0; model.BI_UpdateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); model.BI_Priority = context.Request["BI_Priority"]; int AddRes = bll.Add(model); if (AddRes > 0) { // Add Daily Report BLL.V_DailyReport bllDR = new BLL.V_DailyReport(); bllDR.Add(model.BI_Owner.ToString(), AddRes, "BI"); context.Response.Write("success"); } else { context.Response.Write("fail"); } }