public void QryCategory001(int CategoryID = -1, string CategoryName = "", string CategoryDesc = "", string StatusNO = "", int ParentID = -1 , int PAGE_INDEX = -1, int PAGE_SIZE = -1, string ORDER_BY = "") { try { string sParam = "<root><Category>"; sParam += "<CategoryID>" + CategoryID + "</CategoryID>"; sParam += "<CategoryName>" + CategoryName + "</CategoryName>"; sParam += "<CategoryDesc>" + CategoryDesc + "</CategoryDesc>"; sParam += "<StatusNO>" + StatusNO + "</StatusNO>"; sParam += "<ParentID>" + ParentID + "</ParentID>"; sParam += "</Category>"; sParam += "<PAGE_INFO>"; sParam += "<PAGE_INDEX>" + PAGE_INDEX + "</PAGE_INDEX>"; sParam += "<PAGE_SIZE>" + PAGE_SIZE + "</PAGE_SIZE>"; sParam += "<ORDER_BY>" + ORDER_BY + "</ORDER_BY>"; sParam += "</PAGE_INFO>"; sParam += "</root>"; DataSet oDS = client.ctEnumerateData("ManagerSO.QryCategory001", sParam); string sData = CmnSrvLib.Dtb2Json(oDS.Tables["QryCategory001"]).ToString(); int TOTAL_COUNT = cmn.cap_int(oDS.Tables["TABLE_ROWS"].Rows[0]["TOTAL_COUNT"]); res = "{\"status\" : \"OK\",\"msg\": \"OK\",\"table_rows\": \"" + TOTAL_COUNT + "\",\"qrydata\":" + sData + "}"; } catch (Exception e1) { userModel.MESSAGE = e1.Message; string error_message = Microsoft.JScript.GlobalObject.escape(e1.Message); res = "{\"status\" : \"error\",\"msg\": \"error\",\"error_desc\":\"" + error_message + "\"}"; } Response.Write(res); }
public void QryUserInfo001(int UserID = -1, string UserNO = "", string UserName = "", string MobilePhone = "", string PassWD = "", string Email = "", string IconSrc = "", string LastLoginTime = "", string LastLoginIP = "", int LoginCount = -1, string RoleCollect = "", string TypeNO = "", string StatusNO = "" , int PAGE_INDEX = -1, int PAGE_SIZE = -1, string ORDER_BY = "") { try { string sParam = "<root><UserInfo>"; sParam += "<UserID>" + UserID + "</UserID>"; sParam += "<UserNO>" + UserNO + "</UserNO>"; sParam += "<UserName>" + UserName + "</UserName>"; sParam += "<MobilePhone>" + MobilePhone + "</MobilePhone>"; sParam += "<PassWD>" + PassWD + "</PassWD>"; sParam += "<Email>" + Email + "</Email>"; sParam += "<IconSrc>" + IconSrc + "</IconSrc>"; sParam += "<LastLoginTime>" + LastLoginTime + "</LastLoginTime>"; sParam += "<LastLoginIP>" + LastLoginIP + "</LastLoginIP>"; sParam += "<LoginCount>" + LoginCount + "</LoginCount>"; sParam += "<RoleCollect>" + RoleCollect + "</RoleCollect>"; sParam += "<TypeNO>" + TypeNO + "</TypeNO>"; sParam += "<StatusNO>" + StatusNO + "</StatusNO>"; sParam += "</UserInfo>"; sParam += "<PAGE_INFO>"; sParam += "<PAGE_INDEX>" + PAGE_INDEX + "</PAGE_INDEX>"; sParam += "<PAGE_SIZE>" + PAGE_SIZE + "</PAGE_SIZE>"; sParam += "<ORDER_BY>" + ORDER_BY + "</ORDER_BY>"; sParam += "</PAGE_INFO>"; sParam += "</root>"; DataSet oDS = client.ctEnumerateData("ManagerSO.QryUserInfo001", sParam); string sData = CmnSrvLib.Dtb2Json(oDS.Tables["QryUserInfo001"]).ToString(); int TOTAL_COUNT = cmn.cap_int(oDS.Tables["TABLE_ROWS"].Rows[0]["TOTAL_COUNT"]); res = "{\"status\" : \"OK\",\"msg\": \"OK\",\"table_rows\": \"" + TOTAL_COUNT + "\",\"qrydata\":" + sData + "}"; } catch (Exception e1) { userModel.MESSAGE = e1.Message; string error_message = Microsoft.JScript.GlobalObject.escape(e1.Message); res = "{\"status\" : \"error\",\"msg\": \"error\",\"error_desc\":\"" + error_message + "\"}"; } Response.Write(res); }