public ActionResult GetList(Pagination pagination) { var RoleId = OperatorProvider.Provider.GetCurrent().RoleId; var buyer = new RoleApp().GetKeyGridJson("采购员"); var clerk = new RoleApp().GetRoleUser("文员"); int type = 0; var list = projectApp.GetList(); if (buyer.Contains(RoleId)) { type = 2; } else if (clerk.Contains(RoleId)) { type = 1; } if (type != 0) { list = list.Where(t => t.F_Choose == type).ToList(); } pagination.records = list.Count(); list = list.OrderByDescending(q => q.F_Id).Skip((pagination.page - 1) * pagination.rows).Take(pagination.rows).ToList(); var data = new { rows = list, total = pagination.total, page = pagination.page, records = pagination.records }; return(Content(data.ToJson())); }
public ActionResult GetForm(string keyValue) { var flag = false; var query = new RoleApp().GetKeyGridJson("工程师"); var data = userApp.GetForm(keyValue); if (query.Contains(data.F_RoleId)) { flag = true; } return(Content(new { data = data, flag = flag }.ToJson())); }
public ActionResult CheckRole() { var roleType = 0; var RoleId = OperatorProvider.Provider.GetCurrent().RoleId; var buyer = new RoleApp().GetKeyGridJson("采购员"); var clerk = new RoleApp().GetRoleUser("文员"); if (buyer.Contains(RoleId)) { roleType = 2; } else if (clerk.Contains(RoleId)) { roleType = 1; } return(Json(roleType, JsonRequestBehavior.AllowGet)); }
public ActionResult ExportExcel() { var RoleId = OperatorProvider.Provider.GetCurrent().RoleId; var buyer = new RoleApp().GetKeyGridJson("采购员"); var clerk = new RoleApp().GetRoleUser("文员"); int type = 0; string sql = ""; StringBuilder sb = new StringBuilder(); if (buyer.Contains(RoleId)) { type = 2; sql = string.Format(@" SELECT F_ProjectEngineer '项目工程师', F_Customer '客户', F_Model '型号', F_Spc '名称规格', t.TypeName '类型', F_SampleQty '样板数量', F_OrderNo '订单号', F_OrderItem '立项单',(CASE F_Choose when 1 then '自制' when 2 then '外协' ELSE '' end) '自制/外协', F_Buyer '采购员', F_Supplier '供应商', CONVERT(varchar(100), F_SampleFinishDate, 23) '样板完成时间', F_FactFinishNum '实际完成数量',CONVERT(varchar(100), F_FactFinishDate, 23) '实际完成时间',F_BuyRemark '采购备注' FROM Sys_Project p LEFT JOIN Sys_Type t ON p.F_TypeID =t.ID "); } else if (clerk.Contains(RoleId)) { type = 1; sql = string.Format(@" SELECT F_ProjectEngineer '项目工程师', F_Customer '客户', F_Model '型号', F_Spc '名称规格', t.TypeName '类型', F_SampleQty '样板数量', F_OrderNo '订单号', F_OrderItem '立项单',(CASE F_Choose when 1 then '自制' when 2 then '外协' ELSE '' end) '自制/外协', F_Clerk '工程文员',F_Workshop '车间', CONVERT(varchar(100), F_SampleFinishDate, 23) '样板完成时间', F_FactFinishNum '实际完成数量',CONVERT(varchar(100), F_FactFinishDate, 23) '实际完成时间',F_BuyRemark '采购备注' FROM Sys_Project p LEFT JOIN Sys_Type t ON p.F_TypeID =t.ID "); } else { sql = string.Format(@" SELECT F_ProjectEngineer '项目工程师', F_Customer '客户', F_Model '型号', F_Spc '名称规格', t.TypeName '类型', F_SampleQty '样板数量', F_OrderNo '订单号', F_OrderItem '立项单',CONVERT(varchar(100), F_OrderItemDate, 23) '立项时间', CONVERT(varchar(100), F_PlanSendSampleDate, 23) '计划寄样时间',CONVERT(varchar(100), F_SampleReturnDate, 23) '样板回厂时间', F_Remark '备注', (CASE F_Choose when 1 then '自制' when 2 then '外协' ELSE '' end) '自制/外协',CONVERT (VARCHAR (100), F_FactSendSampleDate, 23) '实际寄样时间', F_SampleOnTime '样板准时', (CASE F_IsAudit when 'F' then '是' when 'F' then '否' ELSE '' end) '是否审批', F_AccuracyRate '样板准确率',CONVERT(varchar(100), F_AccuracyDate, 23) '样板批准时间', CONVERT(varchar(100), F_PublishDate, 23) '产品发布时间',(CASE F_SignSample when 'F' then '有' when 'F' then '无' ELSE '' end) '签板', F_ProjectRemark '审批备注' FROM Sys_Project p LEFT JOIN Sys_Type t ON p.F_TypeID =t.ID "); } sb.Append(sql); if (type != 0) { sb.Append("where F_Choose=" + type); } DataTable dt = new DataTable(); using (SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["XZOADbContext"].ConnectionString)) { conn.Open(); using (SqlCommand command = conn.CreateCommand()) { command.CommandText = sb.ToString(); using (SqlDataAdapter adp = new SqlDataAdapter(command)) { adp.Fill(dt); } } } string fileName = DateTime.Now.ToString("yyyy-MM-dd-HH-mm-ss") + ".xls"; var savePath = Path.Combine(HttpContext.Server.MapPath("/Excel/"), fileName); new XZOA.Code.Excel.NPOIExcel().Export(dt, fileName, savePath); return(Content(savePath)); }