public List <TaskDetail> GetDataBySite(Int64 TaskHeaderID, String TaskSite, String TaskMode, Int32 TaskStatus) { String Query = "SELECT * FROM TaskDetail WHERE TaskSite = @TaskSite AND TaskStatus = @TaskStatus AND TaskMode = @TaskMode"; SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true); oDm.AddVarcharPara("TaskSite", 4000, TaskSite); oDm.AddIntegerPara("TaskStatus", TaskStatus); oDm.AddVarcharPara("TaskMode", 4000, TaskMode); return(DataParser.ToList <TaskDetail>(oDm.GetTable())); }
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()); }
public int UpdateImageByID(Int64 ID, String SmallImage, String BigImage) { String Query = "UPDATE ADIProduct1 WITH (ROWLOCK) SET SmallImage = @SmallImage, BigImage = @BigImage WHERE ID = @ID"; SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true); oDm.AddVarcharPara("SmallImage", 4000, SmallImage); oDm.AddVarcharPara("BigImage", 4000, BigImage); oDm.AddIntegerBigPara("ID", ID); return(oDm.RunActionQuery()); }
public int Insert(String Value, String DisplayName) { String Query = "INSERT INTO ADIBrands WITH (ROWLOCK) (Value, DisplayName) " + "VALUES (@Value, @DisplayName)"; SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true); oDm.AddVarcharPara("@Value", 255, Value); oDm.AddVarcharPara("@DisplayName", 255, DisplayName); return(oDm.RunActionQuery()); }
public int UpdateValue(String PART_NUM, String PropertyName, String PropertyValue) { String Query = "UPDATE ADIChild WITH (ROWLOCK) SET PropertyValue = @PropertyValue 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); oDm.AddVarcharPara("PropertyValue", 4000, PropertyValue); return(oDm.RunActionQuery()); }
public List <TaskDetail> GetDataBySite(Int64 TaskHeaderID, String TaskSite, String TaskMode, Int32[] TaskStatus) { String Query = "SELECT * FROM TaskDetail WHERE TaskSite = @TaskSite AND TaskStatus = @TaskStatus AND TaskMode IN ({0})"; Query = String.Format(Query, String.Join(",", TaskStatus.Select(x => x.ToString()).ToArray())); SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true); oDm.AddVarcharPara("TaskSite", 4000, TaskSite); oDm.AddVarcharPara("TaskMode", 4000, TaskMode); return(DataParser.ToList <TaskDetail>(oDm.GetTable())); }
public int UpdateByBrandValue(String Value, String DisplayName) { String Query = "UPDATE ADIBrands WITH (ROWLOCK) " + "SET DisplayName = @DisplayName " + "WHERE Value = @Value"; SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true); oDm.AddVarcharPara("Value", 255, Value); oDm.AddVarcharPara("DisplayName", 255, DisplayName); return(oDm.RunActionQuery()); }
public List <TaskDetail> GetDataByTaskDetail(Int64 TaskHeaderID, String TaskSite, String TaskMode, String TaskType, String TaskNameValue) { String Query = "SELECT * FROM TaskDetail WHERE TaskSite = @TaskSite AND TaskType = @TaskType AND TaskMode = @TaskMode AND TaskNameValue = @TaskNameValue"; SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true); oDm.AddVarcharPara("TaskSite", 4000, TaskSite); oDm.AddVarcharPara("TaskType", 4000, TaskType); oDm.AddVarcharPara("TaskMode", 4000, TaskMode); oDm.AddVarcharPara("TaskNameValue", 4000, TaskNameValue); return(DataParser.ToList <TaskDetail>(oDm.GetTable())); }
public int Insert(String Value, String DisplayName, String ParentValue, String CategoryUrl) { String Query = "INSERT INTO ADICategory WITH (ROWLOCK) (ParentValue, Value, DisplayName, CategoryUrl) " + "VALUES (@ParentValue, @Value, @DisplayName, @CategoryUrl)"; SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true); oDm.AddVarcharPara("ParentValue", 255, ParentValue); oDm.AddVarcharPara("Value", 255, Value); oDm.AddVarcharPara("DisplayName", 4000, DisplayName); oDm.AddVarcharPara("CategoryUrl", 4000, CategoryUrl); return(oDm.RunActionQuery()); }
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()); }
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()); }
public int UpdateByCatagoryID(String Value, String DisplayName, String ParentValue, String CategoryUrl) { String Query = "UPDATE ADICategory WITH (ROWLOCK) " + "SET ParentValue = @ParentValue, DisplayName = @DisplayName, CategoryUrl = @CategoryUrl " + "WHERE Value = @Value"; SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true); oDm.AddVarcharPara("ParentValue", 255, ParentValue); oDm.AddVarcharPara("Value", 255, Value); oDm.AddVarcharPara("DisplayName", 4000, DisplayName); oDm.AddVarcharPara("CategoryUrl", 4000, CategoryUrl); return(oDm.RunActionQuery()); }
public int SetStockAvailability(String Value) { String Query = "UPDATE ADIBrands WITH (ROWLOCK) SET InStock = 1 WHERE Value = @Value"; SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true); oDm.AddVarcharPara("Value", 4000, Value); return(oDm.RunActionQuery()); }
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())); }
public int SetHotDealsByCategoryValue(String Value) { String Query = "UPDATE ADICategory WITH (ROWLOCK) SET HotDeals = 1 WHERE Value = @Value"; SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true); oDm.AddVarcharPara("Value", 4000, Value); return(oDm.RunActionQuery()); }
public List <AdiBrand> GetDataByBrandValue(String Value) { String Query = "SELECT * FROM ADIBrands WITH (NOLOCK) WHERE Value = @Value"; SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true); oDm.AddVarcharPara("@Value", 255, Value); return(DataParser.ToList <AdiBrand>(oDm.GetTable())); }
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())); }
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()); }
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())); }
public List <AdiProduct> GetProductsByCatagory(String CatagoryID) { String Query = "SELECT ID FROM ADIProduct1 WITH (NOLOCK) WHERE CatagoryID = @CatagoryID"; SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true); oDm.AddVarcharPara("@CatagoryID", 4000, CatagoryID); return(DataParser.ToList <AdiProduct>(oDm.GetTable())); }
//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]); }
public List <AdiProduct> GetDataByPartNum(String AdiNumber) { String Query = "SELECT * FROM ADIProduct1 WITH (NOLOCK) WHERE AdiNumber = @AdiNumber"; SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true); oDm.AddVarcharPara("@AdiNumber", 4000, AdiNumber); return(DataParser.ToList <AdiProduct>(oDm.GetTable())); }
public int SetStockAvailability(String AdiNumber) { String Query = "UPDATE ADIProduct1 WITH (ROWLOCK) SET InStock = 1 WHERE AdiNumber = @AdiNumber"; SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true); oDm.AddVarcharPara("AdiNumber", 4000, AdiNumber); return(oDm.RunActionQuery()); }
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()); }
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); } }
public int SetUpdating(String AdiNumber, Boolean IsUpdating) { String Query = "UPDATE ADIProduct1 WITH (ROWLOCK) SET IsUpdating = @IsUpdating WHERE AdiNumber = @AdiNumber"; SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true); oDm.AddVarcharPara("AdiNumber", 4000, AdiNumber); oDm.AddBoolPara("IsUpdating", IsUpdating); return(oDm.RunActionQuery()); }
public int SetUpdateInterval(String AdiNumber, int UpdateInterval) { String Query = "UPDATE ADIProduct1 WITH (ROWLOCK) SET UpdateInterval = @UpdateInterval WHERE AdiNumber = @AdiNumber"; SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true); oDm.AddVarcharPara("AdiNumber", 4000, AdiNumber); oDm.AddIntegerPara("UpdateInterval", UpdateInterval); return(oDm.RunActionQuery()); }
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()); }
public int SetProductPriority(String AdiNumber, Boolean PriorityProduct, Int32 LeastCount) { String Query = "UPDATE ADIProduct1 WITH (ROWLOCK) SET PriorityProduct = @PriorityProduct, LeastCount = @LeastCount WHERE AdiNumber = @AdiNumber"; SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true); oDm.AddVarcharPara("AdiNumber", 4000, AdiNumber); oDm.AddBoolPara("PriorityProduct", PriorityProduct); oDm.AddIntegerPara("LeastCount", LeastCount); return(oDm.RunActionQuery()); }
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); }