private void GetDDLScenarioRole(HttpContext context) { string FK_S_ID = context.Request["S_ID"]; BLL.ScenarioRole bll = new BLL.ScenarioRole(); DataSet ds = new DataSet(); if (!string.IsNullOrEmpty(FK_S_ID)) { ds = bll.GetList("SR_FK_S_ID=" + FK_S_ID); } else { ds = bll.GetList("SR_FK_S_ID=0"); } List <Model.ScenarioRoleForDDL> list = new List <Model.ScenarioRoleForDDL>(); foreach (DataRow dr in ds.Tables[0].Rows) { list.Add(new Model.ScenarioRoleForDDL() { SR_ID = Convert.ToInt32(dr["SR_ID"]), SR_RoleTitle = dr["SR_RoleTitle"].ToString() }); } JavaScriptSerializer jss = new JavaScriptSerializer(); string strJson = jss.Serialize(list); context.Response.Write(strJson); }
private void AddScenarioRole(HttpContext context) { //SR_RoleTitle: SR_RoleTitle, SR_CaseNum: SR_CaseNum, // SR_SR_AssignedUser: SR_SR_AssignedUser, SR_AssignedUserName: SR_AssignedUserName, // SR_FK_S_ID: SR_FK_S_ID, SR_FK_TT_ID: SR_FK_TT_ID Model.ScenarioRole model = new Model.ScenarioRole(); BLL.ScenarioRole bll = new BLL.ScenarioRole(); model.SR_FK_S_ID = Convert.ToInt32(context.Request["SR_FK_S_ID"]); model.SR_FK_TT_ID = Convert.ToInt32(context.Request["SR_FK_TT_ID"]); model.SR_RoleTitle = context.Request["SR_RoleTitle"]; model.SR_CaseNum = context.Request["SR_CaseNum"]; model.SR_AssignedUser = context.Request["SR_AssignedUser"]; model.SR_AssignedUserName = context.Request["SR_AssignedUserName"]; model.SR_CreateUser = context.Request["User_ID"]; model.SR_CreateDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); if (context.Request["TT_TaskStatus"] != "Pending") { model.SR_Status = "Pending"; } else { model.SR_Status = ""; } model.SR_IsDelete = "0"; if (bll.Add(model) > 0) { context.Response.Write("success"); } else { context.Response.Write("fail"); } }
private void DeleteScenarioRole(HttpContext context) { BLL.ScenarioRole bll = new BLL.ScenarioRole(); if (bll.Delete(Convert.ToInt32(context.Request["SR_ID"]), Convert.ToInt32(context.Request["SR_FK_S_ID"]))) { context.Response.Write("success"); } else { context.Response.Write("fail"); } }
private void UpdateScenarioRole(HttpContext context) { Model.ScenarioRole model = new Model.ScenarioRole(); BLL.ScenarioRole bll = new BLL.ScenarioRole(); model.SR_ID = Convert.ToInt32(context.Request["SR_ID"]); //model.SR_FK_S_ID = Convert.ToInt32(context.Request["SR_FK_S_ID"]); //model.SR_FK_TT_ID = Convert.ToInt32(context.Request["SR_FK_TT_ID"]); model.SR_RoleTitle = context.Request["SR_RoleTitle"]; model.SR_CaseNum = context.Request["SR_CaseNum"]; model.SR_AssignedUser = context.Request["SR_AssignedUser"]; model.SR_AssignedUserName = context.Request["SR_AssignedUserName"]; if (bll.Update(model)) { context.Response.Write("success"); } else { context.Response.Write("fail"); } }
private void AddScenarioRoleBatch(HttpContext context) { int SR_FK_S_ID = int.Parse(context.Request["SR_FK_S_ID"]); int SR_FK_TT_ID = int.Parse(context.Request["SR_FK_TT_ID"]); int User_ID = int.Parse(context.Request["User_ID"]); string JsonScenarioRole = context.Request["JsonSenarioRole"].ToString(); string strJson = string.Format("[{0}]", JsonScenarioRole); JavaScriptSerializer jss = new JavaScriptSerializer(); List <Model.ScenarioRoleForJson> list = jss.Deserialize <List <Model.ScenarioRoleForJson> >(strJson); BLL.ScenarioRole bll = new BLL.ScenarioRole(); bool AddRes = bll.AddBatch(list, SR_FK_S_ID, SR_FK_TT_ID, User_ID); if (AddRes) { context.Response.Write("success"); } else { context.Response.Write("fail"); } }