private void UpdateTaskStatus(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 (TimeStart != "")
{
TimeStart = Convert.ToDateTime(TimeStart).ToString("yyyy-MM-dd HH:mm:ss");
}
string TimeEnd = context.Request["TimeEnd"];
if (TimeEnd != "")
{
Convert.ToDateTime(TimeEnd).ToString("yyyy-MM-dd HH:mm:ss");
}
BLL.V_TaskDetailSimple bll = new BLL.V_TaskDetailSimple();
bool updateRes = bll.UpdateTaskStatus(dragFrom, dropTo, TD_ID, TD_CardType, TimeStart, TimeEnd);
if (updateRes)
{
context.Response.Write("success");
}
else
{
context.Response.Write("fail");
}
}
private void GetTaskBoardPersonal(HttpContext context)
{
BLL.V_TaskDetailSimple bll = new BLL.V_TaskDetailSimple();
DataSet ds = bll.GetList(string.Format("TD_AssignedUserID like '%,{0},%' and TD_Status!=''", context.Request["User_ID"]), 8);
List <Model.V_TaskDetailSimple> list = new List <Model.V_TaskDetailSimple>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
list.Add(new Model.V_TaskDetailSimple()
{
TD_ID = Convert.ToInt32(dr["TD_ID"]),
TD_Status = dr["TD_Status"].ToString(),
TD_TaskTitle = dr["TD_TaskTitle"].ToString(),
TD_ScenarioTitle = dr["TD_ScenarioTitle"].ToString(),
TD_RoleTitle = dr["TD_RoleTitle"].ToString(),
TD_AssignedUserName = dr["TD_AssignedUserName"].ToString(),
TD_CardType = dr["TD_CardType"].ToString(),
TD_Date = Convert.ToDateTime(dr["TD_DateStart"]).ToString("MM/dd/yyyy") + '-' + Convert.ToDateTime(dr["TD_DateEnd"]).ToString("MM/dd/yyyy"),
TD_Owner = dr["TD_Owner"].ToString(),
TD_TaskType = dr["TD_TaskType"].ToString(),
TD_OwnerID = dr["TD_OwnerID"].ToString()
});
}
JavaScriptSerializer jss = new JavaScriptSerializer();
string strJson = jss.Serialize(list);//.TrimStart('[').TrimEnd(']');
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);
}
