public Assetremovedetail CreateAssetremovedetail(Assetremovedetail info)
{
try
{
Management.BeginTransaction();
Management.CreateAssetremovedetail(info);
Management.Commit();
}
catch
{
Management.Rollback();
throw;
}
return info;
}
public Assetremovedetail CreateAssetremovedetail(Assetremovedetail info)
{
try
{
string sqlCommand = @"INSERT INTO ""ASSETREMOVEDETAIL"" (""DETAILID"",""ASSETREMOVEID"",""ASSETNO"",""PLANREMOVEDATE"",""ACTUALREMOVEDATE"",""REMOVEDCONTENT"") VALUES (:Detailid,:Assetremoveid,:Assetno,:Planremovedate,:Actualremovedate,:Removedcontent)";
this.Database.AddInParameter(":Detailid", info.Detailid);//DBType:VARCHAR2
this.Database.AddInParameter(":Assetremoveid", info.Assetremoveid);//DBType:VARCHAR2
this.Database.AddInParameter(":Assetno", info.Assetno);//DBType:VARCHAR2
this.Database.AddInParameter(":Planremovedate", info.Planremovedate);//DBType:DATE
this.Database.AddInParameter(":Actualremovedate", info.Actualremovedate);//DBType:DATE
this.Database.AddInParameter(":Removedcontent", info.Removedcontent);//DBType:NVARCHAR2
this.Database.ExecuteNonQuery(sqlCommand);
}
finally
{
this.Database.ClearParameter();
}
return info;
}
public Assetremovedetail UpdateAssetremovedetailByDetailid(Assetremovedetail info)
{
try
{
this.Database.AddInParameter(":Detailid", info.Detailid);//DBType:VARCHAR2
this.Database.AddInParameter(":Assetremoveid", info.Assetremoveid);//DBType:VARCHAR2
this.Database.AddInParameter(":Assetno", info.Assetno);//DBType:VARCHAR2
this.Database.AddInParameter(":Planremovedate", info.Planremovedate);//DBType:DATE
this.Database.AddInParameter(":Actualremovedate", info.Actualremovedate);//DBType:DATE
this.Database.AddInParameter(":Removedcontent", info.Removedcontent);//DBType:NVARCHAR2
string sqlCommand = @"UPDATE ""ASSETREMOVEDETAIL"" SET ""ASSETREMOVEID""=:Assetremoveid , ""ASSETNO""=:Assetno , ""PLANREMOVEDATE""=:Planremovedate , ""ACTUALREMOVEDATE""=:Actualremovedate , ""REMOVEDCONTENT""=:Removedcontent WHERE ""DETAILID""=:Detailid";
this.Database.ExecuteNonQuery(sqlCommand);
}
finally
{
this.Database.ClearParameter();
}
return info;
}
protected void ucSelectedMultiAssets_SelectAssetChange(object sender, EventArgs e)
{
if (ucSelectedMultiAssets.AssetIds.Count > 0)
{
//更新设备列表
var assetNos = new List<string>();
foreach (var assetNo in ucSelectedMultiAssets.AssetIds)
{
if (RemoveDetail.Where(p => p.Assetno == assetNo).Count() == 0) { assetNos.Add(assetNo); }
}
var assetInfos = AssetService.RetrieveAssetByAssetno(assetNos);
if (assetInfos.Count > 0)
{
foreach (var entity in assetInfos)
{
Assetremovedetail data = new Assetremovedetail();
data.Detailid = Guid.NewGuid().ToString("N");
data.Assetno = entity.Assetno;//设备编号
data.Assetcategoryid = entity.Assetcategoryid;//设备类别
data.Assetname = entity.Assetname;//设备名称
//data.Storage = entity.Storage;//存放地点
data.State = entity.State;//设备状态
//data.Depreciationyear = entity.Depreciationyear;//折旧年限
data.Unitprice = entity.Unitprice;//单价
data.Brand = entity.Brand;//品牌
//data.Managemode = entity.Managemode;//管理模式，托管:0自管:1
data.Financecategory = entity.Financecategory;//财务类别(A帐:0B帐:1)
//data.Supplierid = entity.Supplierid;//供应商
data.Purchasedate = entity.Purchasedate;//购入日期
//data.Expireddate = entity.Expireddate;//折旧到期日期
//data.Assetspecification = entity.Assetspecification;//设备规格
//data.Storageflag = entity.Storageflag;//存放地点标识来源
//data.Subcompany = entity.Subcompany;//分公司
//data.Contractid = entity.Contractid;//合同编号
//data.Contractdetailid = entity.Contractdetailid;//合同明细编号
RemoveDetail.Add(data);
}
BindDetails();
}
}
}