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(); }