public IQueryable GetSCZZdanju(out int totalCount)
{
int pageIndex = Request["page"] != null ? Request["page"].ToString().Trim().Length <= 0?1:int.Parse(Request["page"]) : 1;
int pageSize = Request["rows"] != null?int.Parse(Request["rows"]) : 10;
int zt = Request["zt"] == null?0: Request["zt"].ToString().Trim().Length <= 0?0: int.Parse(Request["zt"]);
var actioninfolist = T_SczzDanjuService.LoadPageEntities <DateTime?>(pageIndex, pageSize, out totalCount, a => a.del == 0 && a.ZhuangTai == zt, a => a.AddTime, false);
//根据LoginUser.Umoney 判断浏览权限
if (LoginUser.QuXian == 0)
{
actioninfolist = T_SczzDanjuService.LoadPageEntities <DateTime?>(pageIndex, pageSize, out totalCount, a => a.del == 0 && a.ZhuangTai == zt, a => a.AddTime, false);
}
else if (LoginUser.QuXian == 3)
{
if (zt < 2)
{
actioninfolist = T_SczzDanjuService.LoadPageEntities <DateTime?>(pageIndex, pageSize, out totalCount, a => a.del == 0 && a.ZhuangTai == zt && a.UpShenHe == null, a => a.AddTime, false);
}
else if (zt == 2)
{
actioninfolist = T_SczzDanjuService.LoadPageEntities <DateTime?>(pageIndex, pageSize, out totalCount, a => a.del == 0 && a.ZhuangTai == zt, a => a.AddTime, false);
}
else
{
actioninfolist = T_SczzDanjuService.LoadPageEntities <DateTime?>(pageIndex, pageSize, out totalCount, a => a.del == 0 && a.UpShenHe == LoginUser.ID && a.ZhuangTai != 2, a => a.AddTime, false);
}
}
else if (LoginUser.QuXian == 4)
{
if (zt < 2)
{
actioninfolist = T_SczzDanjuService.LoadPageEntities <DateTime?>(pageIndex, pageSize, out totalCount, a => a.del == 0 && a.ZhuangTai == zt && a.CheJianShenHe == null, a => a.AddTime, false);
}
else if (zt == 2)
{
actioninfolist = T_SczzDanjuService.LoadPageEntities <DateTime?>(pageIndex, pageSize, out totalCount, a => a.del == 0 && a.ZhuangTai == zt, a => a.AddTime, false);
}
else
{
actioninfolist = T_SczzDanjuService.LoadPageEntities <DateTime?>(pageIndex, pageSize, out totalCount, a => a.del == 0 && a.CheJianShenHe == LoginUser.ID && a.ZhuangTai != 2, a => a.AddTime, false);
}
}
var temp = from a in actioninfolist
select new
{
ID = a.ID,
text = a.T_ShengChanZhiZhaoTopName.TopText,
time = a.AddTime,
Zhuangtai = a.ZhuangTai
};
return(temp);
}
//返回计划创建人员
public ActionResult AddUser()
{
var temp = T_SczzDanjuService.LoadEntities(x => x.del == 0);
var tem = from a in temp
select new
{
MyTexts = a.UserInfo.PerSonName,
ID = a.AddUser
};
var tem_sd = tem.Distinct();
return(Json(tem_sd, JsonRequestBehavior.AllowGet));
}
//创建详细数据
public ActionResult AddTableone()
{
T_CanPan tcp = new T_CanPan();
var thisID = Request["ID"].ToString().Trim().Length <= 0 ? 0 : Convert.ToInt64(Request["ID"]);
if (thisID == 0)
{
tcp.SczzDanjuID = Convert.ToInt64(Request["TextNameID"]);
var tscdj = T_SczzDanjuService.LoadEntities(x => x.ID == tcp.SczzDanjuID).FirstOrDefault();
if (tscdj == null)
{
return(Json(new { result = "no", msg = "数据错误请联系管理员" }, JsonRequestBehavior.AllowGet));
}
else if (tscdj.ZhuangTai != 0)
{
return(Json(new { result = "no", msg = "已审核的信息不可在次添加信息！" }, JsonRequestBehavior.AllowGet));
}
tcp.Cpname = Request["Cpname"];
tcp.ImageInt = Request["ImageInt"];
if (Request["CpShuliang"].ToString().Trim().Length <= 0)
{
return(Json(new { result = "no", msg = "数量不可为空" }, JsonRequestBehavior.AllowGet));
}
tcp.CpShuliang = Convert.ToDecimal(Request["CpShuliang"]);
tcp.SczzItemID = Convert.ToInt64(Request["SczzItemID"]);
tcp.Bak = Request["Bak"];
tcp.DEL = 0;
tcp.AddTime = MvcApplication.GetT_time();
tcp.AddUserID = LoginUser.ID;
if (Request["overtime"] == null && Request["overtime"].ToString().Trim().Length == 0)
{
return(Json(new { result = "no", msg = "完工时间不可为空！" }, JsonRequestBehavior.AllowGet));
}
if (Request["overtime"] != null && Request["overtime"].ToString().Trim().Length > 0)
{
tcp.OverTime = Convert.ToDateTime(Request["overtime"]);
tcp.OverUserID = LoginUser.ID;
}
T_CanPanService.AddEntity(tcp);
var temp = HuoquXLS((long)tcp.SczzDanjuID);
return(Json(new { result = "ok", temp = temp }, JsonRequestBehavior.AllowGet));
}
else
{
T_CanPanService.EditEntity(tcp);
return(Json(new { result = false, ex = "" }, JsonRequestBehavior.AllowGet));
}
}
//创建制造计划单
public ActionResult AddTable()
{
T_SczzDanju tsd = new T_SczzDanju();
tsd.TextNameID = Convert.ToInt64(Request["topnameid"]);
tsd.AddTime = MvcApplication.GetT_time();
tsd.ZhuangTai = 0;
tsd.AddUser = LoginUser.ID;
tsd.del = 0;
T_SczzDanjuService.AddEntity(tsd);
int totalCount = 0;
var temp = GetSCZZdanju(out totalCount);
return(Json(new { result = true, temp = temp, total = totalCount }, JsonRequestBehavior.AllowGet));
}
//获取信息列表
public ActionResult GetHref()
{
int pageIndex = Request["page"] != null ? Request["page"].ToString().Trim().Length <= 0?1: int.Parse(Request["page"]) : 1;
int pageSize = Request["rows"] != null?int.Parse(Request["rows"]) : 10;
string MyColums = Request["MyColums"];
int totalCount;
if (MyColums == "CPlist")
{
var actioninfolist = T_SczzDanjuService.LoadPageEntities <DateTime?>(pageIndex, pageSize, out totalCount, a => a.AddUser == LoginUser.ID && a.del != 1, a => a.AddTime, false);
var temp = from a in actioninfolist
select new
{
};
return(Json(new { rows = temp, total = totalCount }, JsonRequestBehavior.AllowGet));
}
else
if (MyColums == "CPxinghao")//规格型号
{
var actioninfolist = T_SczzItemService.LoadPageEntities <DateTime?>(pageIndex, pageSize, out totalCount, a => a.Del != 1, a => a.AddTime, false);
var temp = from a in actioninfolist
select new
{
a.ID,
a.AddTime,
a.Text
};
return(Json(new { rows = temp, total = totalCount }, JsonRequestBehavior.AllowGet));
}
if (MyColums == "JiHuaName")//单据
{
var actioninfolist = T_ShengChanZhiZhaoTopNameService.LoadPageEntities <DateTime?>(pageIndex, pageSize, out totalCount, a => a.Del != 1, a => a.addtime, false);
var temp = from a in actioninfolist
select new
{
a.ID,
a.TopText,
a.addtime
};
return(Json(new { rows = temp, total = totalCount }, JsonRequestBehavior.AllowGet));
}
return(Json(null, JsonRequestBehavior.AllowGet));
}
//获取详细数据信息
public ActionResult DanjuXiangXi()
{
var id = Convert.ToInt64(Request["id"]);
var tdj = T_SczzDanjuService.LoadEntities(x => x.ID == id && x.del == 0).DefaultIfEmpty();
var dj = from a in tdj
select new
{
ID = a.ID,
textname = a.T_ShengChanZhiZhaoTopName.TopText,
zhuangtai = a.ZhuangTai,
jhtcr = a.UserInfo.PerSonName,
sccjr = a.UserInfo3.PerSonName,
jhzdr = a.UserInfo2.PerSonName,
jhpzr = a.UserInfo4.PerSonName,
jgcj = a.UserInfo1.PerSonName,
panduan = a.UserInfo.QuXian == 0 ? LoginUser.QuXian == 0?false: true : false
};
if (tdj == null)
{
return(Json(new { ret = "ison" }, JsonRequestBehavior.AllowGet));
}
else
{
var temolist = from a in tdj.FirstOrDefault().T_CanPan
where a.DEL == 0
select new
{
ID = a.ID,
Text = a.T_SczzItem.Text,
Cpname = a.Cpname,
CpShuliang = a.CpShuliang,
ImageInt = a.ImageInt,
AddTime = a.AddTime,
OverTime = a.OverTime,
Bak = a.Bak
};
temolist = temolist.OrderByDescending(x => x.AddTime);
return(Json(new { ret = "ok", temp = temolist, fristtp = dj }, JsonRequestBehavior.AllowGet));
}
}
//删除单据显示信息 丢到垃圾回收站
public ActionResult DelDanjiu()
{
var id = Convert.ToInt64(Request["delid"]);
var edittemp = T_SczzDanjuService.LoadEntities(x => x.ID == id && x.AddUser == LoginUser.ID).FirstOrDefault();
if (edittemp.ZhuangTai != 0)
{
return(Json(new { ret = "no", tmp = "已经审核信息不可删除！" }, JsonRequestBehavior.AllowGet));
}
edittemp.del = 1;
if (T_SczzDanjuService.EditEntity(edittemp))
{
return(Json(new { ret = "ok", tmp = "" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { ret = "no", tmp = "操作未成功！" }, JsonRequestBehavior.AllowGet));
}
}
//返回查看详细列表
public ActionResult GetOne()
{
var id = int.Parse(Request["id"]);
var tmp = T_SczzDanjuService.LoadEntities(x => x.ID == id && x.del == 0);
var temp = Fromnew(tmp);
var Schanpin = tmp.FirstOrDefault().T_CanPan.Where(x => x.DEL == 0);
var chanpin = from a in Schanpin
select new {
ID = a.ID,
Cpname = a.Cpname,
CpShuliang = a.CpShuliang,
SczzItem = a.T_SczzItem.Text,
OverTime = a.OverTime,
Bak = a.Bak,
ImageInt = a.ImageInt
};
return(Json(new { temp = temp, chanpin = chanpin }, JsonRequestBehavior.AllowGet));
}
public ActionResult getdata()
{
int pageIndex = Request["page"] != null?int.Parse(Request["page"]) : 1;
int pageSize = Request["rows"] != null?int.Parse(Request["rows"]) : 25;
UserInfoParam uim = new UserInfoParam();
uim.Uptime = Convert.ToDateTime(Request["UpTime"]);
uim.Dwtime = Convert.ToDateTime(Request["DwTime"]);
uim.Jhname = Request["Jhname"] == null ? 0 : Request["Jhname"].Length <= 0 ? 0 : int.Parse(Request["Jhname"]);
uim.adduser = Request["addUser"] == null ? 0 : Request["addUser"].Length <= 0 ? 0 : int.Parse(Request["addUser"]);
uim.SHuser = Request["SHuser"] == null ? 0 : Request["SHuser"].Length <= 0 ? 0 : int.Parse(Request["SHuser"]);
uim.CPtext = Request["CPtext"] == null ? 0 : Request["CPtext"].Length <= 0 ? 0 : int.Parse(Request["CPtext"]);
uim.zt = Request["shzt"] == null ? 0 : Request["shzt"].Length <= 0 ? -1 : int.Parse(Request["shzt"]);
uim.PageIndex = pageIndex;
uim.PageSize = pageSize;
uim.TotalCount = 0;
var temp = T_SczzDanjuService.LoadSearchEntities(uim);
var Rtemp = Fromnew(temp);
return(Json(new { rows = Rtemp, total = uim.TotalCount }, JsonRequestBehavior.AllowGet));
}
//审核操作方法
public ActionResult ShenHe()
{
var id = int.Parse(Request["shid"]);
var temp = T_SczzDanjuService.LoadEntities(x => x.ID == id && x.del == 0).FirstOrDefault();
if (temp == null)
{
return(Json(new { ret = "no", tmp = "数据库无你要审核的信息，数据ID错误" }, JsonRequestBehavior.AllowGet));
}
else
{
if (LoginUser.QuXian == 0)
{
#region MyRegion
if (temp.ShenChanShenHe != null)
{
return(Json(new { ret = "no", tmp = "已审核！不可重复审核！" }, JsonRequestBehavior.AllowGet));
}
temp.ShenChanShenHe = LoginUser.ID;
temp.ShenChanShenHetime = MvcApplication.GetT_time();
//判断 所有人员是否已经审核
if (ShiFuAllShenhe(temp))
{
temp.ZhuangTai = 2;
}
if (T_SczzDanjuService.EditEntity(temp))
{
return(Json(new { ret = "ok", tmp = "" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { ret = "no", tmp = "审核失败" }, JsonRequestBehavior.AllowGet));
}
#endregion
}
else
if (LoginUser.QuXian == 1)
{
#region MyRegion
if (temp.Jhzdr != null)
{
return(Json(new { ret = "no", tmp = "已审核！不可重复审核！" }, JsonRequestBehavior.AllowGet));
}
if (temp.T_CanPan.Where(x => x.DEL == 0).All(x => x.OverTime != null))
{
temp.Jhzdr = LoginUser.ID;
temp.JhzdrTime = MvcApplication.GetT_time();
temp.TextNameID = 2;
temp.ZhuangTai = 1;
if (T_SczzDanjuService.EditEntity(temp))
{
return(Json(new { ret = "ok", tmp = "" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { ret = "no", tmp = "审核失败" }, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json(new { ret = "no", tmp = "完工时间必须全部添加才可审核！" }, JsonRequestBehavior.AllowGet));
}
#endregion
}
else if (LoginUser.QuXian > 1)
{
if (LoginUser.QuXian == 3)
{
if (temp.UpShenHe != null)
{
return(Json(new { ret = "no", tmp = "已审核！不可重复审核！" }, JsonRequestBehavior.AllowGet));
}
temp.UpShenHe = LoginUser.ID;
temp.UPshenhetime = MvcApplication.GetT_time();
//判断 所有人员是否已经审核
if (ShiFuAllShenhe(temp))
{
temp.ZhuangTai = 2;
}
if (T_SczzDanjuService.EditEntity(temp))
{
return(Json(new { ret = "ok", tmp = "" }, JsonRequestBehavior.AllowGet));
}
}
else if (LoginUser.QuXian == 4)
{
if (temp.CheJianShenHe != null)
{
return(Json(new { ret = "no", tmp = "已审核！不可重复审核！" }, JsonRequestBehavior.AllowGet));
}
temp.CheJianShenHe = LoginUser.ID;
temp.CheJianShenHetime = MvcApplication.GetT_time();
//判断 所有人员是否已经审核
if (ShiFuAllShenhe(temp))
{
temp.ZhuangTai = 2;
}
if (T_SczzDanjuService.EditEntity(temp))
{
return(Json(new { ret = "ok", tmp = "" }, JsonRequestBehavior.AllowGet));
}
}
}
return(Json(new { ret = "no", tmp = "审核失败" }, JsonRequestBehavior.AllowGet));
}
}
