public static DataTable GetEmployeeInfoByWorkID(string sWorkID) { var db = DBO.CreateDatabaseKQXT(); using (var conn = db.CreateConnection()) { conn.Open(); string strUpdateSql = @"select OutID,Name,IDCardNo from Customer where OutID=@sOutID"; try { var dbCommandWrapper = db.GetSqlStringCommand(strUpdateSql); db.AddInParameter(dbCommandWrapper, "@sOutID", DbType.String, sWorkID); return(db.ExecuteDataSet(dbCommandWrapper).Tables[0]); } catch (Exception ex) { return(null); } } }