/// <summary>
/// 数据初始化
/// </summary>
private void InitData()
{
BLL.FileLogBll fLogBll = new BLL.FileLogBll();
DataSet ds = fLogBll.GetList(1000, " IsDeleted = 0 and FileID = " + file.ID, " AddTime desc, id asc");
if (ds != null && ds.Tables.Count > 0)
{
DataTable orgdt = ds.Tables[0];
DataTable dt = new DataTable();
dt.Columns.Add("id");
dt.Columns.Add("file_version");
dt.Columns.Add("ActionName");
dt.Columns.Add("file_modifyTime");
dt.Columns.Add("file_userName");
dt.Columns.Add("ComputerName");
dt.Columns.Add("file_userIp");
dt.Columns.Add("file_size");
dt.Columns.Add("downLink");
dt.Columns.Add("saveas");
dt.Columns.Add("File_ID");
dt.Columns.Add("ClientPath");
dt.Columns.Add("remark");
if (orgdt != null && orgdt.Rows.Count > 0)
{
for (int i = 0; i < orgdt.Rows.Count; i++)
{
DataRow row = dt.NewRow();
row[0] = orgdt.Rows[i]["FileVerID"].ToString();
row[1] = orgdt.Rows[i]["FileVer"].ToString();
row[2] = orgdt.Rows[i]["ActionName"].ToString();
row[3] = orgdt.Rows[i]["AddTime"].ToString();
row[4] = orgdt.Rows[i]["UserName"].ToString();
row[5] = string.Empty;
row[6] = orgdt.Rows[i]["Ip"].ToString();
row[7] = string.Empty;
row[8] = "下载到本地";
row[9] = "另存为";
row[10] = orgdt.Rows[i]["FileID"];
row[11] = orgdt.Rows[i]["ClientPath"];
row[12] = orgdt.Rows[i]["remark"];
dt.Rows.Add(row);
}
}
this.skinDataGridView_history.DataSource = dt;
}
}
/// <summary>
/// 数据初始化
/// </summary>
private void InitData()
{
BLL.FileLogBll fLogBll = new BLL.FileLogBll();
DataSet ds = fLogBll.GetAllInfoList(1000, " fl.IsDeleted = 0 and fl.actionCode = '" + code + "'", " fl.AddTime desc, fl.id asc");
if (ds != null && ds.Tables.Count > 0)
{
DataTable orgdt = ds.Tables[0];
DataTable dt = new DataTable();
dt.Columns.Add("id");
dt.Columns.Add("FileName");
dt.Columns.Add("file_user_name");
dt.Columns.Add("file_user_realname");
dt.Columns.Add("file_version");
dt.Columns.Add("ActionName");
dt.Columns.Add("file_modifyTime");
dt.Columns.Add("file_userName");
dt.Columns.Add("ComputerName");
dt.Columns.Add("file_userIp");
dt.Columns.Add("file_size");
dt.Columns.Add("downLink");
dt.Columns.Add("saveas");
dt.Columns.Add("File_ID");
dt.Columns.Add("ClientPath");
dt.Columns.Add("remark");
if (orgdt != null && orgdt.Rows.Count > 0)
{
Model.UserModel user = Bll.SystemBll.UserInfo;
for (int i = 0; i < orgdt.Rows.Count; i++)
{
DataRow row = dt.NewRow();
row[0] = orgdt.Rows[i]["FileVerID"].ToString();
row[1] = orgdt.Rows[i]["FileName"].ToString();
string userName = orgdt.Rows[i]["file_user_name"].ToString();
string userRealName = orgdt.Rows[i]["file_user_realname"].ToString();
if (string.IsNullOrEmpty(userName))
{
row[2] = user.UserName;
row[3] = user.RealName;
}
else
{
row[2] = userName;
row[3] = userRealName;
}
row[4] = orgdt.Rows[i]["FileVer"].ToString();
row[5] = orgdt.Rows[i]["ActionName"].ToString();
row[6] = orgdt.Rows[i]["AddTime"].ToString();
row[7] = orgdt.Rows[i]["UserName"].ToString();
row[8] = string.Empty;
row[9] = orgdt.Rows[i]["Ip"].ToString();
row[10] = string.Empty;
row[11] = "下载到本地";
row[12] = "另存为";
row[13] = orgdt.Rows[i]["FileID"];
row[14] = orgdt.Rows[i]["ClientPath"];
row[15] = orgdt.Rows[i]["remark"];
dt.Rows.Add(row);
}
}
this.skinDataGridView_history.DataSource = dt;
}
}
