public void Delete(Modules.OA_Contract model)
{
dal.Initialization();
FineOffice.Entity.OA_Contract entity = new Entity.OA_Contract
{
ID = model.ID,
};
dal.Delete(entity);
dal.Dispose();
}
public override void Delete(Entity.OA_Contract entity)
{
List <CommandInfo> transation = new List <CommandInfo>();
SqlParameter[] attachmentParameter = { new SqlParameter("@ContractID", SqlDbType.Int, 4) };
attachmentParameter[0].Value = entity.ID;
CommandInfo attachmentInfo = new CommandInfo("delete from OA_Attachment where ContractID=@ContractID", attachmentParameter);
transation.Add(attachmentInfo);
SqlParameter[] deleteParam = { new SqlParameter("@ID", SqlDbType.Int, 4) };
deleteParam[0].Value = entity.ID;
CommandInfo deleteInfo = new CommandInfo("delete from OA_Contract where ID=@ID", deleteParam);
transation.Add(deleteInfo);
DbHelperSQL.ExecuteSqlTran(transation);
}
/// <summary>
/// 修改
/// </summary>
public FineOffice.Modules.OA_Contract Update(FineOffice.Modules.OA_Contract model)
{
dal.Initialization();
FineOffice.Entity.OA_Contract entity = new Entity.OA_Contract
{
ID = model.ID,
Content = model.Content,
ContractName = model.ContractName,
ContractNO = model.ContractNO,
EndDate = model.EndDate,
Handler = model.Handler,
Location = model.Location,
SingnDate = model.SingnDate,
TraderID = model.TraderID,
TypeID = model.TypeID,
Remark = model.Remark
};
dal.Update(entity);
dal.Dispose();
return(this.GetModel(l => l.ID == entity.ID));
}
