ClaimsettlementController
目录
1、 ClaimsettlementController
1.1、 删除三包表
1.2、 查询单据付款状态
1.3、 查询付款数据
using QXQPS.Models;
using QXQPS.Vo;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
namespace QXQPS.Areas.MechanicsManagment.Controllers
{
public class ClaimsettlementController : Controller
{
// GET: MechanicsManagment/Claimsettlement
Models.QXQPEntities myModels = new Models.QXQPEntities();
public ActionResult DelectThreePacks(int ThreePacksID)//删除三包表
{
try
{
var list = myModels.PW_ThreePacks.Where(m => m.ThreePacksID == ThreePacksID).Single();
myModels.PW_ThreePacks.Remove(list);
myModels.SaveChanges();
}
catch (Exception)
{
return Json(false, JsonRequestBehavior.AllowGet);
}
return Json(true, JsonRequestBehavior.AllowGet);
}
public ActionResult SelectBalance(string BusinessNum)//查询单据付款状态
{
ReturnJson returnJson = new ReturnJson();
try
{
var list = myModels.PW_Balance.Where(m => m.BusinessNum == BusinessNum).SingleOrDefault();
if (list != null)
{
if (list.BalanceStateID == 1)
{
returnJson.State = false;
returnJson.Text = "您和该用户没有付款信息，或你们往来账已平衡！";
returnJson.ObjData = "该单已有付款记录，不能反审核，如要更改费用，请到财务管理客户费用中进行平衡处理。";
}
else if (list.BalanceStateID == 2)
{
returnJson.State = true;
returnJson.States = "A";
returnJson.Text = list.BalanceID.ToString();
returnJson.ObjData = "该单已有付款记录，不能反审核，如要更改费用，请到财务管理客户费用中进行平衡处理。";
}
}
else {
returnJson.State = true;
}
}
catch (Exception)
{
returnJson.State = false;
returnJson.Text = "数据异常!";
}
return Json(returnJson, JsonRequestBehavior.AllowGet);
}
public ActionResult SelectBalances(int BalanceID)//查询付款数据
{
try
{
var list = myModels.PW_Balance.Where(m => m.BalanceID == BalanceID).SingleOrDefault();
return Json(list, JsonRequestBehavior.AllowGet);
}
catch (Exception)
{
return Json(false, JsonRequestBehavior.AllowGet);
}
}