private void UpdateTaskListTotal(HttpContext context) { BLL.TaskTotal bll = new BLL.TaskTotal(); Model.TaskTotal model = new Model.TaskTotal(); model = bll.GetModel(Convert.ToInt32(context.Request["TT_ID"])); model.TT_ID = Convert.ToInt32(context.Request["TT_ID"]); model.TT_Release = context.Request["TT_Release"]; model.TT_BuildType = context.Request["TT_BuildType"]; model.TT_TaskStyle = context.Request["TT_TaskStyle"]; model.TT_TaskType = context.Request["TT_TaskType"]; model.TT_CU = context.Request["TT_CU"]; model.TT_BuildNum = context.Request["TT_BuildNum"]; model.TT_CaseTotalNum = context.Request["TT_CaseTotalNum"]; model.TT_DateStart = Convert.ToDateTime(context.Request["TT_DateStart"]).ToString("yyyy-MM-dd"); model.TT_DateEnd = Convert.ToDateTime(context.Request["TT_DateEnd"]).ToString("yyyy-MM-dd"); model.TT_Comments = context.Request["TT_Comments"]; model.TT_ServerClient = context.Request["TT_ServerClient"]; bool UpdateResult = bll.Update(model); if (UpdateResult) { context.Response.Write("success"); } else { context.Response.Write("fail"); } }
public Model.TaskTotal GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from TaskTotal "); strSql.Append("where TT_ID=@TT_ID"); SqlParameter[] parameters = { new SqlParameter("@TT_ID", SqlDbType.Int, 4) }; parameters[0].Value = ID; Model.TaskTotal model = new Model.TaskTotal(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { DataRow dr = ds.Tables[0].Rows[0]; model.TT_ID = Convert.ToInt32(dr["TT_ID"]); model.TT_Release = dr["TT_Release"].ToString(); model.TT_CU = dr["TT_CU"].ToString(); model.TT_BuildType = dr["TT_BuildType"].ToString(); model.TT_BuildNum = dr["TT_BuildNum"].ToString(); model.TT_TaskType = dr["TT_TaskType"].ToString(); model.TT_CaseTotalNum = dr["TT_CaseTotalNum"].ToString(); model.TT_CaseRealRunNum = dr["TT_CaseRealRunNum"].ToString(); model.TT_DateStart = dr["TT_DateStart"].ToString(); model.TT_DateEnd = dr["TT_DateEnd"].ToString(); model.TT_TaskStyle = dr["TT_TaskStyle"].ToString(); model.TT_BugIssueNum = dr["TT_BugIssueNum"].ToString(); model.TT_ReportLink = dr["TT_ReportLink"].ToString(); model.TT_Comments = dr["TT_Comments"].ToString(); model.TT_CreateDate = dr["TT_CreateDate"].ToString(); model.TT_TaskProgress = dr["TT_TaskProgress"].ToString(); model.TT_TaskStatus = dr["TT_TaskStatus"].ToString(); model.TT_HaveScenario = dr["TT_HaveScenario"].ToString(); model.TT_TimeStart = dr["TT_TimeStart"].ToString(); model.TT_TimeEnd = dr["TT_TimeEnd"].ToString(); model.TT_TimeUsed = dr["TT_TimeUsed"].ToString(); model.TT_Title = dr["TT_Title"].ToString(); model.TT_CompleteReason = dr["TT_CompleteReason"].ToString(); model.TT_ServerClient = dr["TT_ServerClient"].ToString(); return(model); } else { return(null); } }
private void GetTaskTotalInfoSingle(HttpContext context) { BLL.TaskTotal bll = new BLL.TaskTotal(); Model.TaskTotal model = new Model.TaskTotal(); model = bll.GetModel(Convert.ToInt32(context.Request["id"])); List <Model.TaskTotal> list = new List <Model.TaskTotal>(); list.Add(new Model.TaskTotal { TT_ID = model.TT_ID, TT_Release = model.TT_Release, TT_CU = model.TT_CU, TT_BuildType = model.TT_BuildType, TT_BuildNum = model.TT_BuildNum, TT_TaskType = model.TT_TaskType, TT_CaseTotalNum = model.TT_CaseTotalNum, TT_CaseRealRunNum = model.TT_CaseRealRunNum, TT_DateStart = Convert.ToDateTime(model.TT_DateStart).ToString("MM/dd/yyyy"), TT_DateEnd = Convert.ToDateTime(model.TT_DateEnd).ToString("MM/dd/yyyy"), TT_Date = Convert.ToDateTime(model.TT_DateStart).ToString("dd/MM/yyyy") + " - " + Convert.ToDateTime(model.TT_DateEnd).ToString("dd/MM/yyyy"), TT_TaskStyle = model.TT_TaskStyle, TT_BugIssueNum = model.TT_BugIssueNum, TT_ReportLink = model.TT_ReportLink, TT_Comments = model.TT_Comments, TT_CreateDate = model.TT_CreateDate, TT_TaskProgress = model.TT_TaskProgress + '%', TT_TaskStatus = model.TT_TaskStatus, TT_HaveScenario = model.TT_HaveScenario, TT_TimeStart = string.IsNullOrEmpty(model.TT_TimeStart) ? "Task Not Start" : model.TT_TimeStart, TT_TimeEnd = string.IsNullOrEmpty(model.TT_TimeEnd) ? "Task Not End" : model.TT_TimeEnd, TT_TimeUsed = Minute2Day(model.TT_TimeUsed), TT_Title = model.TT_Title, TT_CompleteReason = model.TT_CompleteReason, TT_ServerClient = model.TT_ServerClient }); JavaScriptSerializer jss = new JavaScriptSerializer(); string strJson = jss.Serialize(list); strJson = strJson.Replace("[", "").Replace("]", ""); context.Response.Write(strJson); }
private void AddTaskListTotal(HttpContext context) { //throw new NotImplementedException(); BLL.TaskTotal bll = new BLL.TaskTotal(); Model.TaskTotal model = new Model.TaskTotal(); model.TT_Release = context.Request["TT_Release"].ToString(); model.TT_CU = context.Request["TT_CU"].ToString(); model.TT_BuildType = context.Request["TT_BuildType"].ToString(); model.TT_BuildNum = context.Request["TT_BuildNum"].ToString(); model.TT_TaskType = context.Request["TT_TaskType"].ToString(); model.TT_CaseTotalNum = context.Request["TT_CaseTotalNum"].ToString(); model.TT_CaseRealRunNum = "0"; model.TT_DateStart = Convert.ToDateTime(context.Request["TT_DateStart"]).ToString("yyyy-MM-dd"); model.TT_DateEnd = Convert.ToDateTime(context.Request["TT_DateEnd"]).ToString("yyyy-MM-dd"); model.TT_TaskStyle = context.Request["TT_TaskStyle"].ToString(); model.TT_BugIssueNum = "999999,888888,777777"; model.TT_ReportLink = "http://TestLink.com"; model.TT_Comments = context.Request["TT_Comments"].ToString(); model.TT_CreateDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); model.TT_Title = context.Request["TT_Title"].ToString(); model.TT_TaskProgress = "0"; model.TT_TaskStatus = "Pending"; model.TT_HaveScenario = "No"; model.TT_ServerClient = context.Request["TT_ServerClient"].ToString(); int iRows = bll.Add(model); if (iRows > 0) { context.Response.Write(iRows); } else { context.Response.Write("fail"); } }
public bool Update(Model.TaskTotal model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TaskTotal set "); strSql.Append("TT_Release=@TT_Release,"); strSql.Append("TT_CU=@TT_CU,"); strSql.Append("TT_BuildType=@TT_BuildType,"); strSql.Append("TT_BuildNum=@TT_BuildNum,"); strSql.Append("TT_TaskType=@TT_TaskType,"); strSql.Append("TT_CaseTotalNum=@TT_CaseTotalNum,"); strSql.Append("TT_CaseRealRunNum=@TT_CaseRealRunNum,"); strSql.Append("TT_DateStart=@TT_DateStart,"); strSql.Append("TT_DateEnd=@TT_DateEnd,"); strSql.Append("TT_TaskStyle=@TT_TaskStyle,"); strSql.Append("TT_BugIssueNum=@TT_BugIssueNum,"); strSql.Append("TT_ReportLink=@TT_ReportLink,"); strSql.Append("TT_Comments=@TT_Comments,"); strSql.Append("TT_ServerClient=@TT_ServerClient"); strSql.Append(" where TT_ID=@TT_ID"); SqlParameter[] parameters = { new SqlParameter("@TT_Release", SqlDbType.VarChar, 10), new SqlParameter("@TT_CU", SqlDbType.VarChar, 10), new SqlParameter("@TT_BuildType", SqlDbType.VarChar, 20), new SqlParameter("@TT_BuildNum", SqlDbType.VarChar, 20), new SqlParameter("@TT_TaskType", SqlDbType.VarChar, 20), new SqlParameter("@TT_CaseTotalNum", SqlDbType.VarChar, 10), new SqlParameter("@TT_CaseRealRunNum", SqlDbType.VarChar, 10), new SqlParameter("@TT_DateStart", SqlDbType.VarChar, 10), new SqlParameter("@TT_DateEnd", SqlDbType.VarChar, 10), new SqlParameter("@TT_TaskStyle", SqlDbType.VarChar, 10), new SqlParameter("@TT_BugIssueNum", SqlDbType.VarChar), new SqlParameter("@TT_ReportLink", SqlDbType.VarChar), new SqlParameter("@TT_Comments", SqlDbType.VarChar), new SqlParameter("@TT_ServerClient", SqlDbType.VarChar, 20), new SqlParameter("@TT_ID", SqlDbType.Int, 4) }; parameters[0].Value = model.TT_Release; parameters[1].Value = model.TT_CU; parameters[2].Value = model.TT_BuildType; parameters[3].Value = model.TT_BuildNum; parameters[4].Value = model.TT_TaskType; parameters[5].Value = model.TT_CaseTotalNum; parameters[6].Value = model.TT_CaseRealRunNum; parameters[7].Value = model.TT_DateStart; parameters[8].Value = model.TT_DateEnd; parameters[9].Value = model.TT_TaskStyle; parameters[10].Value = model.TT_BugIssueNum; parameters[11].Value = model.TT_ReportLink; parameters[12].Value = model.TT_Comments; parameters[13].Value = model.TT_ServerClient; parameters[14].Value = model.TT_ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public int Add(Model.TaskTotal model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TaskTotal("); strSql.Append("TT_Release,TT_CU,TT_BuildType,TT_BuildNum,TT_TaskType,TT_CaseTotalNum,TT_CaseRealRunNum,TT_DateStart,TT_DateEnd,TT_TaskStyle,TT_BugIssueNum,TT_ReportLink,TT_Comments,TT_CreateDate,TT_Title,TT_TaskProgress,TT_TaskStatus,TT_HaveScenario,TT_ServerClient)"); strSql.Append(" values ("); strSql.Append("@TT_Release,@TT_CU,@TT_BuildType,@TT_BuildNum,@TT_TaskType,@TT_CaseTotalNum,@TT_CaseRealRunNum,@TT_DateStart,@TT_DateEnd,@TT_TaskStyle,@TT_BugIssueNum,@TT_ReportLink,@TT_Comments,@TT_CreateDate,@TT_Title,@TT_TaskProgress,@TT_TaskStatus,@TT_HaveScenario,@TT_ServerClient)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@TT_Release", SqlDbType.VarChar, 10), new SqlParameter("@TT_CU", SqlDbType.VarChar, 10), new SqlParameter("@TT_BuildType", SqlDbType.VarChar, 20), new SqlParameter("@TT_BuildNum", SqlDbType.VarChar, 20), new SqlParameter("@TT_TaskType", SqlDbType.VarChar, 20), new SqlParameter("@TT_CaseTotalNum", SqlDbType.VarChar, 10), new SqlParameter("@TT_CaseRealRunNum", SqlDbType.VarChar, 10), new SqlParameter("@TT_DateStart", SqlDbType.VarChar, 10), new SqlParameter("@TT_DateEnd", SqlDbType.VarChar, 10), new SqlParameter("@TT_TaskStyle", SqlDbType.VarChar, 10), new SqlParameter("@TT_BugIssueNum", SqlDbType.VarChar), new SqlParameter("@TT_ReportLink", SqlDbType.VarChar), new SqlParameter("@TT_Comments", SqlDbType.VarChar), new SqlParameter("@TT_CreateDate", SqlDbType.VarChar, 20), new SqlParameter("@TT_Title", SqlDbType.VarChar, 300), new SqlParameter("@TT_TaskProgress", SqlDbType.VarChar, 10), new SqlParameter("@TT_TaskStatus", SqlDbType.VarChar, 10), new SqlParameter("@TT_HaveScenario", SqlDbType.VarChar, 5), new SqlParameter("@TT_ServerClient", SqlDbType.VarChar, 20) }; parameters[0].Value = model.TT_Release; parameters[1].Value = model.TT_CU; parameters[2].Value = model.TT_BuildType; parameters[3].Value = model.TT_BuildNum; parameters[4].Value = model.TT_TaskType; parameters[5].Value = model.TT_CaseTotalNum; parameters[6].Value = model.TT_CaseRealRunNum; parameters[7].Value = model.TT_DateStart; parameters[8].Value = model.TT_DateEnd; parameters[9].Value = model.TT_TaskStyle; parameters[10].Value = model.TT_BugIssueNum; parameters[11].Value = model.TT_ReportLink; parameters[12].Value = model.TT_Comments; parameters[13].Value = model.TT_CreateDate; parameters[14].Value = model.TT_Title; parameters[15].Value = model.TT_TaskProgress; parameters[16].Value = model.TT_TaskStatus; parameters[17].Value = model.TT_HaveScenario; parameters[18].Value = model.TT_ServerClient; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { //return Convert.ToInt32(obj); int TT_ID = Convert.ToInt32(obj); bool resAddDailyTask = AddTaskDaily(TT_ID, model.TT_DateStart, model.TT_DateEnd, model.TT_CaseTotalNum); if (resAddDailyTask) { return(Convert.ToInt32(TT_ID)); } else { return(0); } } }
public bool Update(Model.TaskTotal model) { return(dal.Update(model)); }
public int Add(Model.TaskTotal model) { return(dal.Add(model)); }