/// <summary>
/// 审核待审核记录
/// </summary>
/// <param name="auditId"></param>
/// <returns></returns>
public static bool AuditOperBalanceInfo(int auditId, string operUserId,bool status, out string message)
{
message = "";
bool retFlag = false;
using (AccountDataSourceDataContext adsdc = new AccountDataSourceDataContext())
{
DbTransaction tran = adsdc.Connection.BeginTransaction();
Base_t_AccountAuditInfo baai = new Base_t_AccountAuditInfo();
Base_t_AccountInfo bai = new Base_t_AccountInfo();
baai = adsdc.Base_t_AccountAuditInfo.FirstOrDefault(p => p.id == auditId);
try
{
//审核待审核记录
if (baai != null)
{
//如果流水记如存在，则根据流水记录中的账户ID取账户信息
bai = adsdc.Base_t_AccountInfo.FirstOrDefault(p => p.id == baai.accountId);
baai.status = true;
baai.opUser = operUserId;
baai.opTime = DateTime.Now;
adsdc.SubmitChanges();
retFlag = true;
}
//审核成功，插入操作记录到流水记录表
if (retFlag)
{
string mess = "";
Base_t_AccountDetailEntity bade = new Base_t_AccountDetailEntity();
PublicFunction.ObjectCopyTo(baai, bade);
//自动赋值后，处理各别不同的属性值
bade.Id = 0;
bade.Orderid = baai.refId;
bade.Resume = baai.direction;
bade.UseBalance = (decimal)baai.opBalance;
if (baai.type == 0)
bade.EndBalance = (decimal)bai.balance + (decimal)baai.opBalance;
else
bade.EndBalance = (decimal)bai.balance - (decimal)baai.opBalance;
InsertOperBalanceInfo(bade, out mess);
message = mess;
}
tran.Commit();
}
catch(Exception ex)
{
tran.Rollback();
message = ex.Message;
retFlag = false;
}
}
return retFlag;
}
partial void DeleteBase_t_AccountAuditInfo(Base_t_AccountAuditInfo instance);
partial void UpdateBase_t_AccountAuditInfo(Base_t_AccountAuditInfo instance);
partial void InsertBase_t_AccountAuditInfo(Base_t_AccountAuditInfo instance);
/// <summary>
/// 查询待审核账户余额申请记录
/// </summary>
/// <param name="auditId"></param>
/// <returns></returns>
public static Base_t_AccountAuditInfoEntity SelectAccountAuditInfo(int auditId)
{
using (AccountDataSourceDataContext adsdc = new AccountDataSourceDataContext())
{
Base_t_AccountAuditInfo baai = new Base_t_AccountAuditInfo();
Base_t_AccountAuditInfoEntity baaie = new Base_t_AccountAuditInfoEntity();
baai = adsdc.Base_t_AccountAuditInfo.FirstOrDefault(p => p.id == auditId);
if (baai != null)
{
PublicFunction.ObjectCopyTo(baai, baaie);
}
else
return null;
return baaie;
}
}
/// <summary>
/// 新增待审核操作账户余额信息
/// </summary>
/// <param name="baaie"></param>
/// <param name="message"></param>
/// <returns></returns>
public static bool InsertAuditOperBalanceInfo(Base_t_AccountAuditInfoEntity baaie, out string message)
{
bool retFlag = false;
Base_t_AccountAuditInfo baai = new Base_t_AccountAuditInfo();
//进行实体转换
if(baaie != null)
PublicFunction.ObjectCopyTo(baaie, baai);
AccountDataSourceDataContext adsdc = new AccountDataSourceDataContext();
try
{
if (baai != null)
{
adsdc.Base_t_AccountAuditInfo.InsertOnSubmit(baai);
adsdc.SubmitChanges();
}
retFlag = true;
message = "新增待审核信息成功";
//返回账户ID
}
catch (Exception ex)
{
retFlag = false;
message = ex.Message;
}
return retFlag;
}
