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