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