public ActionResult Get(int id)
{
if (id <= 0)
{
return(Json(new ResultModel(string.Format("{0}不存在", this.ModelName))));
}
CorpBillBLL dal = new CorpBillBLL();
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));
}
// GET: Send
public ActionResult SendEmail(int id)
{
if (id <= 0)
{
return(Json(new ResultModel(string.Format("账单不存在"))));
}
CorpBillBLL dal = new CorpBillBLL();
ResultModel result = dal.Get(id);
if (result.ResultStatus != 0)
{
return(Json(result));
}
CorpBill rtnCorpBill = result.ReturnValue as CorpBill;
if (rtnCorpBill == null)
{
return(Json(new ResultModel(string.Format("账单不存在"))));
}
string[] To = { "*****@*****.**" };
string Subject = "账单" + rtnCorpBill.BillDate.ToString("yyyyMMdd");
string Body = "客户您好，当月账单费用为：" + rtnCorpBill.TotalAmount;
SendMail.Send(To, Subject, Body);
result = new ResultModel();
result.ResultStatus = 0;
result.Message = "发送成功";
return(Json(result));
}
// GET: CorpBill
public ActionResult CorpBillAdd()
{
int id = 0;
if (string.IsNullOrEmpty(Request.QueryString["id"]) || !int.TryParse(Request.QueryString["id"], out id) || id <= 0)
{
return(Content(JsUtility.WarmAlert("客户不存在", redirectUrl)));
}
CorpBillBLL corpBillBLL = new CorpBillBLL();
ResultModel <CorpBill> corpBillResult = corpBillBLL.LoadCorpBills(id);
if (corpBillResult.ResultStatus != 0)
{
return(Json(ResultModel.GenericResult <CorpBill>(corpBillResult)));
}
List <CorpBill> rtnCorpBill = corpBillResult.ReturnValues;
if (rtnCorpBill == null)
{
return(Json(new ResultModel("获取账单列表失败")));
}
int corpBillCount = rtnCorpBill.Count();
if (corpBillCount > 0)
{
return(Content(JsUtility.WarmAlert("客户本月账单已生成", redirectUrl)));
}
ResultModel result = corpBillBLL.LoadCorpEmployeeList(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 corpBillId)
{
switch (orderField)
{
case "EmpSalaryId":
orderField = "emps.EmpSalaryId";
break;
}
string orderStr = string.Format("{0} {1}", orderField, sortOrder);
CorpBillBLL corpbillBLL = new CorpBillBLL();
ResultModel result = corpbillBLL.LoadEmployeeSalaryByIdList(0, 500, orderStr, corpBillId);
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(CorpBill corpBill, CorpBillDetail[] details)
{
corpBill.CorpBillStatus = (int)StatusEnum.已完成;
//string json = Newtonsoft.Json.JsonConvert.SerializeObject(employee);
CorpBillBLL corpBillBLL = new CorpBillBLL();
CorpBillDetailBLL detailBLL = new CorpBillDetailBLL();
//获取企业账单
ResultModel <CorpBill> corpBillResult = corpBillBLL.LoadCorpBills(corpBill.CorpId);
if (corpBillResult.ResultStatus != 0)
{
return(Json(new ResultModel("获取账单列表失败")));
}
List <CorpBill> rtnCorpBill = corpBillResult.ReturnValues;
if (rtnCorpBill == null)
{
return(Json(new ResultModel("获取账单列表失败")));
}
int corpBillCount = rtnCorpBill.Count();
if (corpBillCount > 0)
{
return(Content(JsUtility.WarmAlert("客户本月账单已生成", redirectUrl)));
}
//新增账单
ResultModel result = corpBillBLL.Insert(corpBill);
if (result.ResultStatus != 0)
{
return(Json(result));
}
int corpBillId = 0;
if (result.ReturnValue == null || !int.TryParse(result.ReturnValue.ToString(), out corpBillId) || corpBillId <= 0)
{
return(Content("账单新增失败"));
}
//新增制单明细
foreach (CorpBillDetail detail in details)
{
detail.CorpBillId = corpBillId;
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));
}
