public int DeleteCharge(string sysno) { CustomDataCommand command = DataCommandManager.CreateCustomDataCommandFromConfig("DeleteCharge"); command.CommandText = command.CommandText.Replace("#SysNo#", sysno); int result = command.ExecuteNonQuery(); if (result > 0) { FilesDataAccess fda = new FilesDataAccess(); fda.DeleteFilesByFSysNos(sysno); } return result; }
public int UpdateCharge(ChargeEntity entity) { CustomDataCommand command = DataCommandManager.CreateCustomDataCommandFromConfig("UpdateCharge"); command.SetParameterValue("@SysNo", entity.SysNo); command.SetParameterValue("@Title", entity.Title); command.SetParameterValue("@Remark", entity.Remark); command.SetParameterValue("@Content", entity.Content); command.SetParameterValue("@Field1", entity.Field1); command.SetParameterValue("@Field2", entity.Field2); command.SetParameterValue("@Field3", entity.Field3); command.SetParameterValue("@Field4", entity.Field4); command.SetParameterValue("@Field5", entity.Field5); command.SetParameterValue("@Status", entity.Status); command.SetParameterValue("@InUser", entity.InUser); command.SetParameterValue("@InDate", entity.InDate); int result = command.ExecuteNonQuery(); if (result > 0) { FilesDataAccess fda = new FilesDataAccess(); fda.DeleteFilesByFSysNo(entity.SysNo); entity.Files.ForEach(x => { new FilesDataAccess().InsertFiles(x); }); } return result; }