public IActionResult Index()
{
//Initialize initialize = new Initialize();
var db = GlobalDBContext.Instance();
//var db = CashierSystem_Service.GlobalDBContext.Instance();
//db.Add(new QP.CashierSystem_Model.Navs { Pid = 0, Area = "System", Controller = "home", Action = "index", IsNavi = true, IsHiddenMethod = false, CreateDate = DateTime.Now });
//db.SaveChanges();
//db.Add(new QP.CashierSystem_Model.Navs { Pid = 1, Area = "System", Controller = "home", Action = "index", IsNavi = true, IsHiddenMethod = false, CreateDate = DateTime.Now });
//db.SaveChanges();
//生成树形菜单
//var list = CashierSystem_Service.GlobalDBContext.Instance().Navs.Where( n => n.Area == "system").ToList();
//var rst = QP.Cashier.Utility.Array2Tree.ToTree(list);
//调用写好的类，序列化成JSON格式
Cliet clite = new Cliet();
JieDian root = new JieDian();
//root.Name = "根节点";
//root.Id = 0;
var list = new List <JieDian>();
clite.creatTheTree("0", root, out list); //根节点的parentBh值为"0"
string json = Newtonsoft.Json.JsonConvert.SerializeObject(list);
return(Json(json));
}
/// <summary>
/// 动态生成表格的数据
/// </summary>
/// <param name="page"></param>
/// <param name="rows"></param>
/// <returns></returns>
public JsonResult GetRoles(int?page, int?rows)
{
page = page == null ? 1 : page; //第几页
rows = rows == null ? 10 : rows; //行数
var db = GlobalDBContext.Instance();
var json = db.Staffs.Join(db.Operations, a => a.OperationID, b => b.OperationID, (a, b) => new
{
a.StaffBirth,
a.StaffBirthType,
a.StaffEntryTime,
a.StaffIdentity,
a.StaffName,
a.StaffPhone,
a.StaffSex,
a.AcrossTheStore,
a.StaffDuty,
b.StaffCreateTime,
b.StaffCreator,
b.StaffUpdateTime,
b.StaffModifyUser
}).OrderBy(p => p.StaffName).Skip(Convert.ToInt32(rows) * Convert.ToInt32(page) - 1).Take(Convert.ToInt32(rows));
//DataGridJson obj = new DataGridJson();
//obj.rows = json;
//obj.total = db.Staffs.Count();
return(Json(json));
}
public IActionResult Index()
{
var db = GlobalDBContext.Instance();
Dictionary <string, string> keyValues = new Dictionary <string, string>();
foreach (var item in db.Shops)
{
keyValues.Add(item.ShopID, item.ShopName);
}
ViewData["SelectShop"] = new SelectList(keyValues, "Key", "Value");
return(View());
}
public IActionResult LeftNav(string id)
{
var DbContext = GlobalDBContext.Instance();
Cliet clite = new Cliet();
JieDian root = new JieDian();
root.Name = "根节点";
root.Id = 0;
var list = new List <JieDian>();
clite.creatTheTree(id, root, out list); //根节点的parentBh值为"0"
string json = Newtonsoft.Json.JsonConvert.SerializeObject(list);
return(Json(json));
}
//根据parentId获取相应的子目录集合
public Item[] GetTheItems(string parentId)
{
var db = GlobalDBContext.Instance();
var dr = db.Navs.Where(u => u.Parentid == parentId);
List <Item> items = new System.Collections.Generic.List <Item>();
foreach (var item in dr)
{
Item i = new Item();
i.Id = int.Parse(item.Id);
i.Name = item.NavName;
i.IocCss = item.IcoCss;
i.ParentId = int.Parse(item.Parentid);
//i.ContentText = item.Descrition;
items.Add(i);
}
return(items.ToArray());
}
public IActionResult Index([Bind("StaffName,StaffSex,StaffBirthType,StaffPhone,StaffBirth,StaffIdentity,JobNumber,Password,StaffDuty,StaffEntryTime,ShopID")] Staffs staffs)
{
var db = GlobalDBContext.Instance();
Random sj = new Random();
/// 用户登陆过后加入 操作人的信息
staffs.Roleds = "测试老板";
staffs.AuthorityID = sj.Next(1000, 10000).ToString();
staffs.StaffID = Guid.NewGuid().ToString();
staffs.WagesID = sj.Next(1000, 10000).ToString();
staffs.OperationID = sj.Next(1000, 10000).ToString();
HelpStaffs helpStaffs = new HelpStaffs();
var json = helpStaffs.AddEntity(staffs);
return(Json(true));
}
/// <summary>
/// 分页查询数据
/// </summary>
/// <param name="infoparam"></param>
/// <param name="export"></param>
/// <returns></returns>
public dynamic Contaion(IHostingEnvironment _hostingEnvironment, StaffInfoparam infoparam, string export)
{
var db = GlobalDBContext.Instance();
string QueryfieldName = infoparam._queryName;
DateTime startDate = infoparam._startDate;
DateTime endDate = infoparam._endDate;
var Rowset = (from S in db.Staffs
join O in db.Operations on S.OperationID equals O.OperationID
orderby S.StaffID
select new
{
ShopID = S.ShopID,
AuthorityID = S.AuthorityID,
StaffBirth = S.StaffBirth,
StaffBirthType = S.StaffBirthType,
StaffEntryTime = S.StaffEntryTime,
StaffIdentity = S.StaffIdentity,
StaffName = S.StaffName,
StaffPhone = S.StaffPhone,
StaffSex = S.StaffSex,
AcrossTheStore = S.AcrossTheStore,
StaffDuty = S.StaffDuty,
StaffCreateTime = O.StaffCreateTime,
StaffCreator = O.StaffCreator,
StaffUpdateTime = O.StaffUpdateTime,
StaffModifyUser = O.StaffModifyUser
});
///按照时间筛选
if (!string.IsNullOrEmpty(infoparam._queryName) && !infoparam._endDate.ToString().StartsWith("0") && !infoparam._startDate.ToString().StartsWith("0"))
{
switch (QueryfieldName)
{
case "StaffBirth":
Rowset.Where(S => S.StaffBirth >= startDate && S.StaffBirth <= endDate);
break;
case "StaffEntryTime":
Rowset.Where(S => S.StaffEntryTime >= startDate && S.StaffEntryTime <= endDate);
break;
case "StaffCreateTime":
Rowset.Where(S => S.StaffCreateTime >= startDate && S.StaffCreateTime <= endDate);
break;
case "StaffUpdateTime":
Rowset.Where(S => S.StaffUpdateTime >= startDate && S.StaffUpdateTime <= endDate);
break;
}
}
//按照用户输入筛选
if (!string.IsNullOrEmpty(infoparam._selectVal) && !string.IsNullOrEmpty(infoparam._inputVals))
{
switch (infoparam._selectVal)
{
case "StaffSex":
Rowset.Where(S => S.StaffSex.ToString().Contains(infoparam._inputVals));
break;
case "StaffDuty":
Rowset.Where(S => S.StaffDuty.ToString().Contains(infoparam._inputVals));
break;
case "StaffIdentity":
Rowset.Where(S => S.StaffIdentity.ToString().Contains(infoparam._inputVals));
break;
case "StaffPhone":
Rowset.Where(S => S.StaffPhone.ToString().Contains(infoparam._inputVals));
break;
case "StaffName":
Rowset.Where(S => S.StaffName.ToString().Contains(infoparam._inputVals));
break;
case "StaffBirth":
Rowset.Where(S => S.StaffBirth.ToString().Contains(infoparam._inputVals));
break;
case "StaffEntryTime":
Rowset.Where(S => S.StaffEntryTime.ToString().Contains(infoparam._inputVals));
break;
case "StaffCreateTime":
Rowset.Where(S => S.StaffCreateTime.ToString().Contains(infoparam._inputVals));
break;
case "StaffUpdateTime":
Rowset.Where(S => S.StaffUpdateTime.ToString().Contains(infoparam._inputVals));
break;
}
}
// 按门店查询
if (!string.IsNullOrEmpty(infoparam._shopID))
{
Rowset.Where(u => u.ShopID == infoparam._shopID);
}
///导出报表
if (export != "")
{
DataTable table = new DataTable();//创建表
List <string> Columns = new List <string>()
{
"姓名", "性别", "职位", "生日类型", "生日", "身份证", "手机", "是否跨店", "入职时间", "创建时间", "创建人", "修改时间", "修改用户"
};
table = CreateTable.ReturnColuns(table, Columns);
foreach (var item in Rowset)
{
table.Rows.Add(new object[] { item.StaffName, item.StaffSex, item.StaffDuty, item.StaffBirthType, item.StaffBirth, item.StaffIdentity, item.StaffPhone, item.AcrossTheStore, item.StaffEntryTime, item.StaffCreateTime, item.StaffCreator, item.StaffUpdateTime, item.StaffModifyUser });
}
infoparam._fileName = ExportExecl.CrateExecl(_hostingEnvironment, table);
}
infoparam._total = Rowset.Count();
return(Rowset.OrderBy(p => p.AuthorityID).Skip(Convert.ToInt32(infoparam._rows) * Convert.ToInt32(infoparam._page) - 1).Take(Convert.ToInt32(infoparam._rows)));
}