/// <summary>
/// 获取一批源数据
/// </summary>
/// <param name="dtStart">起始时间</param>
/// <param name="dtEnd">终止时间</param>
/// <param name="startIndex">起始索引</param>
/// <param name="endIndex">终止索引</param>
/// <returns>获取到的源数据</returns>
private DataTable GetBatchSourceData(DateTime?dtStart, DateTime?dtEnd, int startIndex, int endIndex)
{
string sql = "SELECT * FROM (SELECT row_number () OVER (ORDER BY CONVERT(DateTime,PrintDate+' '+PrintTime,121)) 'row_num',tbl_PrintRecord.* FROM tbl_PrintRecord WHERE 1=1 ) AS t WHERE row_num >= @startIndex and row_num<=@endIndex;";
Dictionary <string, object> pms = new Dictionary <string, object>();
DataTable dt = new DataTable();
pms.Add("@startIndex", startIndex);
pms.Add("@endIndex", endIndex);
if (dtStart.HasValue && !dtEnd.HasValue)
{
sql = "SELECT * FROM (SELECT row_number () OVER (ORDER BY CONVERT(DateTime,PrintDate+' '+PrintTime,121)) 'row_num',tbl_PrintRecord.* FROM tbl_PrintRecord WHERE CONVERT(DateTime,PrintDate+' '+PrintTime,121)>=@dtStart ) AS t WHERE row_num >= @startIndex and row_num<=@endIndex;";
pms.Add("@dtStart", (DateTime)dtStart);
}
else if (dtStart.HasValue && dtEnd.HasValue)
{
sql = "SELECT * FROM (SELECT row_number () OVER (ORDER BY CONVERT(DateTime,PrintDate+' '+PrintTime,121)) 'row_num',tbl_PrintRecord.* FROM tbl_PrintRecord WHERE CONVERT(DateTime,PrintDate+' '+PrintTime,121)>=@dtStart and CONVERT(DateTime,PrintDate+' '+PrintTime,121)<=@dtEnd ) AS t WHERE row_num >= @startIndex and row_num<=@endIndex;";
pms.Add("@dtStart", (DateTime)dtStart);
pms.Add("@dtEnd", (DateTime)dtEnd);
}
try
{
dt = RemoteDbServer.QueryTable(sql, pms);
}
catch (Exception)
{
}
return(dt);
}
/// <summary>
/// 获取本次需要导入的最大时间
/// </summary>
/// <returns>返回本次需要导入的时间,如果没有获得时间则值为空</returns>
private DateTime?GetNeed2ImportTime()
{
string sql = "select max(CONVERT(DateTime,PrintDate+' '+PrintTime,120)) from tbl_PrintRecord;";
object obj = null;
try
{
obj = RemoteDbServer.QueryObj(sql);
}
catch (Exception)
{
obj = string.Empty;
}
DateTime dt = DateTime.Now;
return(DateTime.TryParse(obj.ToString(), out dt) ? dt : (DateTime?)(null));
}
/// <summary>
/// 获取需要更新的生产单数量
/// </summary>
/// <param name="dtStart">更新的起始时间</param>
/// <param name="dtEnd">更新的终止时间</param>
/// <returns>需要更新生产单的条数</returns>
private int GetMpoCount2Import(DateTime?dtStart, DateTime?dtEnd)
{
string sql = "select count(1) from tbl_PrintRecord;";
Dictionary <string, object> pms = new Dictionary <string, object>();
if (dtStart.HasValue && !dtEnd.HasValue)
{
sql = "select count(1) from tbl_PrintRecord where CONVERT(DateTime,PrintDate+' '+PrintTime,120)>@dtStart;";
pms.Add("@dtStart", (DateTime)dtStart);
}
else if (dtStart.HasValue && dtEnd.HasValue)
{
sql = "select count(1) from tbl_PrintRecord where CONVERT(DateTime,PrintDate+' '+PrintTime,120)>@dtStart and CONVERT(DateTime,PrintDate+' '+PrintTime,120)<@dtEnd;";
pms.Add("@dtStart", (DateTime)dtStart);
pms.Add("@dtEnd", (DateTime)dtEnd);
}
object obj = RemoteDbServer.QueryObj(sql, pms);
int intTmp = 0;
return(int.TryParse((obj ?? "0").ToString(), out intTmp) ? intTmp : 0);
}
