/// <summary> /// �����Ƿ����豸 /// </summary> /// <param name="info"></param> /// <returns></returns> public Hcontract UpdateHcontractByInstanceid(Hcontract info) { try { this.Database.AddInParameter(":Instanceid", info.Instanceid);//DBType:NUMBER this.Database.AddInParameter(":Isimport", info.Isimport);//DBType:NUMBER string sqlCommand = @"UPDATE ""H_CONTRACT"" SET ""ISIMPORT""=:Isimport WHERE ""INSTANCEID""=:Instanceid"; this.Database.ExecuteNonQuery(sqlCommand); } finally { this.Database.ClearParameter(); } return info; }
protected void ReadEntityToControl(Hcontract headInfo) { litInstanceid.Text = headInfo.Instanceid.ToString();//合同编号 litXmmc.Text = headInfo.Xmmc;//合同名 var supplierInfo=AssetsupplierService.RetrieveAssetsupplierBySupplierName(headInfo.Cbf); if(supplierInfo!=null) { ucSelectSupplier.Supplierid = supplierInfo.Supplierid;//供应商 } ucSubCompany.SubcompanyId = headInfo.Departid.ToString(); //分公司 }
/// <summary> /// 保存 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void BtnSave_Click(object sender, EventArgs e) { if (ImportAssetContractdetailContractDetail.Count == 0) { UIHelper.AlertMessageGoToURL(this, "对不起,该合同已没设备可再导入了!", ResolveUrl("~/Admin/EquipmentList.aspx")); return; } foreach (var importAssetContractdetail in ImportAssetContractdetailContractDetail) { if (string.IsNullOrEmpty(importAssetContractdetail.Storage)) { UIHelper.Alert(this, string.Format(@"请修改列表中设备{0}-{1}的存放地点!", importAssetContractdetail.CategoryAllPathName, importAssetContractdetail.Assetname)); return; } } //var contractDetails = ContractDetailService.RetrieveProcurementcontractdetailByContractdetailid(ImportAssetContractdetailContractDetail.Select(p => p.Contractdetailid).ToList()); foreach (var importAssetContractdetail in ImportAssetContractdetailContractDetail) { //var currentDetails =contractDetails.Where(p => p.Contractdetailid == importAssetContractdetail.Contractdetailid).FirstOrDefault(); //if (currentDetails != null) //{ // currentDetails.Inputnumber = importAssetContractdetail.ImportNumber; //} for (decimal i = 0; i < importAssetContractdetail.ImportNumber; i++) { Asset data = new Asset(); data.Assetcategoryid = importAssetContractdetail.Assetcategoryid;//设备类别 //当前选择小分类值 var currentSelectedCategory =AssetCategories.Where(p => p.Assetcategoryid == data.Assetcategoryid).FirstOrDefault(); if (currentSelectedCategory != null) { data.Categoryvalue = currentSelectedCategory.Categoryvalue; } data.Assetname = importAssetContractdetail.Assetname;//设备名称 data.Storage = importAssetContractdetail.Storage;//存放地点 data.State = AssetState.NoUse;//设备状态 data.Depreciationyear = importAssetContractdetail.Depreciationyear;//折旧年限 data.Unitprice = importAssetContractdetail.Unitprice;//单价 data.Brand = importAssetContractdetail.Brand;//品牌 data.Managemode = importAssetContractdetail.Managemode;//管理模式,托管:0自管:1 data.Financecategory = FinanceCategory.AAccount;//importAssetContractdetail.Financecategory;//财务类别(A帐:0B帐:1) data.Supplierid = ucSelectSupplier.Supplierid;//importAssetContractdetail.Supplierid;//供应商 data.Purchasedate = importAssetContractdetail.Purchasedate;//购入日期 data.Expireddate = importAssetContractdetail.Expireddate;//折旧到期日期 data.Assetspecification = importAssetContractdetail.Assetspecification;//设备规格 data.Storageflag = importAssetContractdetail.Storageflag;//存放地点标识来源 data.Subcompany = ucSubCompany.SubcompanyId;//分公司 data.Contractid = importAssetContractdetail.Contractid;//合同编号 data.Contractdetailid = importAssetContractdetail.Contractdetailid;//合同明细编号 AssetService.SaveAssetInfo(data); } } var contract=new Hcontract(); contract.Isimport = true; contract.Instanceid = Instanceid; HcontractService.UpdateHcontractByInstanceid(contract); UIHelper.AlertMessageGoToURL(this, "保存成功!", ResolveUrl("~/Admin/EquipmentList.aspx")); }
public Hcontract UpdateHcontractByInstanceid(Hcontract info) { return Management.UpdateHcontractByInstanceid(info); }