public ActionResult updateDept(eDepartmentItem dept, string userId) { dept.UPDATE_UID = Session["UserId"].ToString(); dynamic showMessageString = string.Empty; DataTable dtResult = aDeptAccessVer2.updateDept(dept); string strResult = dtResult.Rows[0][0].ToString(); string strMes = dtResult.Rows[0][1].ToString(); showMessageString = new { param1 = 200, param2 = strResult, param3 = strMes }; try { Session["dept_tree_ver2"] = null; return(Json(showMessageString, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { var errorMsg = ex.Message.ToString(); showMessageString = new { param1 = 404, param2 = "error", param3 = "proccess error" }; return(Json(showMessageString, JsonRequestBehavior.AllowGet)); } }
public eDepartmentItem addNewDept(eDepartmentItem _dept) { eDepartmentItem result = new eDepartmentItem(); result.DEPTNAME = _dept.DEPTNAME; result.DEPTSHORTNAME = _dept.DEPTSHORTNAME; result.ISACTIVE = _dept.ISACTIVE; result.DEPTPARENT = _dept.DEPTPARENT; return(result); }
public static DataTable updateDept(eDepartmentItem dept) { DataTable dtResult = new DataTable(); OracleParameter[] _sqlParam = new OracleParameter[6]; _sqlParam[0] = new OracleParameter("PDEPTCODE", string.IsNullOrEmpty(dept.DEPTCODE) ? "" : dept.DEPTCODE); _sqlParam[1] = new OracleParameter("pDeptName", string.IsNullOrEmpty(dept.DEPTNAME) ? "" : dept.DEPTNAME); _sqlParam[2] = new OracleParameter("pDeptShortName", string.IsNullOrEmpty(dept.DEPTSHORTNAME) ? "" : dept.DEPTSHORTNAME); _sqlParam[3] = new OracleParameter("pIsActive", dept.ISACTIVE); _sqlParam[4] = new OracleParameter("pUserId", dept.UPDATE_UID); _sqlParam[5] = new OracleParameter("T_TABLE", OracleDbType.RefCursor) { Direction = ParameterDirection.Output }; dtResult = DBHelper.getDataTable_SP("PKHR_ORGANIZATION_VER2.SP_UPDATE_DEPARTMENT", _sqlParam); return(dtResult); }
public JsonResult getDeptDetail(string deptcode) { eDepartmentItem eResult = new eDepartmentItem(); DataTable dtResult = aDeptAccessVer2.getDeptDetail(deptcode); dynamic strResult = string.Empty; strResult = new { parent_name = dtResult.Rows[0]["parentname"].ToString(), deptcode = dtResult.Rows[0]["deptcode"].ToString(), deptName = dtResult.Rows[0]["deptname"].ToString(), deptParent = dtResult.Rows[0]["deptparent"].ToString(), deptShortName = dtResult.Rows[0]["deptshortname"].ToString(), isActive = dtResult.Rows[0]["isactive"].ToString() }; return(Json(strResult, JsonRequestBehavior.AllowGet)); }
public static List <eDepartmentItem> getDeptTreeVer2() { List <eDepartmentItem> lstResult = new List <eDepartmentItem>(); DataTable dtResult = new DataTable(); dtResult = aDeptAccessVer2.getAllDept(); foreach (DataRow dtr in dtResult.Rows) { eDepartmentItem item = new eDepartmentItem(); item.DEPTCODE = dtr["DEPTCODE"].ToString(); item.DEPTNAME = dtr["DEPTNAME"].ToString(); item.DEPTPARENT = dtr["DEPTPARENT"].ToString(); item.ISLEAF = dtr["ISLEAF"].ToString(); lstResult.Add(item); } return(lstResult); }