611 lines
20 KiB
C#
611 lines
20 KiB
C#
using dccdc.BLL;
|
|
using dccdc.code;
|
|
using dccdc.Models;
|
|
using System;
|
|
using System.Collections.Generic;
|
|
using System.Linq;
|
|
using System.Web;
|
|
using System.Web.Mvc;
|
|
using static dccdc.Controllers.DictionariesController;
|
|
|
|
namespace dccdc.Controllers
|
|
{
|
|
public class JfJkxxController : Controller
|
|
{
|
|
// GET: JfJkxx
|
|
public ActionResult Index()
|
|
{
|
|
return View();
|
|
}
|
|
|
|
public ActionResult JfJkxxlb()
|
|
{
|
|
return View();
|
|
}
|
|
|
|
[HttpGet]
|
|
public ActionResult EditJfJkxx(String id)
|
|
{
|
|
if (id != "")
|
|
{
|
|
var bll = new dccdc.BLL.JfJkxxBll();
|
|
var viewModel = new dccdc.Models.JfJkxx();
|
|
viewModel.id = Convert.ToInt32(id);
|
|
viewModel = bll.getJfJkxxOne(viewModel);
|
|
return View(viewModel);
|
|
}
|
|
else
|
|
{
|
|
var viewModel = new dccdc.Models.JfJkxx();
|
|
ERPUser user = Session["loginUser"] as Models.ERPUser;
|
|
viewModel.jkrxm = user.TrueName;
|
|
viewModel.jkrid = user.ID;
|
|
viewModel.ksid = user.ksid;
|
|
viewModel.jkbm = user.Department;
|
|
|
|
return View(viewModel);
|
|
}
|
|
}
|
|
|
|
|
|
[HttpPost]
|
|
public ActionResult EditJfJkxx(JfJkxx model)
|
|
{
|
|
var bll = new dccdc.BLL.JfJkxxBll();
|
|
|
|
bool f;
|
|
try
|
|
{
|
|
if (model.id != 0)
|
|
{
|
|
JfJkxx info = bll.getJfJkxxOne(model);
|
|
|
|
info.zt = model.zt;
|
|
info.jkrid = model.jkrid;
|
|
info.jkrxm = model.jkrxm;
|
|
info.jkbm = model.jkbm;
|
|
info.bz = model.bz;
|
|
info.jkyy = model.jkyy;
|
|
info.jkje = model.jkje;
|
|
f = bll.updJfJkxx(info);
|
|
}
|
|
else
|
|
{
|
|
ERPUser user = Session["loginUser"] as Models.ERPUser;
|
|
String str = new dccdc.BLL.JfGwjdglBll().getckkdh("sqdid", "jf_jkxx");
|
|
|
|
f = bll.addJfJkxx(model);
|
|
}
|
|
return Json(f ? new { State = 1, Message = "操作成功！" } : new { State = 0, Message = "操作失败,请确认！" });
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
return Json(new { State = 0, Message = ex.Message });
|
|
}
|
|
}
|
|
|
|
public JsonResult delJfJKXX(String id)
|
|
{
|
|
JfJkxx jfJkxx = new JfJkxx();
|
|
jfJkxx.id = Convert.ToInt32(id);
|
|
var bll = new JfJkxxBll();
|
|
JfJkxx delinfo = bll.getJfJkxxOne(jfJkxx);
|
|
try
|
|
{
|
|
bool f = bll.delJfJkxx(delinfo);
|
|
return Json(f ? new { State = 1, Message = "操作成功！" } : new { State = 0, Message = "操作失败,请确认！" });
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
return Json(new { State = 0, Message = ex.Message });
|
|
}
|
|
|
|
}
|
|
|
|
public JsonResult getJfJkxx(int page, int pagesize, string key, string sqsj, string zt)
|
|
{
|
|
var bll = new JfJkxxBll();
|
|
JfJkxx jfJkxx = new JfJkxx();
|
|
ERPUser user = Session["loginUser"] as Models.ERPUser;
|
|
// jfJkxx.ksid = Convert.ToInt32(user.ksid);
|
|
//jfsjfwwxgl.sqsj = Convert.ToDateTime(sqsj);
|
|
//jfsjfwwxgl.zt = zt;
|
|
jfJkxx.jkrid = user.ID;
|
|
List<JfJkxx> ctList = bll.getJfJkxx(jfJkxx, page, pagesize);
|
|
|
|
int count = bll.countJfJkxx(jfJkxx);
|
|
return Json(new { Total = count, Rows = ctList });
|
|
}
|
|
#region choose User
|
|
//----erp
|
|
public ActionResult Chooseuserview()
|
|
{
|
|
return View();
|
|
}
|
|
|
|
public JsonResult getERPuser(int page, int pagesize, string key)
|
|
{
|
|
var bll = new JfJkxxBll();
|
|
JfJkxx jfJkxx = new JfJkxx();
|
|
ERPUser user = new Models.ERPUser();
|
|
|
|
List<ERPUser> ctList = bll.getuserlist(key, page, pagesize);
|
|
|
|
int count = bll.countuserlist(key);
|
|
return Json(new { Total = count, Rows = ctList });
|
|
}
|
|
#endregion
|
|
|
|
#region choose借款单
|
|
public ActionResult ChooseJKXXview()
|
|
{
|
|
return View();
|
|
}
|
|
public JsonResult GetJfJkxxbyxm(int page, int pagesize, string key)
|
|
{
|
|
var bll = new JfJkxxBll();
|
|
List<JfJkxx> ctList = bll.GetJfJkxxbyxm(key, page, pagesize);
|
|
|
|
int count = bll.countJfJkxxbyxm(key);
|
|
return Json(new { Total = count, Rows = ctList });
|
|
}
|
|
|
|
|
|
|
|
|
|
#endregion
|
|
|
|
#region
|
|
public ActionResult ChooseBXDView()
|
|
{
|
|
List<Droplist> ztD = new List<Droplist>()
|
|
{ new Droplist { Value = "1", Title = "出差报销单" },
|
|
new Droplist { Value = "2", Title = "其他报销单" }
|
|
};
|
|
ViewBag.ztD = new SelectList(ztD, "value", "title");
|
|
ViewData["ztlist"] = new SelectList(ztD, "value", "title");
|
|
return View();
|
|
}
|
|
|
|
public JsonResult getbxd(int page, int pagesize, string bxtypeval, string sqr)
|
|
{
|
|
if ("1"== bxtypeval)//---出差
|
|
{
|
|
string where = " ZT = 5 ";
|
|
if (!string.IsNullOrEmpty(sqr))
|
|
{
|
|
where += " AND sqr like '%"+sqr.Trim()+"%'";
|
|
}
|
|
|
|
var bll = new BLL.sqccbxBll();
|
|
int count = bll.getCountLevel(where);
|
|
var models = bll.getPageLevel(page, pagesize, where);
|
|
return Json(new { Total = count, Rows = models });
|
|
}
|
|
else//----其他
|
|
{
|
|
string where = " ZT = 5 ";
|
|
if (!string.IsNullOrEmpty(sqr))
|
|
{
|
|
where += " AND sqr like '%" + sqr.Trim() + "%'";
|
|
}
|
|
|
|
var bll = new BLL.sqqtbxBll();
|
|
int count = bll.getCountLevel(where);
|
|
var models = bll.getPageLevel(page, pagesize, where);
|
|
return Json(new { Total = count, Rows = models });
|
|
}
|
|
}
|
|
#endregion
|
|
|
|
#region 款项支付
|
|
|
|
public ActionResult JfKxzflb()
|
|
{
|
|
return View();
|
|
}
|
|
|
|
[HttpGet]
|
|
public ActionResult EditJfKxzf(String id)
|
|
{
|
|
var list = new List<Droplist>() {
|
|
new Droplist { Value = "0", Title = "现金" },
|
|
new Droplist { Value = "1", Title = "银行卡" }
|
|
};
|
|
ViewData["zffsList"] = new SelectList(list, "value", "title");
|
|
if (id != "")
|
|
{
|
|
var bll = new dccdc.BLL.JfJkxxBll();
|
|
JfKxzf model = new JfKxzf();
|
|
model.id = Convert.ToInt32(id);
|
|
JfKxzf info = bll.getJfKxzfOne(model);
|
|
return View(info);
|
|
}
|
|
else
|
|
{
|
|
return View();
|
|
}
|
|
|
|
}
|
|
|
|
[HttpPost]
|
|
public ActionResult EditJfKxzf(JfKxzf model)
|
|
{
|
|
var bll = new dccdc.BLL.JfJkxxBll();
|
|
|
|
bool f;
|
|
try
|
|
{
|
|
if (model.id != 0)
|
|
{
|
|
JfKxzf info = bll.getJfKxzfOne(model);
|
|
|
|
f = bll.updJfKxzf(info);
|
|
}
|
|
else
|
|
{
|
|
ERPUser user = Session["loginUser"] as Models.ERPUser;
|
|
|
|
|
|
f = bll.addJfKxzf(model);
|
|
}
|
|
return Json(f ? new { State = 1, Message = "操作成功！" } : new { State = 0, Message = "操作失败,请确认！" });
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
return Json(new { State = 0, Message = ex.Message });
|
|
}
|
|
}
|
|
|
|
|
|
public JsonResult GetJfKxzf(int page, int pagesize, string key, string sqsj, string zt)
|
|
{
|
|
var bll = new JfJkxxBll();
|
|
JfKxzf jfKxzf = new JfKxzf();
|
|
ERPUser user = Session["loginUser"] as Models.ERPUser;
|
|
List<JfKxzf> ctList = bll.GetJfKxzf(jfKxzf, page, pagesize);
|
|
|
|
int count = bll.countJfKxzf(jfKxzf);
|
|
return Json(new { Total = count, Rows = ctList });
|
|
}
|
|
#endregion
|
|
|
|
|
|
#region 借款扣除
|
|
|
|
public ActionResult JfJkkclb()
|
|
{
|
|
return View();
|
|
}
|
|
|
|
[HttpGet]
|
|
public ActionResult EditJfJkkc(String id)
|
|
{
|
|
var list = new List<Droplist>() {
|
|
new Droplist { Value = "1", Title = "现金归还" },
|
|
new Droplist { Value = "0", Title = "报销抵扣" }
|
|
};
|
|
ViewData["jkkcfsList"] = new SelectList(list, "value", "title");
|
|
if (id != "")
|
|
{
|
|
var bll = new dccdc.BLL.JfJkxxBll();
|
|
JfJkkc model = new JfJkkc();
|
|
model.id = Convert.ToInt32(id);
|
|
JfJkkc info = bll.getJfJkkcOne(model);
|
|
return View(info);
|
|
}
|
|
else
|
|
{
|
|
return View();
|
|
}
|
|
}
|
|
|
|
[HttpPost]
|
|
public ActionResult EditJfJkkc(JfJkkc model)
|
|
{
|
|
var bll = new dccdc.BLL.JfJkxxBll();
|
|
|
|
bool f;
|
|
try
|
|
{
|
|
if (model.id != 0)
|
|
{
|
|
JfJkkc info = bll.getJfJkkcOne(model);
|
|
if (model.jkkcfs == "1")
|
|
{
|
|
info.jkkcfs = "1";
|
|
info.bxdid = null;
|
|
info.jkdid = null;
|
|
info.dkje = null;
|
|
|
|
info.ghr = model.ghr;
|
|
info.ghrid = model.ghrid;
|
|
info.ghje = model.ghje;
|
|
}
|
|
else
|
|
{
|
|
info.jkkcfs = "0";
|
|
info.ghrid = 0;
|
|
info.ghje = null;
|
|
|
|
info.bxdid = model.bxdid;
|
|
info.jkdid = model.jkdid;
|
|
info.dkje = model.dkje;
|
|
}
|
|
|
|
f = bll.updJfJkkc(info);
|
|
}
|
|
else
|
|
{
|
|
ERPUser user = Session["loginUser"] as Models.ERPUser;
|
|
if (model.jkkcfs == "1")
|
|
{
|
|
model.bxdid = null;
|
|
model.jkdid = null;
|
|
model.dkje = null;
|
|
}
|
|
else
|
|
{
|
|
model.ghr = null;
|
|
model.ghje = null;
|
|
}
|
|
|
|
f = bll.addJfJkkc(model);
|
|
}
|
|
return Json(f ? new { State = 1, Message = "操作成功！" } : new { State = 0, Message = "操作失败,请确认！" });
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
return Json(new { State = 0, Message = ex.Message });
|
|
}
|
|
}
|
|
|
|
public JsonResult GetJfJkkc(int page, int pagesize, string key, string sqsj, string zt)
|
|
{
|
|
var bll = new JfJkxxBll();
|
|
JfJkkc jfJkkc = new JfJkkc();
|
|
ERPUser user = Session["loginUser"] as Models.ERPUser;
|
|
List<JfJkkc> ctList = bll.GetJfJkkc(jfJkkc, page, pagesize);
|
|
|
|
int count = bll.countJfJkkc(jfJkkc);
|
|
return Json(new { Total = count, Rows = ctList });
|
|
}
|
|
|
|
#endregion
|
|
|
|
|
|
#region 审批
|
|
[HttpGet]
|
|
public ActionResult BLjfJkxx(String id)
|
|
{
|
|
var bll = new dccdc.BLL.JfJkxxBll();
|
|
var viewModel = new dccdc.Models.JfJkxx();
|
|
viewModel.id = Convert.ToInt32(id);
|
|
viewModel = bll.getJfJkxxOne(viewModel);
|
|
|
|
ERPUser user = Session["loginUser"] as Models.ERPUser;
|
|
String[] qx = user.ZhiWei.Split(',');
|
|
if (qx.Contains(ContextUtils.KSLD_QX) && viewModel.zt == "1")
|
|
{
|
|
ViewBag.ksldqx = "0";
|
|
|
|
ViewBag.fgldqx = "1";
|
|
ViewBag.cwldqx = "1";
|
|
ViewBag.zxldqx = "1";
|
|
}
|
|
else if (qx.Contains(ContextUtils.FGLD_QX) && viewModel.zt == "2")
|
|
{
|
|
ViewBag.ksldqx = "1";
|
|
ViewBag.cwldqx = "1";
|
|
ViewBag.zxldqx = "1";
|
|
|
|
ViewBag.fgldqx = "0";
|
|
}
|
|
else if (qx.Contains(ContextUtils.CWLD_QX) && viewModel.zt == "3")
|
|
{
|
|
ViewBag.ksldqx = "1";
|
|
ViewBag.fgldqx = "1";
|
|
ViewBag.zxldqx = "1";
|
|
|
|
ViewBag.cwldqx = "0";
|
|
}
|
|
else if (qx.Contains(ContextUtils.ZXLD_QX) && viewModel.zt == "4")
|
|
{
|
|
ViewBag.ksldqx = "1";
|
|
ViewBag.fgldqx = "1";
|
|
ViewBag.cwldqx = "1";
|
|
|
|
ViewBag.zxldqx = "0";
|
|
}
|
|
return View(viewModel);
|
|
}
|
|
|
|
[HttpPost]
|
|
public ActionResult BLjfJkxx(dccdc.Models.JfJkxx model)
|
|
{
|
|
var bll = new dccdc.BLL.JfJkxxBll();
|
|
var info = bll.getJfJkxxOne(model);
|
|
ERPUser user = Session["loginUser"] as Models.ERPUser;
|
|
String[] qx = user.ZhiWei.Split(',');
|
|
|
|
|
|
var modelinfo = new sqshModel();
|
|
modelinfo.type = "借款信息"; //添加 查询与添加一致就行
|
|
modelinfo.sqid = Convert.ToInt32(info.id);
|
|
modelinfo.spr = user.TrueName;
|
|
modelinfo.sptime = DateTime.Now;
|
|
if (qx.Contains(ContextUtils.KSLD_QX) &&info.zt=="1")
|
|
{
|
|
info.ksldspsj = DateTime.Today;
|
|
info.ksldspyj = model.ksldspyj;
|
|
if (model.zt == "1")//--同意
|
|
{
|
|
info.zt = "2";
|
|
}
|
|
else
|
|
{
|
|
info.zt = "1";
|
|
}
|
|
modelinfo.spnr = model.ksldspyj;
|
|
}
|
|
else if (qx.Contains(ContextUtils.FGLD_QX) && info.zt == "2")
|
|
{
|
|
info.fgldspyj = model.fgldspyj;
|
|
info.fgldspsj = DateTime.Today;
|
|
if (model.zt == "1")//--同意
|
|
{
|
|
info.zt = "3";
|
|
}
|
|
else
|
|
{
|
|
info.zt = "1";
|
|
}
|
|
modelinfo.spnr = model.fgldspyj;
|
|
}
|
|
|
|
else if (qx.Contains(ContextUtils.CWLD_QX) && info.zt == "3")
|
|
{
|
|
info.cwfzspyj = model.cwfzspyj;
|
|
info.cwfzspsj = DateTime.Today;
|
|
if (model.zt == "1")//--同意
|
|
{
|
|
info.zt = "4";
|
|
}
|
|
else
|
|
{
|
|
info.zt = "1";
|
|
}
|
|
modelinfo.spnr = model.cwfzspyj;
|
|
|
|
}
|
|
else if (qx.Contains(ContextUtils.ZXLD_QX) && info.zt == "4")
|
|
{
|
|
info.zxldspyj = model.zxldspyj;
|
|
info.zxldspsj = DateTime.Today;
|
|
if (model.zt == "1")//--同意
|
|
{
|
|
info.zt = "5";
|
|
}
|
|
else
|
|
{
|
|
info.zt = "1";
|
|
}
|
|
modelinfo.spnr = model.zxldspyj;
|
|
}
|
|
try
|
|
{
|
|
bool f = bll.updJfJkxx(info);
|
|
modelinfo.zt = (model.zt == "1") ? "通过" : "不通过";
|
|
new BLL.sqshBll().Add(modelinfo);
|
|
return Json(f ? new { State = 1, Message = "操作成功！" } : new { State = 0, Message = "操作失败,请确认！" });
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
return Json(new { State = 0, Message = ex.Message });
|
|
}
|
|
}
|
|
public ActionResult SPjfJkxx()
|
|
{
|
|
return View();
|
|
}
|
|
|
|
|
|
public JsonResult getjfJkxxsp(int page, int pagesize, string key, string sqsj, string zt)
|
|
{
|
|
var bll = new JfJkxxBll();
|
|
JfJkxx jfjkxx = new JfJkxx();
|
|
ERPUser user = Session["loginUser"] as Models.ERPUser;
|
|
String[] qx = user.ZhiWei.Split(',');
|
|
string ksidstr = ContextUtils.getChildrenKsid(user.ksid);
|
|
List<String> list = ContextUtils.getChildrenZT(qx);
|
|
string str = "";
|
|
if (list != null && list.Count > 0)
|
|
{
|
|
|
|
str = " AND (";
|
|
for (int i = 0; i < list.Count; i++)
|
|
{
|
|
if (i != 0)
|
|
{
|
|
str += " OR";
|
|
}
|
|
if ("1" == list[i])
|
|
{
|
|
str += " (KSID = " + user.ksid + " AND ZT =1)";
|
|
}
|
|
else if ("2" == list[i])
|
|
{
|
|
str += " (KSID IN " + ksidstr + " AND ZT =2)";
|
|
}
|
|
else if ("3" == list[i])
|
|
{
|
|
str += " (ZT =3)";
|
|
}
|
|
else if ("4" == list[i])
|
|
{
|
|
str += " (KSID IN " + ksidstr + " AND ZT =4)";
|
|
}
|
|
}
|
|
str += ")";
|
|
}
|
|
List<JfJkxx> ctList = bll.getspJfJkxx(ksidstr, str, page, pagesize);
|
|
|
|
int count = bll.countspJfJkxx(ksidstr, str);
|
|
return Json(new { Total = count, Rows = ctList });
|
|
}
|
|
#endregion
|
|
|
|
#region 查询申请单
|
|
|
|
public ActionResult jfjkxxsqdcx()
|
|
{
|
|
var list = new List<Droplist>() { new Droplist { Value = "1", Title = "科室领导审批" },
|
|
|
|
new Droplist { Value = "2", Title = "分管领导审批" },
|
|
new Droplist { Value = "3", Title = "财务领导审批" },
|
|
new Droplist { Value = "4", Title = "中心领导审批" },
|
|
new Droplist { Value = "5", Title = "通过" },
|
|
new Droplist { Value = "0", Title = "申请" }
|
|
};
|
|
ViewData["ztlist"] = new SelectList(list, "value", "title");
|
|
return View();
|
|
}
|
|
|
|
public JsonResult getjfjkxxsqd(int page, int pagesize, string key, string sqsj, string zt)
|
|
{
|
|
var bll = new JfJkxxBll();
|
|
JfJkxx jfjkxx = new JfJkxx();
|
|
ERPUser user = Session["loginUser"] as Models.ERPUser;
|
|
if(key!=null&&key!="")
|
|
jfjkxx.jkbm = key;
|
|
if (sqsj != null && sqsj != "")
|
|
jfjkxx.jkrq = Convert.ToDateTime(sqsj);
|
|
if (zt != null && zt != "")
|
|
jfjkxx.zt = zt;
|
|
List<JfJkxx> ctList = bll.getJfJkxx(jfjkxx, page, pagesize);
|
|
|
|
int count = bll.countJfJkxx(jfjkxx);
|
|
return Json(new { Total = count, Rows = ctList });
|
|
}
|
|
#endregion
|
|
|
|
|
|
#region 打印
|
|
[AllowAnonymous]
|
|
public string jkxxdy(string id)
|
|
{
|
|
if (string.IsNullOrEmpty(id))
|
|
return "";
|
|
var bll = new dccdc.BLL.JfJkxxBll();
|
|
var viewModel = new dccdc.Models.JfJkxx();
|
|
viewModel.id = Convert.ToInt32(id);
|
|
viewModel = bll.getJfJkxxOne(viewModel);
|
|
|
|
viewModel.bz = Charge3Controller.MoneyToUpper(viewModel.jkje.ToString());
|
|
List<JfJkxx> list = new List<JfJkxx>();
|
|
list.Add(viewModel);
|
|
return Newtonsoft.Json.JsonConvert.SerializeObject(list);
|
|
}
|
|
#endregion
|
|
}
|
|
} |