private void GetList(string searchStr = "")
{
using (var db = new AssetsInformationDB(dbPath))
{
//List<AssetsInformation> source = new List<AssetsInformation>();
//if (!string.IsNullOrWhiteSpace(searchStr))
//{
// source = db.Query<AssetsInformation>($"select * from assetsinformation where AssetName like '%{searchStr}%'");
//}
//else
//{
// source = db.Query<AssetsInformation>("select * from assetsinformation");
//}
//DataGrid.DataSource = source;
//DataGrid.ReloadSource();
List <AssetsInformation> source = new List <AssetsInformation>();
if (!string.IsNullOrWhiteSpace(searchStr))
{
source = db.Query <AssetsInformation>($"select * from assetsinformation where AssetName like '%{searchStr}%'");
}
else
{
source = db.Query <AssetsInformation>("select * from assetsinformation");
}
ucPagerControl21.Reload();
ucPagerControl21.PageSize = 3;
ucPagerControl21.DataSource = source.ToList <object>();
}
}
//生成二维码
private void BtnCreateQr_BtnClick(object sender, EventArgs e)
{
var rows = DataGrid.SelectRows;
if (rows != null)
{
var ids = string.Empty;
rows.ForEach(p => ids += $"{((AssetsInformation)((UCDataGridViewRow)p).DataSource).id},");
ids = ids.TrimEnd(',');
using (var db = new AssetsInformationDB(dbPath))
{
var list = db.Query <AssetsInformation>($"select * from assetsinformation where id in ({ids})");
if (list != null && list.Any())
{
foreach (var item in list)
{
item.QdPath = QRCodeHelper.CreateQRCodeImage(new QRCodeMsg()
{
Content = $"资产编码：{item.AssetCode}\r\n资产名称：{item.AssetName}\r\n资产类型：{item.AssetModel}\r\n管理部门：{item.ManagementDepartment}\r\n使用部门：{item.UseDepartment}\r\n使用状态：{item.UseState}\r\n使用年限：{item.UseDate}\r\n使用地点：{item.UsePlace}\r\n安装日期：{item.InstallationDate}",
ImageName = $"{item.AssetCode}{DateTime.Now.ToLongDateString()}{DateTime.Now.Hour}{DateTime.Now.Minute}{DateTime.Now.Second}",
FilePath = $"{Environment.CurrentDirectory}"
});
}
db.UpdateAll(list);
}
}
FrmTips.ShowTips(this, $"二维码生成成功！", 3000, true, ContentAlignment.MiddleCenter, null,
TipsSizeMode.Large, new Size(200, 80), TipsState.Success);
GetList();
}
}
//删除
private void BtnDel_BtnClick(object sender, EventArgs e)
{
var result = FrmDialog.ShowDialog(this, "确定删除选择的记录？", "删除记录", true);
if (result == DialogResult.OK)
{
var rows = DataGrid.SelectRows;
if (rows != null)
{
var ids = string.Empty;
rows.ForEach(p => ids += $"{((AssetsInformation)((UCDataGridViewRow)p).DataSource).id},");
ids = ids.TrimEnd(',');
using (var db = new AssetsInformationDB(dbPath))
{
db.Query <AssetsInformation>($"delete from assetsinformation where id in ({ids})");
}
GetList();
//rows.ForEach(p =>
//{
// if (!string.IsNullOrWhiteSpace(((AssetsInformation)((UCDataGridViewRow)p).DataSource).QdPath))
// {
// if (File.Exists(((AssetsInformation)((UCDataGridViewRow)p).DataSource).QdPath))
// {
// FileHelper.FileDel(((AssetsInformation)((UCDataGridViewRow)p).DataSource).QdPath);
// }
// }
//});
FrmTips.ShowTips(this, $"删除成功！", 3000, true, ContentAlignment.MiddleCenter, null,
TipsSizeMode.Large, new Size(200, 80), TipsState.Success);
}
}
}
//导入
private void BtnImport_BtnClick(object sender, EventArgs e)
{
OpenFileDialog fileDialog = new OpenFileDialog();
fileDialog.Filter = "Excel表格|*.xlsx";
fileDialog.CheckFileExists = true;
if (fileDialog.ShowDialog() == DialogResult.OK && !string.IsNullOrWhiteSpace(fileDialog.FileName))
{
//获取excel文件
var file = new System.IO.FileInfo(fileDialog.FileName);
System.Data.DataTable dt = null;
using (var package = new ExcelPackage(file))
{
//获取workbook
ExcelWorkbook workbook = package.Workbook;
if (workbook != null)
{
if (workbook.Worksheets.Count > 0)
{
//获取workbook的第一个worksheet
ExcelWorksheet worksheet = workbook.Worksheets[1];
//将worksheet转成datatable
dt = Common.ExcelHelper.WorksheetToTable(worksheet);
if (dt != null && dt.Rows.Count > 0)
{
List <AssetsInformation> list = new List <AssetsInformation>();
foreach (DataRow row in dt.Rows)
{
AssetsInformation entity = new AssetsInformation();
entity.AssetName = row["资产名称"]?.ToString();
entity.AssetCode = row["资产编码"]?.ToString();
entity.AssetModel = row["资产型号"]?.ToString();
entity.ManagementDepartment = row["管理部门"]?.ToString();
entity.UseDepartment = row["使用部门"]?.ToString();
entity.UseState = row["使用状态"]?.ToString();
entity.UseDate = row["使用年限"]?.ToString();
entity.UsePlace = row["使用地点"]?.ToString();
entity.InstallationDate = Convert.ToDateTime(row["安装日期"]?.ToString()).ToLongDateString();
entity.QdPath = $"{Environment.CurrentDirectory}\\NoBackPic.png";
list.Add(entity);
}
using (var db = new AssetsInformationDB(dbPath))
{
int count = db.InsertAll(list);
var source = db.Query <AssetsInformation>("select * from assetsinformation");
FrmTips.ShowTips(this, $"导入{count}条记录", 3000, true, ContentAlignment.MiddleCenter, null, TipsSizeMode.Large, new Size(300, 100), TipsState.Success);
}
GetList();
}
}
}
}
}
}
protected override void DoEnter()
{
AssetsInformation model = new AssetsInformation();
var txtAssetName = panel3.Controls.Find("TxtAssetName", true).FirstOrDefault();
if (txtAssetName != null)
{
model.AssetName = txtAssetName.Text;
}
var txtAssetCode = panel3.Controls.Find("TxtAssetCode", true).FirstOrDefault();
if (txtAssetCode != null)
{
model.AssetCode = txtAssetCode.Text;
}
var txtAssetModel = panel3.Controls.Find("TxtAssetModel", true).FirstOrDefault();
if (txtAssetModel != null)
{
model.AssetModel = txtAssetModel.Text;
}
var txtManagementDepartment = panel3.Controls.Find("TxtManagementDepartment", true).FirstOrDefault();
if (txtManagementDepartment != null)
{
model.ManagementDepartment = txtManagementDepartment.Text;
}
var txtUseDepartment = panel3.Controls.Find("TxtUseDepartment", true).FirstOrDefault();
if (txtUseDepartment != null)
{
model.UseDepartment = txtUseDepartment.Text;
}
var comUseState = panel3.Controls.Find("ComUseState", true).FirstOrDefault();
if (comUseState != null)
{
model.UseState = ((UCCombox)comUseState).SelectedText;
}
var txtUseDate = panel3.Controls.Find("TxtUseDate", true).FirstOrDefault();
if (txtUseDate != null)
{
model.UseDate = txtUseDate.Text;
}
var txtUsePlace = panel3.Controls.Find("TxtUsePlace", true).FirstOrDefault();
if (txtUsePlace != null)
{
model.UsePlace = txtUsePlace.Text;
}
//panel3.Controls.Find("DPInstallationDate", false);
using (var db = new AssetsInformationDB(dbPath))
{
string msg = string.Empty;
if (Item != null)
{
model.QdPath = $"{Environment.CurrentDirectory}\\NoBackPic.png";
db.Insert(model);
msg = $" 新增成功！";
}
else
{
db.Update(model);
msg = $" 修改成功！";
}
AddLog(model);
RefreshActionn();
FrmTips.ShowTips(this, msg, 3000, true, ContentAlignment.MiddleCenter, null, TipsSizeMode.Large, new Size(200, 80), TipsState.Success);
}
this.Close();
}
