private void frmEqAdd_Load(object sender, EventArgs e) { initcbx(this.cbxFunds, "Funds"); initcbx(this.cbxPriceType, "PriceType"); initcbx(this.cbxUsage, "Usage"); initcbx(this.cbxDirection, "Direction"); initcbx(this.cbxBuyWay, "BuyWay"); initcbx(this.cbxGetWay, "GetWay"); initcbx(this.cbxCarUse, "CarUse"); initcbx(this.cbxCarBP, "CarBP"); initcbx(this.cbxFormation, "Formation"); initcbx(this.cbxPR, "Pr"); initcbx(this.cbxCertNature, "CertNature"); initcbx(this.cbxStructure, "Structure"); initcbx(this.cbxUnit, "Unit"); initcbx(this.cbxKeepPlace, "KeepPlace"); initcbx(this.cbxRelicLv, "RelicLv"); initcbx(this.cbxCampus, "Campus"); this.txtDepartment.Text = SysUserMgr.GetDepartmentIDByUser(this._user); this.txtDepartment.Text = DepartMgr.GetNameFromId(this.txtDepartment.Text); this.dtpAddDate.Text = DateTime.Now.ToShortDateString(); this.txtAgent.Text = this._user; //cbxEqKeeper的初始化与其他不同,其ValueMember和DisplayMember是不一样的 initcbxEmployee(this.cbxEqKeeper); initcbxEmployee(this.cbxPurchaser); }
/// <summary> /// 添加资产 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void toolEqAdd_Click(object sender, EventArgs e) { if (this.checkInput()) { this.SetNo(); //生成随机编号 int error = 0; //错误标志 Equipment eq = new Equipment(); eq.EqName = this.txtEqName.Text; eq.EduNo = this.txtEduNo.Text; eq.EqType = this.cbxEqType.Text; eq.Gb = this.txtGB.Text; eq.Usage = this.cbxUsage.Text; eq.Unit = this.cbxUnit.Text; eq.Direction = this.cbxDirection.Text; eq.BuyWay = this.cbxBuyWay.Text; eq.GetWay = this.cbxGetWay.Text; eq.Purchaser = this.cbxPurchaser.Text; eq.Agent = this.txtAgent.Text; eq.Brand = this.txtBrand.Text; eq.Model = this.txtModel.Text; eq.Country = this.txtCountry.Text; eq.Mfrs = this.txtMfrs.Text; eq.ProductNo = this.txtProductNo.Text; eq.Supplier = this.txtSupplier.Text; eq.PriceType = this.cbxPriceType.Text; eq.EqKeeper = this.cbxEqKeeper.Text; eq.Department = DepartMgr.GetIdFromName(this.txtDepartment.Text); eq.Campus = this.cbxCampus.Text; eq.KeepPlace = this.cbxKeepPlace.Text; eq.Cn = this.txtCN.Text; eq.InvNo = this.txtInvNo.Text; eq.Funds = this.cbxFunds.Text; eq.BelongTo = ""; eq.Photo = this.photoPath; eq.Remark = this.txtRemark.Text; if (this.dtpGetDate.Checked == true) { eq.GetDate = this.dtpGetDate.Value.ToShortDateString(); } else { eq.GetDate = ""; } if (dtpAddDate.Checked == true) { eq.AddDate = this.dtpAddDate.Value.ToShortDateString(); } else { eq.AddDate = ""; } if (this.dtpBirthday.Checked == true) { eq.Birthday = this.dtpBirthday.Value.ToShortDateString(); } else { eq.Birthday = ""; } if (this.dtpSvcDate.Checked == true) { eq.SvcDate = this.dtpSvcDate.Value.ToShortDateString(); } else { eq.SvcDate = ""; } /*****************************根据资产类别判断所要填的项********************************************/ //资产类别为“土地、房屋及构筑物”时 if (eq.EqType == "土地、房屋及构筑物") { eq.Pr = this.cbxPR.Text; eq.Address = this.txtAddress.Text; eq.CertNature = this.cbxCertNature.Text; eq.Structure = this.cbxStructure.Text; //有产权时以下四项才可以被填写 if (eq.Pr == "有产权") { if (this.txtCertNo.Text.Trim() == "") { untCommon.InfoMsg("请输入权属证号"); return; } else { eq.CertNo = this.txtCertNo.Text; } if (this.dtpIssueDate.Checked == false) { untCommon.InfoMsg("请选择发证日期"); return; } else { eq.IssueDate = this.dtpIssueDate.Value.ToShortDateString(); } if (this.txtCertProve.Text.Trim() == "") { untCommon.InfoMsg("请输入权属证明"); return; } else { eq.CertProve = this.txtCertProve.Text; } try { eq.CertLim = int.Parse(this.txtCertLim.Text); } catch (FormatException) { untCommon.ErrorMsg("权属年限请输入数字。"); return; } } else { eq.CertNo = ""; eq.IssueDate = ""; eq.CertProve = ""; eq.CertLim = 0; } try { eq.Area = double.Parse(this.txtArea.Text); } catch (FormatException) { untCommon.ErrorMsg("建筑/土地面积请输入数字。"); return; } try { eq.TenuArea = double.Parse(this.txtTenuArea.Text); } catch (FormatException) { untCommon.ErrorMsg("自用面积请输入数字。"); return; } try { eq.TenuPrice = double.Parse(this.txtTenuPrice.Text); } catch (FormatException) { untCommon.ErrorMsg("自用价值请输入数字。"); return; } } else { eq.Pr = ""; eq.CertNo = ""; eq.IssueDate = ""; eq.CertProve = ""; eq.Address = ""; eq.CertNature = ""; eq.Structure = ""; eq.Area = 0; eq.TenuArea = 0; eq.TenuPrice = 0; eq.CertLim = 0; } //资产类别为"通用设备(车辆)" if (eq.EqType == "通用设备(车辆)") { eq.CarUse = this.cbxCarUse.Text; eq.CarBP = this.cbxCarBP.Text; eq.LicNo = this.txtLicNo.Text; eq.Dspl = this.txtDSPL.Text; eq.EngNo = this.txtEngNo.Text; eq.Formation = this.cbxFormation.Text; } else { eq.CarUse = ""; eq.CarBP = ""; eq.LicNo = ""; eq.Dspl = ""; eq.EngNo = ""; eq.Formation = ""; } //资产类别为"无形资产" if (eq.EqType == "无形资产") { eq.RegAuz = this.txtRegAuz.Text; eq.PatNo = this.txtPatNo.Text; eq.ApvNo = this.txtApvNo.Text; eq.MgtAgency = this.txtMgtAgency.Text; if (this.dtpRegTime.Checked == true) { eq.RegTime = this.dtpRegTime.Value.ToShortDateString(); } else { eq.RegTime = ""; } } else { eq.RegAuz = ""; eq.RegTime = ""; eq.PatNo = ""; eq.ApvNo = ""; eq.MgtAgency = ""; } //资产类别为"文物和陈列品" if (eq.EqType == "文物和陈列品") { eq.RelicLv = this.cbxRelicLv.Text; } else { eq.RelicLv = ""; } /*************************************判断结束******************************************************/ try { count = int.Parse(this.txtCount.Text); } catch (FormatException) { untCommon.ErrorMsg("数量请输入数字。"); return; } try { eq.Price = double.Parse(this.txtPrice.Text); } catch (FormatException) { untCommon.ErrorMsg("价值请输入数字。"); return; } try { if (this.txtUSDPrice.Text.Trim() != "") { eq.UsdPrice = double.Parse(this.txtUSDPrice.Text); } else { eq.UsdPrice = 0; } } catch (FormatException) { untCommon.ErrorMsg("美金单价请输入数字。"); return; } if (_power == "0" || _power == "1") { int tempCount = EqMgr.getTempAssetCount(); int allCount = EqMgr.getAllAssetCount(); int eqCount = EqMgr.getAllEqCount(); int assetCount = allCount - tempCount + 1; eq.State = "入库"; for (int j = 1; j <= count; j++) { eq.EqNo = DateTime.Now.Year.ToString() + string.Format("{0:D6}", eqCount + j); eq.AssetNo = SysUserMgr.GetDepartmentIDByUser(this._user) + DateTime.Now.Year.ToString() + string.Format("{0:D4}", assetCount); if (EqMgr.Add(eq)) { /*if (!SqlFileMgr.PhotoAdd(eq.EqNo, photoPath)) * error++; * if (!WriteAttachment(eq.EqNo)) * error++;*/ } else { error++; } } } else { for (int i = 1; i <= count; i++) { eq.EqNo = "TE" + random + string.Format("{0:000}", i); eq.AssetNo = "TA" + random + string.Format("{0:000}", count); eq.State = "新增待审核"; //if (this.pbPhoto.Image != null) //photoPath = this.pbPhoto.ImageLocation; if (EqMgr.Add(eq)) { /*if (!SqlFileMgr.PhotoAdd(eq.EqNo, photoPath)) * error++; * if (!WriteAttachment(eq.EqNo)) * error++;*/ } else { error++; } } } if (error == 0) { untCommon.InfoMsg("添加成功"); ClearInput(); this.SetNo(); this.Close(); } else { untCommon.InfoMsg("错误数目:" + error.ToString()); this.SetNo(); } } }