IEnumerator DownloadAssets(AssetsInformation assets)
{
var request = UnityWebRequestAssetBundle.GetAssetBundle(assets.AssetLink, 1, 0);
yield return(request.SendWebRequest());
_bundle = DownloadHandlerAssetBundle.GetContent(request);
}
//导入
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();
}
}
}
}
}
}
private void AddLog(AssetsInformation model)
{
LogModel logModel = new LogModel();
logModel.AssetName = model.AssetName;
logModel.AssetCode = model.AssetCode;
logModel.AssetModel = model.AssetModel;
logModel.ManagementDepartment = model.ManagementDepartment;
logModel.UseDepartment = model.UseDepartment;
logModel.UseState = model.UseState;
logModel.UsePlace = model.UsePlace;
logModel.UseDate = model.UseDate;
logModel.CreateDate = DateTime.Now;
using (var db = new LogInformationDB(dbPath))
{
db.Insert(logModel);
}
}
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();
}
