/// <summary>
/// 绑定最后接收时间的GridView
/// </summary>
private void BindGridDate()
{
//设置不自动生成列
gridLastDate.AutoGenerateColumns = false;
DATablelastdateBLL tablelastdatebll = new DATablelastdateBLL();
List <DATablelastdate> list = tablelastdatebll.SelectyDATablelastdateInfo();
if (list.Count == 0)
{
return;
}
gridLastDate.DataSource = list;
//默认绑定第一行数据
BindRowData(list[0]);
}
/// <summary>
/// 系统日志处理
/// </summary>
private void LogHandle()
{
try
{
Hashtable lastht = new Hashtable();
lastht.Add("Tablename", DefaultConfig.ERRORLOG);
DATablelastdate lastdate = new DATablelastdate();
List <DATablelastdate> lstlastdate = lastdatebll.SelectyDATablelastdateInfo(lastht);
if (lstlastdate.Count > 0)
{
lastdate = lstlastdate[0];
}
//从da_tablelastdate表获取最后上传系统日志时间
DateTime lastSendTime = new DateTime();//lastdatebll.SelectyDATablelastdateInfoByTableName("ErrorLog");
if (lastdate != null)
{
lastSendTime = Convert.ToDateTime(lastdate.Lastdate);
}
//获取未上传的系统日志，转换为XML文件
Hashtable ht = new Hashtable();
ht.Add("Createdate", lastSendTime.ToString());
List <DAErrorlog> listlog = errorlogbll.SelectDAErrorlogbyDate(ht);
if (listlog.Count > 0)
{
DataTable dt = new DataTable();
dt.TableName = "data_row";
dt.Columns.Add("CUSTOMERCODE");
dt.Columns.Add("SITECODE");
dt.Columns.Add("ERRORLOGID");
dt.Columns.Add("USERCODE");
dt.Columns.Add("USERNAME");
dt.Columns.Add("CREATEDATE");
dt.Columns.Add("OPCONTENT");
dt.Columns.Add("USERTYPE");
dt.Columns.Add("IPADDRESS");
dt.Columns.Add("MACHINENAME");
foreach (DAErrorlog errorlog in listlog)
{
DataRow dr = dt.NewRow();
dr["CUSTOMERCODE"] = config.Username;
dr["SITECODE"] = config.Sitecode;
dr["ERRORLOGID"] = errorlog.Errorlogid;
dr["USERCODE"] = errorlog.Usercode;
dr["USERNAME"] = errorlog.Username;
dr["CREATEDATE"] = errorlog.Createdate;
dr["OPCONTENT"] = errorlog.Opcontent;
dr["USERTYPE"] = errorlog.Usertype;
dr["IPADDRESS"] = errorlog.Ipaddress;
dr["MACHINENAME"] = errorlog.Machinename;
dt.Rows.Add(dr);
}
string strxml = XMLHelper.CDataToXml(dt);
//登录获取的SID
// string[] strlogin = comonbll.UserLogin(config);
// if (strlogin[0] == "0") { SetTB("登录失败:" + strlogin[1]); return; }
// string SID = strlogin[1];
string[] obj = new string[] { SID, config.Username, StringToXML(strxml) };
//调用webwervices方法上传系统日志
string strQueryResult = WebServiceUtils.ExecuteMethod("SendErrLog", obj);
if (strQueryResult.Split('|')[0] == "1")
{
//更新da_tablelastdate表最后上传系统日志时间
if (lastSendTime != DateTime.MinValue)
{
lastdate.Lastdate = DateTime.Now;
lastdatebll.UpdateDATablelastdateInfo(lastdate);
}
else
{
DATablelastdate datablelastdate = new DATablelastdate();
datablelastdate.Createdate = DateTime.Now;
datablelastdate.Lastdate = DateTime.Now;
datablelastdate.Tablename = DefaultConfig.ERRORLOG;
datablelastdate.Remark = "创建日志表操作信息";
lastdatebll.InsertDATablelastdateInfo(datablelastdate);
}
// SetTB("系统日志传送成功!");
}
else
{
// SetTB("系统日志传送失败! " + strQueryResult.Split('|')[1]);
}
}
}
catch
{
SetTB("系统日志传送出现异常!");
}
}
