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 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 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 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 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 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 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 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<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<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());
}
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 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 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());
}
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];
}
public int UpdateByPartNum(String PART_NUM, int TotalInventory, int Dallas, int DC_AtlantaHub, int DC_Dallas_Hub, int DC_Elk_Grove_Hub, int DC_Feura_Bush, int DC_Louisville_Hub
, int DC_Reno_Hub, int DC_Richmond_Dist_Ctr, int Oklahama, int RemainingBranches, DateTime LastUpdate)
{
String Query = "UPDATE ADIInventoryExport WITH (ROWLOCK) SET TotalInventory = @TotalInventory, Dallas = @Dallas, DC_AtlantaHub = @DC_AtlantaHub, DC_Dallas_Hub = @DC_Dallas_Hub, DC_Elk_Grove_Hub = @DC_Elk_Grove_Hub, DC_Feura_Bush = @DC_Feura_Bush, DC_Louisville_Hub = @DC_Louisville_Hub, DC_Reno_Hub = @DC_Reno_Hub,DC_Richmond_Dist_Ctr = @DC_Richmond_Dist_Ctr, Oklahama = @Oklahama, RemainingBranches = @RemainingBranches, LastUpdate = @LastUpdate WHERE PART_NUM = @PART_NUM";
SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
oDm.AddVarcharPara("PART_NUM", 4000, PART_NUM);
oDm.AddIntegerPara("TotalInventory", TotalInventory);
oDm.AddIntegerPara("Dallas", Dallas);
oDm.AddIntegerPara("DC_AtlantaHub", DC_AtlantaHub);
oDm.AddIntegerPara("DC_Dallas_Hub", DC_Dallas_Hub);
oDm.AddIntegerPara("DC_Elk_Grove_Hub", DC_Elk_Grove_Hub);
oDm.AddIntegerPara("DC_Feura_Bush", DC_Feura_Bush);
oDm.AddIntegerPara("DC_Louisville_Hub", DC_Louisville_Hub);
oDm.AddIntegerPara("DC_Reno_Hub", DC_Reno_Hub);
oDm.AddIntegerPara("DC_Richmond_Dist_Ctr", DC_Richmond_Dist_Ctr);
oDm.AddIntegerPara("Oklahama", Oklahama);
oDm.AddIntegerPara("RemainingBranches", RemainingBranches);
oDm.AddDateTimePara("LastUpdate", LastUpdate);
return oDm.RunActionQuery();
}
public int Insert(String PART_NUM, int TotalInventory, int Dallas, int DC_AtlantaHub, int DC_Dallas_Hub, int DC_Elk_Grove_Hub, int DC_Feura_Bush, int DC_Louisville_Hub
, int DC_Reno_Hub, int DC_Richmond_Dist_Ctr, int Oklahama, int RemainingBranches, DateTime LastUpdate)
{
String Query = "INSERT INTO ADIInventoryExport WITH (ROWLOCK) (PART_NUM, TotalInventory, Dallas, DC_AtlantaHub, DC_Dallas_Hub, DC_Elk_Grove_Hub, DC_Feura_Bush, DC_Louisville_Hub, DC_Reno_Hub, DC_Richmond_Dist_Ctr, Oklahama, RemainingBranches, LastUpdate) "
+ "VALUES (@PART_NUM, @TotalInventory, @Dallas, @DC_AtlantaHub, @DC_Dallas_Hub, @DC_Elk_Grove_Hub, @DC_Feura_Bush, @DC_Louisville_Hub, @DC_Reno_Hub, @DC_Richmond_Dist_Ctr, @Oklahama, @RemainingBranches, @LastUpdate)";
SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
oDm.AddVarcharPara("PART_NUM", 4000, PART_NUM);
oDm.AddIntegerPara("TotalInventory", TotalInventory);
oDm.AddIntegerPara("Dallas", Dallas);
oDm.AddIntegerPara("DC_AtlantaHub", DC_AtlantaHub);
oDm.AddIntegerPara("DC_Dallas_Hub", DC_Dallas_Hub);
oDm.AddIntegerPara("DC_Elk_Grove_Hub", DC_Elk_Grove_Hub);
oDm.AddIntegerPara("DC_Feura_Bush", DC_Feura_Bush);
oDm.AddIntegerPara("DC_Louisville_Hub", DC_Louisville_Hub);
oDm.AddIntegerPara("DC_Reno_Hub", DC_Reno_Hub);
oDm.AddIntegerPara("DC_Richmond_Dist_Ctr", DC_Richmond_Dist_Ctr);
oDm.AddIntegerPara("Oklahama", Oklahama);
oDm.AddIntegerPara("RemainingBranches", RemainingBranches);
oDm.AddDateTimePara("LastUpdate", LastUpdate);
return oDm.RunActionQuery();
}
public int SetStockAvailability(String Value)
{
String Query = "UPDATE ADICategory 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 int SetOnlineSpecialsByCategoryValue(String Value)
{
String Query = "UPDATE ADICategory WITH (ROWLOCK) SET OnlineSpecials = 1 WHERE Value = @Value";
SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
oDm.AddVarcharPara("Value", 4000, Value);
return oDm.RunActionQuery();
}
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 Update(Int64 ScheduleID, String TaskName, String TaskDescription, String Site, DateTime ScheduleFrom
, Boolean TaskRepeat, Int32 TaskRepeatInterval, String TaskRepeatUnit, Boolean Enabled)
{
String Query = "UPDATE [TaskHeader] SET [TaskName] = @TaskName, [TaskDescription] = @TaskDescription, [Site] = @Site, "
+ "[ScheduleFrom] = @ScheduleFrom, [TaskRepeat] = @TaskRepeat, [TaskRepeatInterval] = @TaskRepeatInterval, "
+ "[TaskRepeatUnit] = @TaskRepeatUnit, [Enabled] = @Enabled "
+ "WHERE [ScheduleID] = @ScheduleID";
SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
oDm.AddIntegerBigPara("ScheduleID", ScheduleID);
oDm.AddVarcharPara("TaskName", 4000, TaskName);
oDm.AddVarcharPara("TaskDescription", 4000, TaskDescription);
oDm.AddVarcharPara("Site", 4000, Site);
oDm.AddDateTimePara("ScheduleFrom", ScheduleFrom);
oDm.AddBoolPara("TaskRepeat", TaskRepeat);
oDm.AddIntegerPara("TaskRepeatInterval", TaskRepeatInterval);
oDm.AddVarcharPara("TaskRepeatUnit", 4000, TaskRepeatUnit);
oDm.AddBoolPara("Enabled", Enabled);
return oDm.RunActionQuery();
}
public int Insert(Int64 ScheduleID, String TaskName, String TaskDescription, String Site, DateTime ScheduleFrom
, Boolean TaskRepeat, Int32 TaskRepeatInterval, String TaskRepeatUnit, Boolean Enabled)
{
String Query = "INSERT INTO [TaskHeader] ([TaskName], [TaskDescription], [Site], [ScheduleFrom], [TaskRepeat], [TaskRepeatInterval], [TaskRepeatUnit], [Enabled], [CreatedDate]) "
+ "VALUES (@TaskName, @TaskDescription, @Site, @ScheduleFrom, @TaskRepeat, @TaskRepeatInterval, @TaskRepeatUnit, @Enabled, @CreatedDate);";
SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
//oDm.AddIntegerBigPara("ScheduleID", ScheduleID);
oDm.AddVarcharPara("TaskName", 4000, TaskName);
oDm.AddVarcharPara("TaskDescription", 4000, TaskDescription);
oDm.AddVarcharPara("Site", 4000, Site);
oDm.AddDateTimePara("ScheduleFrom", ScheduleFrom);
oDm.AddBoolPara("TaskRepeat", TaskRepeat);
oDm.AddIntegerPara("TaskRepeatInterval", TaskRepeatInterval);
oDm.AddVarcharPara("TaskRepeatUnit", 4000, TaskRepeatUnit);
oDm.AddBoolPara("Enabled", Enabled);
oDm.AddDateTimePara("CreatedDate", DateTime.Now);
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 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 UpdateStatus(Int64 TaskID, String TaskStatusText, int TaskStatus)
{
String Query = "UPDATE TaskDetail SET TaskStatusText = @TaskStatusText, TaskStatus = @TaskStatus, UpdatedOn = @UpdatedOn WHERE TaskID = @TaskID";
SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true);
oDm.AddIntegerBigPara("TaskID", TaskID);
oDm.AddVarcharPara("TaskStatusText", 4000, TaskStatusText);
oDm.AddIntegerPara("TaskStatus", TaskStatus);
oDm.AddDateTimePara("UpdatedOn", DateTime.Now);
return oDm.RunActionQuery();
}
public int Insert(Int64 TaskID, Int64 TaskHeaderID, String TaskNameText, String TaskNameValue, String TaskStatusText, int TaskStatus, Boolean DownloadImages, Boolean IgnitoMode, String TaskType, String TaskMode, String TaskSite)
{
String Query = "INSERT INTO TaskDetail (TaskHeaderID, TaskNameText ,TaskNameValue ,TaskStatusText ,TaskStatus, DownloadImages, IgnitoMode, TaskType, TaskMode ,TaskSite ,CreatedOn, UpdatedOn) "
+ "VALUES (@TaskHeaderID, @TaskNameText ,@TaskNameValue ,@TaskStatusText ,@TaskStatus, @DownloadImages, @IgnitoMode ,@TaskType, @TaskMode ,@TaskSite ,@CreatedOn, @UpdatedOn)";
SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true);
oDm.AddIntegerBigPara("TaskHeaderID", TaskHeaderID);
oDm.AddVarcharPara("TaskNameText", 4000, TaskNameText);
oDm.AddVarcharPara("TaskNameValue", 4000, TaskNameValue);
oDm.AddVarcharPara("TaskStatusText", 4000, TaskStatusText);
oDm.AddIntegerPara("TaskStatus", TaskStatus);
oDm.AddBoolPara("DownloadImages", DownloadImages);
oDm.AddBoolPara("IgnitoMode", IgnitoMode);
oDm.AddVarcharPara("TaskType", 4000, TaskType);
oDm.AddVarcharPara("TaskMode", 4000, TaskMode);
oDm.AddVarcharPara("TaskSite", 4000, TaskSite);
oDm.AddDateTimePara("CreatedOn", DateTime.Now);
oDm.AddDateTimePara("UpdatedOn", null);
return oDm.RunActionQuery();
}
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> 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 Update(Int64 TaskID, Int64 TaskHeaderID, string TaskNameText, string TaskNameValue, string TaskStatusText, int TaskStatus, bool DownloadImages, bool IgnitoMode, string TaskType, String TaskMode, string TaskSite)
{
String Query = "UPDATE TaskDetail SET TaskHeaderID = @TaskHeaderID, TaskNameText = @TaskNameText, TaskNameValue = @TaskNameValue, TaskStatusText = @TaskStatusText, TaskStatus = @TaskStatus, "
+ "DownloadImages = @DownloadImages, IgnitoMode = @IgnitoMode, TaskType = @TaskType, TaskMode = @TaskMode, TaskSite = @TaskSite, UpdatedOn = @UpdatedOn WHERE TaskID = @TaskID";
SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true);
oDm.AddIntegerBigPara("TaskID", TaskID);
oDm.AddIntegerBigPara("TaskHeaderID", TaskHeaderID);
oDm.AddVarcharPara("TaskNameText", 4000, TaskNameText);
oDm.AddVarcharPara("TaskNameValue", 4000, TaskNameValue);
oDm.AddVarcharPara("TaskStatusText", 4000, TaskStatusText);
oDm.AddIntegerPara("TaskStatus", TaskStatus);
oDm.AddBoolPara("DownloadImages", DownloadImages);
oDm.AddBoolPara("IgnitoMode", IgnitoMode);
oDm.AddVarcharPara("TaskType", 4000, TaskType);
oDm.AddVarcharPara("TaskMode", 4000, TaskMode);
oDm.AddVarcharPara("TaskSite", 4000, TaskSite);
oDm.AddDateTimePara("UpdatedOn", DateTime.Now);
return oDm.RunActionQuery();
}
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());
}