public ActionResult SaveRecord(string keyValue, TwoTicketRecordEntity record)
{
try
{
threepeoplecheckbll.InsertRecord(record);
return(Success("操作成功"));
}
catch (Exception ex)
{
return(Error(ex.Message));
}
}
/// <summary>
/// 插入票据处理记录
/// </summary>
/// <param name="record">记录对象</param>
/// <param name="user">当前用户</param>
/// <returns></returns>
public int InsertRecord(TwoTicketRecordEntity record)
{
int count = 0;
var res = DbFactory.Base().BeginTrans();
try
{
res.ExecuteBySql(string.Format("delete from XLD_TWOTICKETRECORD where ticketId='{0}' and status='{1}'", record.TicketId, record.Status));
count = res.ExecuteBySql(string.Format(@"insert into XLD_TWOTICKETRECORD(id,hearuser,hearuserid,time,remark,createdate,createuser,createuserid,ticketid,status,IsCommit)
values('{0}','{1}','{2}',to_date('{3}','yyyy-mm-dd hh24:mi:ss'),'{4}',to_date('{5}','yyyy-mm-dd hh24:mi:ss'),'{6}','{7}','{8}','{9}','{10}')", Guid.NewGuid().ToString(), record.HearUser, record.HearUserId, record.Time, record.Remark, record.CreateDate, record.CreateUser, record.CreateUserId, record.TicketId, record.Status, record.IsCommit));
res.ExecuteBySql(string.Format("update XSS_TWOTICKETS set status='{0}' where id='{1}'", record.Status, record.TicketId));
res.Commit();
count = 1;
}
catch (Exception ex)
{
res.Rollback();
count = 0;
}
return(count);
}
/// <summary>
/// 插入票据处理记录
/// </summary>
/// <param name="record">记录对象</param>
/// <param name="user">当前用户</param>
/// <returns></returns>
public int InsertRecord(TwoTicketRecordEntity record)
{
return(service.InsertRecord(record));
}