當前位置: 首頁>>代碼示例>>C#>>正文

C# SqlCeDataManager.AddVarcharPara方法代碼示例

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


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

示例1: Insert

 public int Insert(String PART_NUM, String PropertyName, String PropertyValue)
 {
     String Query = "INSERT INTO [ADIChild] WITH (ROWLOCK) ([PART_NUM],[PropertyName],[PropertyValue])VALUES(@PART_NUM, @PropertyName, @PropertyValue)";
     SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
     oDm.AddVarcharPara("PART_NUM", 4000, PART_NUM);
     oDm.AddVarcharPara("PropertyName", 4000, PropertyName);
     oDm.AddVarcharPara("PropertyValue", 4000, PropertyValue);
     return oDm.RunActionQuery();
 }
開發者ID:riskypathak，項目名稱:WebSpider，代碼行數:9，代碼來源:ProductSpecificationManager.cs

示例2: Delete

 public int Delete(String ExportSite, String ExportType, String ExportValue, DateTime CreatedDate)
 {
     String Query = "DELETE FROM FinalExport WHERE "
         + "ExportSite = @ExportSite AND ExportType = @ExportType AND ExportValue = @ExportValue AND CreatedDate = @CreatedDate";
     SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true);
     oDm.AddVarcharPara("ExportSite", 4000, ExportSite);
     oDm.AddVarcharPara("ExportType", 4000, ExportType);
     oDm.AddVarcharPara("ExportValue", 4000, ExportValue);
     oDm.AddDateTimePara("CreatedDate", CreatedDate);
     return oDm.RunActionQuery();
 }
開發者ID:riskypathak，項目名稱:WebSpider，代碼行數:11，代碼來源:FinalExportManager.cs

示例3: Insert

 public int Insert(String ExportSite, String ExportType, String ExportValue)
 {
     String Query = "INSERT INTO FinalExport (ExportSite, ExportType, ExportValue, CreatedDate) "
         + "VALUES (@ExportSite, @ExportType, @ExportValue, @CreatedDate)";
     SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true);
     oDm.AddVarcharPara("ExportSite", 4000, ExportSite);
     oDm.AddVarcharPara("ExportType", 4000, ExportType);
     oDm.AddVarcharPara("ExportValue", 4000, ExportValue);
     oDm.AddDateTimePara("CreatedDate", DateTime.Now);
     return oDm.RunActionQuery();
 }
開發者ID:riskypathak，項目名稱:WebSpider，代碼行數:11，代碼來源:FinalExportManager.cs

示例4: 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

示例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: 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

示例7: DeleteByPart

 public int DeleteByPart(String AdiNumber)
 {
     String Query = "DELETE FROM ADIInventory WHERE AdiNumber = @AdiNumber";
     SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true);
     oDm.AddVarcharPara("AdiNumber", 4000, AdiNumber);
     return oDm.RunActionQuery();
 }
開發者ID:riskypathak，項目名稱:WebSpider，代碼行數:7，代碼來源:ADIInventoryDetailsManager.cs

示例8: 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

示例9: 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

示例10: 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

示例11: 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

示例12: 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

示例13: 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

示例14: 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

示例15: 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


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