public bool CheckServer(bool bshow = false)
{
bool bok = true;
DBParams param = new DBParams();
param.Allweight = "90";
param.Plateno = "冀B6326R";
param.Clientid = "11111";
param.Bdid = "bdid11111{}";
//List<DBParams> l0 = new List<DBParams>();
//l0.Add(param);
string s1 = JsonConvert.SerializeObject(param);
s1 = Tools.EncodeBase64("UTF-8", s1);
try
{
string res = Tools.HttpPostInfo(CURR_URI + "wmdatas2", "type=200&json=" + s1);
if (bshow && res.Length > 0)
{
MessageBox.Show(res);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
bok = false;
}
return(bok);
}
private void UpLoadWeightData(object sender, ElapsedEventArgs e)
{
if (canRun)
{
canRun = false;
try
{
string bgtime = DBTools.GetSearchBgTime(configM.Sid);
DateTime d1 = DateTime.Now;
int jgmin = -configM.Inter;
d1 = d1.AddMinutes(jgmin);
if (string.IsNullOrEmpty(bgtime))
{
bgtime = configM.Bgtime;
}
string edtime = d1.ToString(ICL.DATE_FMT_L);
//开始同步数据
SyncDataToBakTable(edtime);
//同步数据结束
string s1 = string.Format(rsql, bgtime, edtime);
string log = "{0}-->开始执行任务，查询区间{1}===={2}";
log = string.Format(log, Tools.Now(), bgtime, edtime);
updateTabsLogs(log);
logger.Info("任务开始执行：" + s1);//执行sql查询
List <JObject> list = null;
try
{
list = DBTools.Query(s1);
int size = 0;
if (list != null && list.Count > 0)
{
List <DBParams> listup = new List <DBParams>();
foreach (JObject obj in list)
{
DBParams param = JsonConvert.DeserializeObject <DBParams>(obj.ToString());
if (!DBTools.checkRecordUped(param.Bdid))
{
size++;
if (string.IsNullOrEmpty(param.Sbid))
{
param.Sbid = cURR_DBID;
}
if (string.IsNullOrEmpty(param.Scm))
{
param.Scm = cURR_SCM;
}
if (string.IsNullOrEmpty(param.Sopr))
{
param.Sopr = cURR_OPR;
}
listup.Add(param);
}
if (listup.Count >= 10)
{
string sup = JsonConvert.SerializeObject(listup);
logger.Info("开始执行上传：" + sup);
sup = Tools.EncodeBase64("UTF-8", sup);
sup = Tools.EscapeExprSpecialWord(sup);
Tools.HttpPostInfo(url + "wmdatas2", "type=210&json=" + sup);
logger.Info("小组执行完成：" + sup);
logger.Info("开始写小组日志：");
DBTools.WriteSysUpLog(listup);
listup.Clear();
Thread.Sleep(5);
}
}
if (listup.Count > 0)
{
string sup = JsonConvert.SerializeObject(listup);
logger.Info("开始执行尾数上传：" + sup);
sup = Tools.EncodeBase64("UTF-8", sup);
sup = Tools.EscapeExprSpecialWord(sup);
Tools.HttpPostInfo(url + "wmdatas2", "type=210&json=" + sup);
logger.Info("尾数执行完成：" + sup);
logger.Info("开始写尾数日志：");
DBTools.WriteSysUpLog(listup);
listup.Clear();
}
logger.Info(string.Format("本次执行完成,上传总条数【{0}】", size));
}
else
{
logger.Info("没有查询到数据;");
}
DBTools.insertOrUpDate(configM.Sid, edtime);
updateTabsLogs(string.Format(Tools.Now() + "-->任务执行完成【{0}】", size));
}
catch (Exception ex)
{
logger.Error("错误SQL：" + s1);
logger.Error(ex, "执行查询出错");
updateTabsLogs(Tools.Now() + "-->任务执行报错：" + ex.Message);
}
}
catch (Exception ex)
{
logger.Error(ex, "上传出错！");
}
finally {
canRun = true;
}
}
}