public static void DeleteFavourite(string fID) { string sql = @"DELETE FROM MOBILEAPP_FAVOURITE WHERE ID=:fID "; DataSet ds = OracleDataTool.ExecuteDataset(ConnectStringOracle.GetTableConnection(), sql); OracleParameter[] para = new OracleParameter[1]; para[0] = new OracleParameter("fID", fID); OracleDataTool.ExecuteNonQuery(ConnectStringOracle.GetTableConnection(), sql, para); }
public static void DeleteLogEvent(string logID) { string sql = @"DELETE FROM MOBILEAPP_LOGEVENT WHERE LOGID=:logID "; DataSet ds = OracleDataTool.ExecuteDataset(ConnectStringOracle.GetTableConnection(), sql); OracleParameter[] para = new OracleParameter[1]; para[0] = new OracleParameter("logID", logID); OracleDataTool.ExecuteNonQuery(ConnectStringOracle.GetTableConnection(), sql, para); }
public static void DeleteVisitMsg(string visitID) { string sql = @"DELETE FROM MOBILEAPP_VISIT WHERE VISITID=:visitID "; DataSet ds = OracleDataTool.ExecuteDataset(ConnectStringOracle.GetTableConnection(), sql); OracleParameter[] para = new OracleParameter[1]; para[0] = new OracleParameter("visitID", visitID); OracleDataTool.ExecuteNonQuery(ConnectStringOracle.GetTableConnection(), sql, para); }
public static void UpdateLogEvent(string logID, string eventType, string message, string errorStackTrace, DateTime eventDate) { string sql = @"UPDATE MOBILEAPP_LOGEVENT SET EventType=:eventType, Message=:message, ErrorStackTrace=:errorStackTrace, EventDate=to_date(:eventDate,'yyyy-MM-DD hh24:mi:ss') WHERE LOGID=:logID"; OracleParameter[] para = new OracleParameter[5]; para[0] = new OracleParameter("logID", logID); para[1] = new OracleParameter("eventType", eventType); para[2] = new OracleParameter("message", message); para[3] = new OracleParameter("errorStackTrace", errorStackTrace); para[4] = new OracleParameter("eventDate", eventDate.ToString()); OracleDataTool.ExecuteNonQuery(ConnectStringOracle.GetTableConnection(), sql, para); }
public static void InsertLogEvent(string eventType, string message, string errorStackTrace, DateTime eventDate) { string sql = @"INSERT INTO MOBILEAPP_LOGEVENT (LOGID, EventType, Message, ErrorStackTrace, EventDate ) VALUES ( SEQ_MOBILEAPP.Nextval, :eventType ,:message ,:errorStackTrace ,to_date(:eventDate,'yyyy-MM-DD hh24:mi:ss') )"; OracleParameter[] para = new OracleParameter[4]; para[0] = new OracleParameter("eventType", eventType); para[1] = new OracleParameter("message", message); para[2] = new OracleParameter("errorStackTrace", errorStackTrace); para[3] = new OracleParameter("eventDate", eventDate.ToString()); OracleDataTool.ExecuteNonQuery(ConnectStringOracle.GetTableConnection(), sql, para); }
public static void UpdateVisitMsg(string visitID, string ip, DateTime visitDate, string browser, string mobileUserAgent, string userName) { string sql = @"UPDATE MOBILEAPP_VISIT SET IP=:ip ,VISIT_DATE=to_date(:visitDate,'yyyy-MM-DD hh24:mi:ss') ,BROWSER=:browser, MOBILE_USER_AGENT=:mobileUserAgent, USERNAME=:userName WHERE VISITID=:visitID"; OracleParameter[] para = new OracleParameter[6]; para[0] = new OracleParameter("visitID", visitID); para[1] = new OracleParameter("ip", ip); para[2] = new OracleParameter("visitDate", visitDate.ToString()); para[3] = new OracleParameter("browser", browser); para[4] = new OracleParameter("mobileUserAgent", mobileUserAgent); para[5] = new OracleParameter("userName", userName); OracleDataTool.ExecuteNonQuery(ConnectStringOracle.GetTableConnection(), sql, para); }
public static void InsertVisitMsg(string visitID, string ip, DateTime visitDate, string browser, string mobileUserAgent, string userName) { string sql = @"INSERT INTO MOBILEAPP_VISIT ( VISITID ,IP, VISIT_DATE, BROWSER ,MOBILE_USER_AGENT ,USERNAME) VALUES ( SEQ_MOBILEAPP.Nextval, :ip ,to_date(:visitDate,'yyyy-MM-DD hh24:mi:ss') ,:browser ,:mobileUserAgent ,:userName)"; OracleParameter[] para = new OracleParameter[5]; para[0] = new OracleParameter("ip", ip); para[1] = new OracleParameter("visitDate", visitDate.ToString()); para[2] = new OracleParameter("browser", browser); para[3] = new OracleParameter("mobileUserAgent", mobileUserAgent); para[4] = new OracleParameter("userName", userName); OracleDataTool.ExecuteNonQuery(ConnectStringOracle.GetTableConnection(), sql, para); }
public static DataTable GetVisitMsgs() { string sql = @"SELECT VISITID ,IP, VISIT_DATE, BROWSER ,MOBILE_USER_AGENT ,USERNAME FROM MOBILEAPP_VISIT "; DataSet ds = OracleDataTool.ExecuteDataset(ConnectStringOracle.GetTableConnection(), sql); if (ds.Tables[0].Rows.Count == 0) { return(null); } else { return(ds.Tables[0]); } }
public static DataTable GetLogEvents() { string sql = @"SELECT LOGID, EventType, Message, ErrorStackTrace, EventDate FROM MOBILEAPP_LOGEVENT "; DataSet ds = OracleDataTool.ExecuteDataset(ConnectStringOracle.GetTableConnection(), sql); if (ds.Tables[0].Rows.Count == 0) { return(null); } else { return(ds.Tables[0]); } }
public static DataTable GetNotices() { string sql = @"SELECT NoticeID, NoticeTitle, CreateTime, NoticeContent, IsActive, Remark FROM MobileApp_Notice ORDER BY CreateTime DESC"; DataSet ds = OracleDataTool.ExecuteDataset(ConnectStringOracle.GetTableConnection(), sql); if (ds.Tables[0].Rows.Count == 0) { return(null); } else { return(ds.Tables[0]); } }
public static DataTable GetFavourites() { string sql = @"SELECT ID, URL, USERNAME, CREATETIME, STATUS, UPDATETIME ,OBJECTID , OBJECTCONTENT ,OBJECTTYPE ,ISACTIVE ,REMARK FROM MOBILEAPP_FAVOURITE ORDER BY STATUS DESC, UPDATETIME DESC, CREATETIME DESC"; DataSet ds = OracleDataTool.ExecuteDataset(ConnectStringOracle.GetTableConnection(), sql); if (ds.Tables[0].Rows.Count == 0) { return(null); } else { return(ds.Tables[0]); } }
public static DataRow GetLogEventByID(string logID) { string sql = @"SELECT LOGID, EventType, Message, ErrorStackTrace, EventDate FROM MOBILEAPP_LOGEVENT WHERE (LOGID = :logID) "; OracleParameter[] para = new OracleParameter[1]; para[0] = new OracleParameter("logID", logID); DataSet ds = OracleDataTool.ExecuteDataset(ConnectStringOracle.GetTableConnection(), sql, para); if (ds.Tables[0].Rows.Count == 0) { return(null); } else { return(ds.Tables[0].Rows[0]); } }
public static DataRow GetVisitMsgByID(string logID) { string sql = @"SELECT VISITID ,IP, VISIT_DATE, BROWSER ,MOBILE_USER_AGENT ,USERNAME FROM MOBILEAPP_VISIT WHERE (LOGID = :logID) "; OracleParameter[] para = new OracleParameter[1]; para[0] = new OracleParameter("logID", logID); DataSet ds = OracleDataTool.ExecuteDataset(ConnectStringOracle.GetTableConnection(), sql, para); if (ds.Tables[0].Rows.Count == 0) { return(null); } else { return(ds.Tables[0].Rows[0]); } }
public static DataRow GetFavouriteByID(string fID) { string sql = @"SELECT ID, URL, USERNAME, CREATETIME, STATUS, UPDATETIME , OBJECTID , OBJECTCONTENT,OBJECTTYPE, ISACTIVE ,REMARK FROM MOBILEAPP_FAVOURITE WHERE (ID = :fID) "; OracleParameter[] para = new OracleParameter[1]; para[0] = new OracleParameter("fID", fID); DataSet ds = OracleDataTool.ExecuteDataset(ConnectStringOracle.GetTableConnection(), sql, para); if (ds.Tables[0].Rows.Count == 0) { return(null); } else { return(ds.Tables[0].Rows[0]); } }
public static DataRow GetNoticeByID(string nID) { string sql = @"SELECT NoticeID, NoticeTitle, CreateTime, NoticeContent, IsActive, Remark FROM MobileApp_Notice WHERE (NoticeID = :nID)"; OracleParameter[] para = new OracleParameter[1]; para[0] = new OracleParameter("nID", nID); DataSet ds = OracleDataTool.ExecuteDataset(ConnectStringOracle.GetTableConnection(), sql, para); if (ds.Tables[0].Rows.Count == 0) { return(null); } else { return(ds.Tables[0].Rows[0]); } }
public static void InsertFavourite(string fID, string url, string userName, DateTime createTime, int status, DateTime updateTime, string objectID, string objectContent, string objectType, int isActive, string remark) { string sql = @"INSERT INTO MOBILEAPP_FAVOURITE (ID, URL, USERNAME, CREATETIME, STATUS, UPDATETIME , OBJECTID, OBJECTCONTENT,OBJECTTYPE , ISACTIVE ,REMARK ) VALUES ( SEQ_MOBILEAPP.Nextval, :url ,:userName ,to_date(:createTime,'yyyy-MM-DD hh24:mi:ss') ,:status ,to_date(:updateTime,'yyyy-MM-DD hh24:mi:ss') ,:objectID ,:objectContent , :objectType, :isActive ,:remark )"; OracleParameter[] para = new OracleParameter[10]; para[0] = new OracleParameter("url", url); para[1] = new OracleParameter("userName", userName); para[2] = new OracleParameter("createTime", createTime.ToString()); para[3] = new OracleParameter("status", status); para[4] = new OracleParameter("updateTime", updateTime.ToString()); para[5] = new OracleParameter("objectID", objectID); para[6] = new OracleParameter("objectContent", objectContent); para[7] = new OracleParameter("objectType", objectType); para[8] = new OracleParameter("isActive", isActive); para[9] = new OracleParameter("remark", remark); OracleDataTool.ExecuteNonQuery(ConnectStringOracle.GetTableConnection(), sql, para); }
public static void UpdateFavourite(string fID, string url, string userName, DateTime createTime, int status, DateTime updateTime, string objectID, string objectContent, string objectType, int isActive, string remark) { string sql = @"UPDATE MOBILEAPP_FAVOURITE SET URL=:url, USERNAME=:userName, CREATETIME=to_date(:createTime ,'yyyy-MM-DD hh24:mi:ss'), STATUS=:status, UPDATETIME=to_date(:updateTime,'yyyy-MM-DD hh24:mi:ss'), OBJECTID=:objectID, OBJECTCONTENT=:objectContent, OBJECTTYPE=:objectType, ISACTIVE=:isActive, REMARK=:remark WHERE ID=:fID"; OracleParameter[] para = new OracleParameter[11]; para[0] = new OracleParameter("fID", fID); para[1] = new OracleParameter("url", url); para[2] = new OracleParameter("userName", userName); para[3] = new OracleParameter("createTime", createTime.ToString()); para[4] = new OracleParameter("status", status); para[5] = new OracleParameter("updateTime", updateTime.ToString()); para[6] = new OracleParameter("objectID", objectID); para[7] = new OracleParameter("objectContent", objectContent); para[8] = new OracleParameter("objectType", objectType); para[9] = new OracleParameter("isActive", isActive); para[10] = new OracleParameter("remark", remark); OracleDataTool.ExecuteNonQuery(ConnectStringOracle.GetTableConnection(), sql, para); }