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);
}
