public JsonResult GetQE_InfobyPerson()
{
int p_id = (Session["User"] as EquipModel.Entities.Person_Info).Person_Id;
List <object> r = new List <object>();
QEntranceManagment qem = new QEntranceManagment();
Quick_Entrance[] qe = new Quick_Entrance[8] {
null, null, null, null, null, null, null, null
};
List <Quick_Entrance> QE = new List <Quick_Entrance>();
QE = qem.GetQ_EbyP_Id(p_id);
foreach (var q in QE)
{
qe[q.xuhao - 1] = q;
}
for (int i = 0; i < 8; i++)
{
if (qe[i] == null)
{
object o = new
{
menuname = "",
menulink = "",
qe_id = i + 1
};
r.Add(o);
}
else
{
object o = new
{
menuname = qe[i].Menu.Menu_Name,
menulink = qe[i].Menu.Link_Url,
qe_id = qe[i].xuhao
};
r.Add(o);
}
}
return(Json(r.ToArray()));
}
public string Add(string json1)
{
try
{
JObject item = (JObject)JsonConvert.DeserializeObject(json1);
int person_id = Convert.ToInt16(item["user_Id"].ToString());
int menu_id = Convert.ToInt16(item["menu_Id"].ToString());
int q_id = Convert.ToInt16(item["q_Id"].ToString());
string datastring;
QEntranceManagment qem = new QEntranceManagment();
bool flag = qem.AddQ_Entrance(person_id, menu_id, q_id);
if (flag)
{
datastring = "添加成功";
}
else
{
datastring = "添加失败";
}
object r = new
{
backdata = datastring
};
string str = JsonConvert.SerializeObject(r);
return("{" + "\"data\": " + str + "}");
}
catch
{
object r = new
{
backdata = "添加失败"
};
string str = JsonConvert.SerializeObject(r);
return("{" + "\"data\": " + str + "}");
}
}
public ActionResult Home()
{
homemodel hm = new homemodel();
hm.userName = (Session["User"] as EquipModel.Entities.Person_Info).Person_Name.ToString();
hm.userId = (Session["User"] as EquipModel.Entities.Person_Info).Person_Id;
PersonManagment pm = new PersonManagment();
//string cj = pm.Get_Person_Cj(hm.userId).First().EA_Name;
string cj = "联合一车间";
EquipBLL.AdminManagment.PersonManagment.P_viewModal pv = pm.Get_PersonModal(hm.userId);
QEntranceManagment qem = new QEntranceManagment();
List <Quick_Entrance> qe = qem.GetQ_EbyP_Id(hm.userId);
hm.q_cunzai = new int[8] {
0, 0, 0, 0, 0, 0, 0, 0
};
if (qe != null)
{
foreach (var q in qe)
{
hm.q_cunzai[q.xuhao - 1] = 1;
}
}
//if (pv.Role_Names == "现场工程师")
if (pv.Role_Names.Contains("现场工程师"))
{
DateTime now = DateTime.Now;
DateTime LastThursday = now;
DateTime Day20 = now;
string a = now.DayOfWeek.ToString("d");
if (a == "1")
{
LastThursday = now.AddDays(-4).AddHours(-now.Hour).AddMinutes(-now.Minute).AddSeconds(-now.Second);
}
if (a == "2")
{
LastThursday = now.AddDays(-5).AddHours(-now.Hour).AddMinutes(-now.Minute).AddSeconds(-now.Second);
}
if (a == "3")
{
LastThursday = now.AddDays(-6).AddHours(-now.Hour).AddMinutes(-now.Minute).AddSeconds(-now.Second);
}
if (a == "4")
{
LastThursday = now.AddHours(-now.Hour).AddMinutes(-now.Minute).AddSeconds(-now.Second);
}
if (a == "5")
{
LastThursday = now.AddDays(-1).AddHours(-now.Hour).AddMinutes(-now.Minute).AddSeconds(-now.Second);
}
if (a == "6")
{
LastThursday = now.AddDays(-2).AddHours(-now.Hour).AddMinutes(-now.Minute).AddSeconds(-now.Second);
}
if (a == "0")
{
LastThursday = now.AddDays(-3).AddHours(-now.Hour).AddMinutes(-now.Minute).AddSeconds(-now.Second);
}
if (now.Day >= 20)
{
Day20 = now.AddDays(20 - now.Day).AddHours(-now.Hour).AddMinutes(-now.Minute).AddSeconds(-now.Second);
string query_list1 = "E.WE_Ser,R.time";
string query_condition1 = " P.Cj_Name ='" + cj + "' and E.W_Name='A6dot2' and M.Miss_Name ='Xc_Sample' ";
string record_filter1 = "Convert(datetime,time)>'" + Day20.ToString() + "' and Convert(datetime,time)<'" + now.ToString() + "'";
DataTable dt1 = CWFEngine.QueryAllInformation(query_list1, query_condition1, record_filter1);
if (dt1.Rows.Count != 0)
{
hm.A6dot2Isdone = "false";
}
else
{
hm.A6dot2Isdone = "true";
}
}
else
{
hm.A6dot2Isdone = "false";
}
string query_list = "E.WE_Ser,R.time";
string query_condition = " P.Cj_Name ='" + cj + "' and E.W_Name='A7dot1dot1'";
string record_filter = "Convert(datetime,time)>'" + LastThursday.ToString() + "' and Convert(datetime,time)<'" + now.ToString() + "'";
DataTable dt = CWFEngine.QueryAllInformation(query_list, query_condition, record_filter);
if (dt != null)
{
if (dt.Rows.Count != 0)
{
hm.A7dot1Isdone = "true";
}
else
{
hm.A7dot1Isdone = "false";
}
}
}
else
{
hm.A7dot1Isdone = "true";
}
//注：这里判断的是部门为设监中心的
if (pv.Department_Name.Contains("设监中心"))
{
DateTime now = DateTime.Now;
DateTime Day27 = now;
if (now.Day >= 27)
{
Day27 = now.AddDays(27 - now.Day).AddHours(-now.Hour).AddMinutes(-now.Minute).AddSeconds(-now.Second);
string query_list1 = "E.WE_Ser,R.time";
string query_condition1 = "E.W_Name='A6dot2' and M.Miss_Name ='Sj_Result' ";
string record_filter1 = "Convert(datetime,time)>'" + Day27.ToString() + "' and Convert(datetime,time)<'" + now.ToString() + "'";
DataTable dt1 = CWFEngine.QueryAllInformation(query_list1, query_condition1, record_filter1);
if (dt1.Rows.Count != 0)
{
hm.A6dot2SjFile = "false";
}
else
{
hm.A6dot2SjFile = "true";
}
}
else
{
hm.A6dot2SjFile = "false";
}
}
else
{
hm.A6dot2SjFile = "false";
}
return(View(hm));
}
