public List <TaskDetail> GetDataScheduledPendingTasks(String TaskSite)
{
String Query = "SELECT TD.* FROM TaskHeader TH WITH (NOLOCK) "
+ "JOIN TaskDetail TD WITH (NOLOCK) ON TH.ScheduleID = TD.TaskHeaderID "
+ "WHERE TH.NextRun IS NOT NULL AND TH.NextRun <= GETDATE() AND TaskSite = @TaskSite";
SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true);
oDm.AddVarcharPara("TaskSite", 4000, TaskSite);
return(DataParser.ToList <TaskDetail>(oDm.GetTable()));
}
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 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);
}
public List <TaskDetail> GetDataBySite(Int64 TaskHeaderID, String TaskSite, Int32[] TaskStatus)
{
String Query = "SELECT * FROM TaskDetail WHERE TaskHeaderID = @TaskHeaderID AND TaskSite = @TaskSite AND TaskStatus IN ({0})";
Query = String.Format(Query, String.Join(",", TaskStatus.Select(x => x.ToString()).ToArray()));
SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true);
oDm.AddIntegerBigPara("TaskHeaderID", TaskHeaderID);
oDm.AddVarcharPara("TaskSite", 4000, TaskSite);
return(DataParser.ToList <TaskDetail>(oDm.GetTable()));
}
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 List <AdiCategory> GetData(Boolean ClearanceZone, Boolean SaleCenter, Boolean OnlineSpecials, Boolean HotDeals, Boolean InStock)
{
String Query = "SELECT * FROM ADICategory WITH (NOLOCK) "
+ "WHERE ClearanceZone = @ClearanceZone AND SaleCenter = @SaleCenter AND OnlineSpecials = @OnlineSpecials AND HotDeals = @HotDeals AND InStock = @InStock";
SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
oDm.AddBoolPara("ClearanceZone", ClearanceZone);
oDm.AddBoolPara("SaleCenter", SaleCenter);
oDm.AddBoolPara("OnlineSpecials", OnlineSpecials);
oDm.AddBoolPara("HotDeals", HotDeals);
oDm.AddBoolPara("InStock", InStock);
return(DataParser.ToList <AdiCategory>(oDm.GetTable()));
}
public Int64?GetIDByPartNumber(String AdiNumber)
{
String Query = "SELECT ID FROM ADIProduct1 WITH (NOLOCK) WHERE AdiNumber = @AdiNumber";
SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
oDm.AddVarcharPara("@AdiNumber", 4000, AdiNumber);
var oDt = oDm.GetTable();
if (oDt.Rows.Count == 0)
{
return(null);
}
else
{
return((Int64)oDt.Rows[0][0]);
}
}
public bool IsUpdating(String AdiNumber)
{
String Query = "SELECT IsUpdating FROM WITH (NOLOCK) ADIProduct1 WHERE AdiNumber = @AdiNumber";
SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
oDm.AddVarcharPara("AdiNumber", 4000, AdiNumber);
var dt = oDm.GetTable();
if (dt.Rows.Count == 0)
{
return(false);
}
else
{
return((bool)dt.Rows[0][0]);
}
}
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 Count()
{
String Query = "SELECT COUNT(1) FROM SecLockCategory WITH (NOLOCK)";
SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
return (int)oDm.GetTable().Rows[0][0];
}
public List<InCategory> GetData(InCategory category)
{
String Query = "SELECT * FROM SecLockCategory WITH (NOLOCK) WHERE Code = '" + category.Code+ "' ORDER BY Name";
SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
return DataParser.ToList<InCategory>(oDm.GetTable());
}