public ActionResult Get(int id)
{
if (id <= 0)
{
return(Json(new ResultModel(string.Format("{0}不存在", this.ModelName))));
}
SupBillBLL dal = new SupBillBLL();
ResultModel result = dal.Get(id);
if (result.ResultStatus != 0)
{
return(Json(result));
}
object rtnObj = result.ReturnValue;
if (rtnObj == null)
{
return(Json(new ResultModel(string.Format("{0}不存在", this.ModelName))));
}
result.ResultStatus = 0;
result.Message = string.Format("{0}获取成功", this.ModelName);
result.ReturnValue = Newtonsoft.Json.JsonConvert.SerializeObject(rtnObj);
return(Json(result));
}
public ActionResult SupBillAdd()
{
int id = 0;
if (string.IsNullOrEmpty(Request.QueryString["id"]) || !int.TryParse(Request.QueryString["id"], out id) || id <= 0)
{
return(Content(JsUtility.WarmAlert("供应商不存在", redirectUrl)));
}
SupBillBLL supBillBLL = new SupBillBLL();
ResultModel <SupBill> supBillResult = supBillBLL.LoadSupBills(id);
if (supBillResult.ResultStatus != 0)
{
return(Json(ResultModel.GenericResult <SupBill>(supBillResult)));
}
List <SupBill> rtnSupBill = supBillResult.ReturnValues;
if (rtnSupBill == null)
{
return(Json(new ResultModel("获取账单列表失败")));
}
int supBillCount = rtnSupBill.Count();
if (supBillCount > 0)
{
return(Content(JsUtility.WarmAlert("供应商本月账单已生成", redirectUrl)));
}
ResultModel result = supBillBLL.LoadSupEmployeeList(0, 500, null, id);
if (result.ResultStatus != 0)
{
return(Content(JsUtility.WarmAlert("获取错误", redirectUrl)));
}
System.Data.DataTable dt = result.ReturnValue as System.Data.DataTable;
if (dt == null)
{
return(Content(JsUtility.WarmAlert("获取错误", redirectUrl)));
}
string optJsonStr = Newtonsoft.Json.JsonConvert.SerializeObject(dt, new Newtonsoft.Json.Converters.DataTableConverter());
ViewData["JsonOptData"] = optJsonStr;
return(View());
}
public ActionResult LoadEmployeeSalaryByIdList(int pageIndex, int pageSize, string orderField, string sortOrder, int supBillId)
{
switch (orderField)
{
case "EmpSalaryId":
orderField = "emps.EmpSalaryId";
break;
}
string orderStr = string.Format("{0} {1}", orderField, sortOrder);
SupBillBLL supbillBLL = new SupBillBLL();
ResultModel result = supbillBLL.LoadEmployeeSalaryByIdList(0, 500, orderStr, supBillId);
System.Data.DataTable dt = result.ReturnValue as System.Data.DataTable;
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("count", result.AffectCount);
dic.Add("data", dt);
string jsonStr = Newtonsoft.Json.JsonConvert.SerializeObject(dic, new Newtonsoft.Json.Converters.DataTableConverter());
result.ReturnValue = jsonStr;
return(Json(result));
}
public ActionResult Insert(SupBill supBill, SupBillDetail[] details)
{
supBill.SupBillStatus = (int)StatusEnum.已完成;
//string json = Newtonsoft.Json.JsonConvert.SerializeObject(employee);
SupBillBLL supBillBLL = new SupBillBLL();
SupBillDetailBLL detailBLL = new SupBillDetailBLL();
//获取企业账单
ResultModel <SupBill> supBillResult = supBillBLL.LoadSupBills(supBill.SupId);
if (supBillResult.ResultStatus != 0)
{
return(Json(ResultModel.GenericResult <SupBill>(supBillResult)));
}
List <SupBill> rtnSupBill = supBillResult.ReturnValues;
if (rtnSupBill == null)
{
return(Json(new ResultModel("获取账单列表失败")));
}
int supBillCount = rtnSupBill.Count();
if (supBillCount > 0)
{
return(Content(JsUtility.WarmAlert("供应商本月账单已生成", redirectUrl)));
}
//新增账单
ResultModel result = supBillBLL.Insert(supBill);
if (result.ResultStatus != 0)
{
return(Json(result));
}
int supBillId = 0;
if (result.ReturnValue == null || !int.TryParse(result.ReturnValue.ToString(), out supBillId) || supBillId <= 0)
{
return(Content("账单新增失败"));
}
//新增制单明细
foreach (SupBillDetail detail in details)
{
detail.SupBillId = supBillId;
detail.DetailStatus = (int)StatusEnum.已完成;
result = detailBLL.Insert(detail);
if (result.ResultStatus != 0)
{
return(Json(result));
}
}
result.Message = "账单新增成功";
result.ReturnValue = "";
result.ResultStatus = 0;
return(Json(result));
}
