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);
}
