C# (CSharp) CARDAL DbHelp Examples

Example #1

File: CarListServer.cs Project: zhiji6/Winform_ERPfor

        public static DataTable GetListInfo(int Top)
        {
            #region 显示热门车型
            string sql = "SELECT TOP " + Top + "* FROM [CarBase].[dbo].[CAR_INFO] ORDER BY CREATE_TIME DESC";
            return(DbHelp.GetDataTable(sql));

            #endregion
        }

Example #2

File: CarListServer.cs Project: zhiji6/Winform_ERPfor

        public static SqlDataReader CheckLogin(string ID, string PSW)
        {
            #region  后台管理Check 用户登录密码，用户名
            string sql = "SELECT * FROM [CarBase].[dbo].[USER_INFO]  WHERE USER_ID='" + ID + "'AND USER_PSW='" + PSW + "'";

            return(DbHelp.GetReader(sql));

            #endregion
        }