static public int GetNews(GETNEWS getnews, out NEWS[] result) { result = null; if (getnews.ext.nNeedLine == 0) { getnews.ext.nNeedLine = 10; } DataTable dt = CDB.GetSQLData("select top " + getnews.ext.nNeedLine + " * from tblNews where dwDate >= " + getnews.dwStartDate + " and dwDate <= " + getnews.dwEndDate + " and dwClsID=" + getnews.dwClsID); if (dt == null) { return(1); } result = new NEWS[dt.Rows.Count]; for (int i = 0; i < dt.Rows.Count; i++) { result[i] = new NEWS(); result[i].dwNewsID = (int)dt.Rows[i]["dwNewsID"]; result[i].dwDate = (int)dt.Rows[i]["dwDate"]; result[i].dwTime = (int)dt.Rows[i]["dwTime"]; result[i].dwClsID = (int)dt.Rows[i]["dwClsID"]; result[i].dwType = (int)dt.Rows[i]["dwType"]; result[i].szTitle = (string)dt.Rows[i]["szTitle"]; result[i].szContent = (string)dt.Rows[i]["szContent"]; } return(0); }
static public int UserCheck(CHECKUSER check, out USER result) { result = null; DataTable dt = CDB.GetSQLData("select top 1 * from tblUser where szLogonName = '" + check.szLogonName + "'"); if (dt == null) { return(1); } if (dt.Rows.Count == 0) { return(1); } if ((string)dt.Rows[0]["szPassword"] != check.szPassword) { return(1); } result = new USER(); result.dwUserID = (int)dt.Rows[0]["dwUserID"]; result.szLogonName = (string)dt.Rows[0]["szLogonName"]; result.szTrueName = (string)dt.Rows[0]["szTrueName"]; result.dwType = (int)dt.Rows[0]["dwType"]; return(0); }
static public int DelNews(int dwNewsID) { DataTable dt = CDB.GetSQLData("delete from tblNews where dwNewsID=" + dwNewsID); if (dt == null) { return(1); } else { return(0); } }
//------------------------- static public int GetModules(out MODULES[] result) { result = null; DataTable dt = CDB.GetSQLData("select * from tblModule"); if (dt == null) { return(1); } result = new MODULES[dt.Rows.Count]; for (int i = 0; i < dt.Rows.Count; i++) { result[i] = new MODULES(); result[i].dwModuleID = (int)dt.Rows[i]["dwModuleID"]; result[i].szModuleName = (string)dt.Rows[i]["szModuleName"]; } return(0); }
static public int GetClasses(int dwModuleID, out CLASS[] result) { result = null; DataTable dt = CDB.GetSQLData("select * from tblClass where dwModuleID=" + dwModuleID); if (dt == null) { return(1); } result = new CLASS[dt.Rows.Count]; for (int i = 0; i < dt.Rows.Count; i++) { result[i] = new CLASS(); result[i].dwClsID = (int)dt.Rows[i]["dwClsID"]; result[i].dwModuleID = (int)dt.Rows[i]["dwModuleID"]; result[i].szClassName = (string)dt.Rows[i]["szClsName"]; } return(0); }
static public NEWS GetNewsDetail(int dwNewsID) { NEWS result = null; DataTable dt = CDB.GetSQLData("select top 1 * from tblNews where dwNewsID=" + dwNewsID); if (dt == null || dt.Rows.Count == 0) { return(result); } result = new NEWS(); result.dwNewsID = (int)dt.Rows[0]["dwNewsID"]; result.dwDate = (int)dt.Rows[0]["dwDate"]; result.dwTime = (int)dt.Rows[0]["dwTime"]; result.dwClsID = (int)dt.Rows[0]["dwClsID"]; result.dwType = (int)dt.Rows[0]["dwType"]; result.szTitle = (string)dt.Rows[0]["szTitle"]; result.szContent = (string)dt.Rows[0]["szContent"]; return(result); }
static public int GetClassDetail(int dwClsID, out CLASS result) { result = null; DataTable dt = CDB.GetSQLData("select * from tblClass where dwClsID=" + dwClsID); if (dt == null) { return(1); } result = new CLASS(); if (dt.Rows.Count > 0) { result.dwClsID = (int)dt.Rows[0]["dwClsID"]; result.dwModuleID = (int)dt.Rows[0]["dwModuleID"]; result.szClassName = (string)dt.Rows[0]["szClsName"]; return(0); } return(1); }
static public int GetUser(GETUSER getUser, out USER[] result) { result = null; DataTable dt = CDB.GetSQLData("select top " + getUser.ext.nNeedLine + " * from tblUser"); if (dt == null) { return(1); } result = new USER[dt.Rows.Count]; for (int i = 0; i < dt.Rows.Count; i++) { result[i] = new USER(); result[i].dwUserID = (int)dt.Rows[i]["dwUserID"]; result[i].szLogonName = (string)dt.Rows[i]["szLogonName"]; result[i].szTrueName = (string)dt.Rows[i]["szTrueName"]; result[i].dwType = (int)dt.Rows[i]["dwType"]; } return(0); }
static public int NewNews(NEWS newnews) { DataTable dt = null; if (newnews.dwNewsID == 0) { dt = CDB.GetSQLData("insert into tblNews (dwClsID,dwDate,dwTime,dwType,szTitle,szContent) values (" + newnews.dwClsID + "," + newnews.dwDate + "," + newnews.dwTime + "," + newnews.dwType + ",'" + newnews.szTitle + "','" + newnews.szContent + "')"); } else { dt = CDB.GetSQLData("update tblNews set szTitle='" + newnews.szTitle + "' ,szContent='" + newnews.szContent + "' where dwNewsID =" + newnews.dwNewsID); } if (dt == null) { return(1); } else { return(0); } }
static public int NewClass(CLASS newcls) { DataTable dt = null; if (newcls.dwClsID != 0) { dt = CDB.GetSQLData("update tblClass set dwModuleID=" + newcls.dwModuleID + " ,szClsName='" + newcls.szClassName + "' where dwClsID=" + newcls.dwClsID); } else { dt = CDB.GetSQLData("insert into tblClass (dwModuleID,szClsName) values (" + newcls.dwModuleID + ",'" + newcls.szClassName + "')"); } if (dt == null) { return(1); } else { return(0); } }