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));
}