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