C# SqlCeDataManager.GetTable方法代碼示例

本文整理匯總了C#中WebSpider.Data.DatabaseManager.SqlCeDataManager.GetTable方法的典型用法代碼示例。如果您正苦於以下問題：C# SqlCeDataManager.GetTable方法的具體用法？C# SqlCeDataManager.GetTable怎麽用？C# SqlCeDataManager.GetTable使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類WebSpider.Data.DatabaseManager.SqlCeDataManager的用法示例。

在下文中一共展示了SqlCeDataManager.GetTable方法的15個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的C#代碼示例。

示例1: ProductCount

 //public List<ADIInventoryExport> FillByProduct(String PART_NUM)
 //{
 //    String Query = "SELECT * FROM ADIInventoryExport WHERE PART_NUM = @PART_NUM";
 //    SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
 //    oDm.AddVarcharPara("PART_NUM", 4000, PART_NUM);
 //    return DataParser.ToList<ADIInventoryExport>(oDm.GetTable());
 //}
 public int ProductCount(String PART_NUM)
 {
     String Query = "SELECT COUNT(1) FROM ADIInventoryExport WITH (NOLOCK) WHERE PART_NUM = @PART_NUM";
     SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
     oDm.AddVarcharPara("PART_NUM", 4000, PART_NUM);
     return (int) oDm.GetTable().Rows[0][0];
 }

開發者ID:riskypathak，項目名稱:WebSpider，代碼行數:14，代碼來源:ADIInventoryExportManager.cs

示例2: GetDataById

 public List<TaskDetail> GetDataById(Int64 TaskID)
 {
     String Query = "SELECT * FROM TaskDetail WHERE TaskID = @TaskID";
     SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true);
     oDm.AddIntegerBigPara("TaskID", TaskID);
     return DataParser.ToList<TaskDetail>(oDm.GetTable());
 }

開發者ID:riskypathak，項目名稱:WebSpider，代碼行數:7，代碼來源:TaskDetailManager.cs

示例3: GetDataTableByPartNumber

 public DataTable GetDataTableByPartNumber(String PART_NUM)
 {
     String Query = "SELECT * FROM ADIChild WITH (NOLOCK) WHERE PART_NUM = @PART_NUM";
     SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
     oDm.AddVarcharPara("PART_NUM", 4000, PART_NUM);
     return oDm.GetTable();
 }

開發者ID:riskypathak，項目名稱:WebSpider，代碼行數:7，代碼來源:ProductSpecificationManager.cs

示例4: GetTop

 public FinalExport GetTop()
 {
     String Query = "SELECT TOP 1 * FROM FinalExport ORDER BY CreatedDate";
     SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true);
     List<FinalExport> finalExports = DataParser.ToList<FinalExport>(oDm.GetTable());
     return finalExports.Count == 0 ? null : finalExports[0];
 }

開發者ID:riskypathak，項目名稱:WebSpider，代碼行數:7，代碼來源:FinalExportManager.cs

示例5: GetBySite

 public List<FinalExport> GetBySite(String ExportSite)
 {
     String Query = "SELECT * FROM FinalExport WHERE ExportSite = @ExportSite ORDER BY CreatedDate";
     SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true);
     oDm.AddVarcharPara("ExportSite", 4000, ExportSite);
     return DataParser.ToList<FinalExport>(oDm.GetTable());
 }

開發者ID:riskypathak，項目名稱:WebSpider，代碼行數:7，代碼來源:FinalExportManager.cs

示例6: GetData

 public List<AdiProduct> GetData()
 {
     String Query = "SELECT * FROM ADIProduct1 WITH (NOLOCK)";
     SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
     oDm.ConnectionString = this.ConnectionString;
     return DataParser.ToList<AdiProduct>(oDm.GetTable());
 }

開發者ID:riskypathak，項目名稱:WebSpider，代碼行數:7，代碼來源:ADIProductManager.cs

示例7: GetAllPriorityProducts

 public List<AdiProduct> GetAllPriorityProducts()
 {
     String Query = "SELECT * FROM ADIProduct1 WITH (NOLOCK) WHERE PriorityProduct = 1 AND LastUpdateDatetime <= DATEADD(d, -1, GETDATE())";
     SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
     oDm.ConnectionString = this.ConnectionString;
     return DataParser.ToList<AdiProduct>(oDm.GetTable());
 }

開發者ID:riskypathak，項目名稱:WebSpider，代碼行數:7，代碼來源:ADIProductManager.cs

示例8: GetDataByCatagoryID

 public List<ADICategoryExport> GetDataByCatagoryID(String Value)
 {
     String Query = "SELECT * FROM ADICategoryExport WITH (NOLOCK) WHERE Value = @Value";
     SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
     oDm.AddVarcharPara("Value", 255, Value);
     return DataParser.ToList<ADICategoryExport>(oDm.GetTable());
 }

開發者ID:riskypathak，項目名稱:WebSpider，代碼行數:7，代碼來源:ADICategoryExportManager.cs

示例9: GetCategoryByParent

 public List<AdiCategory> GetCategoryByParent(String ParentValue)
 {
     String Query = "SELECT * FROM ADICategory WITH (NOLOCK) WHERE ParentValue = @ParentValue";
     SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
     oDm.AddVarcharPara("ParentValue", 255, ParentValue);
     return DataParser.ToList<AdiCategory>(oDm.GetTable());
 }

開發者ID:riskypathak，項目名稱:WebSpider，代碼行數:7，代碼來源:ADICategoryManager.cs

示例10: GetDataByProduct

 public ADIInventoryExport GetDataByProduct(String PART_NUM)
 {
     String Query = "SELECT * FROM ADIInventoryExport WITH (NOLOCK) WHERE PART_NUM = @PART_NUM";
     SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
     oDm.AddVarcharPara("PART_NUM", 4000, PART_NUM);
     var list = DataParser.ToList<ADIInventoryExport>(oDm.GetTable());
     return list.Count == 1 ? list[0] : null;
 }

開發者ID:riskypathak，項目名稱:WebSpider，代碼行數:8，代碼來源:ADIInventoryExportManager.cs

示例11: GetTopBySite

 public FinalExport GetTopBySite(String ExportSite)
 {
     String Query = "SELECT TOP 1 * FROM FinalExport WHERE ExportSite = @ExportSite ORDER BY CreatedDate";
     SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true);
     oDm.AddVarcharPara("ExportSite", 4000, ExportSite);
     List<FinalExport> finalExports = DataParser.ToList<FinalExport>(oDm.GetTable());
     return finalExports.Count == 0 ? null : finalExports[0];
 }

開發者ID:riskypathak，項目名稱:WebSpider，代碼行數:8，代碼來源:FinalExportManager.cs

示例12: GetDataByPartNumber

        public List<ADIInventoryDetails> GetDataByPartNumber(String AdiNumber)
        {
            String Query = "SELECT * FROM ADIInventory WHERE AdiNumber = @AdiNumber";
            SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true);
            oDm.AddVarcharPara("AdiNumber", 4000, AdiNumber);

            return DataParser.ToList<ADIInventoryDetails>(oDm.GetTable());
        }

開發者ID:riskypathak，項目名稱:WebSpider，代碼行數:8，代碼來源:ADIInventoryDetailsManager.cs

示例13: GetDataBySite

 public List<TaskDetail> GetDataBySite(Int64 TaskHeaderID, String TaskSite, Int32 TaskStatus)
 {
     String Query = "SELECT * FROM TaskDetail WHERE TaskSite = @TaskSite AND TaskStatus = @TaskStatus";
     SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true);
     oDm.AddVarcharPara("TaskSite", 4000, TaskSite);
     oDm.AddIntegerPara("TaskStatus", TaskStatus);
     return DataParser.ToList<TaskDetail>(oDm.GetTable());
 }

開發者ID:riskypathak，項目名稱:WebSpider，代碼行數:8，代碼來源:TaskDetailManager.cs

示例14: GetDataTableByPartNumber

        public DataTable GetDataTableByPartNumber(String AdiNumber)
        {
            String Query = "SELECT * FROM ADIInventory WHERE AdiNumber = @AdiNumber";
            SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true);
            oDm.AddVarcharPara("AdiNumber", 4000, AdiNumber);

            return oDm.GetTable();
        }

開發者ID:riskypathak，項目名稱:WebSpider，代碼行數:8，代碼來源:ADIInventoryDetailsManager.cs

示例15: GetValue

 public String GetValue(String PART_NUM, String PropertyName)
 {
     String Query = "SELECT ID, PART_NUM, PropertyName, PropertyValue FROM ADIChild WITH (NOLOCK) WHERE PART_NUM = @PART_NUM AND PropertyName = @PropertyName";
     SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
     oDm.AddVarcharPara("PART_NUM", 4000, PART_NUM);
     oDm.AddVarcharPara("PropertyName", 4000, PropertyName);
     List<ADIChild> childs = DataParser.ToList<ADIChild>(oDm.GetTable());
     if (childs.Count > 0)
         return childs[0].PropertyValue;
     else
         return null;
 }

開發者ID:riskypathak，項目名稱:WebSpider，代碼行數:12，代碼來源:ProductSpecificationManager.cs

注：本文中的WebSpider.Data.DatabaseManager.SqlCeDataManager.GetTable方法示例由純淨天空整理自Github/MSDocs等開源代碼及文檔管理平台，相關代碼片段篩選自各路編程大神貢獻的開源項目，源碼版權歸原作者所有，傳播和使用請參考對應項目的License；未經允許，請勿轉載。