LXAPI.git - Gitblit

			@@ -264,7 +264,7 @@
			}
			if (operopendate != "" && operopendate != null)
			{
			search += "and A.lm_date between @operopendate and @operclosedate ";
			search += "and B.report_date between @operopendate and @operclosedate ";
			dynamicParams.Add("@operopendate", operopendate + " 00:00:00");
			dynamicParams.Add("@operclosedate", operclosedate + " 23:59:59");
			}
			@@ -276,13 +276,14 @@
			search = search.Substring(3);//截取索引2后面的字符
			// --------------查询指定数据--------------
			var total = 0; //总条数
			var sql = @"select distinct A.id,A.wo_code,M.partcode,M.partname,M.partspec,T.stepcode,T.stepname,A.task_qty,G.group_code,G.group_name,A.good_qty,isnull(S.unprice,0) as unprice,A.good_qty*isnull(S.unprice,0) as usermoney,U.username as lm_user,A.lm_date
			var sql = @"select distinct A.id,A.wo_code,M.partcode,M.partname,M.partspec,T.stepcode,T.stepname,A.task_qty,G.group_code,G.group_name,A.good_qty,
			isnull(S.unprice,0) as unprice,A.good_qty*isnull(S.unprice,0) as usermoney,U.username as lm_user,A.lm_date,B.report_date
			from TK_Wrk_Record A
			inner join TK_Wrk_RecordSub B on A.id=B.m_id
			inner join TK_Wrk_Step P on A.wo_code=P.wo_code and A.step_code=P.step_code and P.isend='Y'
			left join TK_Wrk_Man K on A.wo_code=K.wo_code
			left join TGroup G on B.usergroup_code=G.group_code
			left join TPrteEqp_Stad S on A.materiel_code=S.materiel_code and A.eqp_code=S.eqp_code and A.step_code=S.step_code and K.route_code=S.route_code and K.wkshp_code=S.wkspcode
			left join TWoPrteEqp_Stad S on A.wo_code=S.wo and A.materiel_code=S.materiel_code and A.eqp_code=S.eqp_code and A.step_code=S.step_code and K.route_code=S.route_code
			left join TMateriel_Info M on A.materiel_code=M.partcode
			left join TStep T on A.step_code=T.stepcode
			left join TUser U on A.lm_user=U.usercode
			@@ -376,7 +377,7 @@
			}
			if (operopendate != "" && operopendate != null)
			{
			search += "and A.lm_date between @operopendate and @operclosedate ";
			search += "and B.report_date between @operopendate and @operclosedate ";
			dynamicParams.Add("@operopendate", operopendate + " 00:00:00");
			dynamicParams.Add("@operclosedate", operclosedate + " 23:59:59");
			}
			@@ -390,13 +391,13 @@
			var total = 0; //总条数
			var sql = @"select distinct A.wo_code as 工单编号,M.partcode as 产品编码,M.partname as 产品名称,M.partspec as 产品规格,
			T.stepcode as 工序编码,T.stepname as 工序名称,A.task_qty as 任务数量,G.group_code as 班组编码,G.group_name as 班组名称,
			A.good_qty as 报工数量,isnull(S.unprice,0) as 工序单价,A.good_qty*isnull(S.unprice,0) as 计件工资,U.username as 操作人员,A.lm_date as 操作时间
			A.good_qty as 报工数量,isnull(S.unprice,0) as 工序单价,A.good_qty*isnull(S.unprice,0) as 计件工资,U.username as 操作人员,A.lm_date as 操作时间,B.report_date as 报工时间
			from TK_Wrk_Record A
			inner join TK_Wrk_RecordSub B on A.id=B.m_id
			inner join TK_Wrk_Step P on A.wo_code=P.wo_code and A.step_code=P.step_code and P.isend='Y'
			left join TK_Wrk_Man K on A.wo_code=K.wo_code
			left join TGroup G on B.usergroup_code=G.group_code
			left join TPrteEqp_Stad S on A.materiel_code=S.materiel_code and A.eqp_code=S.eqp_code and A.step_code=S.step_code and K.route_code=S.route_code and K.wkshp_code=S.wkspcode
			left join TWoPrteEqp_Stad S on A.wo_code=S.wo and A.materiel_code=S.materiel_code and A.eqp_code=S.eqp_code and A.step_code=S.step_code and K.route_code=S.route_code
			left join TMateriel_Info M on A.materiel_code=M.partcode
			left join TStep T on A.step_code=T.stepcode
			left join TUser U on A.lm_user=U.usercode
			@@ -435,28 +436,23 @@
			}
			if (partcode != "" && partcode != null)
			{
			search += "and M.partcode like '%'+@partcode+'%' ";
			search += "and A.partnumber like '%'+@partcode+'%' ";
			dynamicParams.Add("@partcode", partcode);
			}
			if (partname != "" && partname != null)
			{
			search += "and M.partname like '%'+@partname+'%' ";
			search += "and B.partname like '%'+@partname+'%' ";
			dynamicParams.Add("@partname", partname);
			}
			if (partspec != "" && partspec != null)
			{
			search += "and M.partspec like '%'+@partspec+'%' ";
			search += "and B.partspec like '%'+@partspec+'%' ";
			dynamicParams.Add("@partspec", partspec);
			}
			if (stepname != "" && stepname != null)
			{
			search += "and T.stepname like '%'+@stepname+'%' ";
			search += "and S.stepname like '%'+@stepname+'%' ";
			dynamicParams.Add("@stepname", stepname);
			}
			if (groupcode != "" && groupcode != null)
			{
			search += "and G.group_code=@groupcode ";
			dynamicParams.Add("@groupcode", groupcode);
			}
			if (reportname != "" && reportname != null)
			{
			@@ -465,7 +461,7 @@
			}
			if (reportopendate != "" && reportopendate != null)
			{
			search += "and B.report_date between @reportopendate and @reportclosedate ";
			search += "and A.report_date between @reportopendate and @reportclosedate ";
			dynamicParams.Add("@reportopendate", reportopendate + " 00:00:00");
			dynamicParams.Add("@reportclosedate", reportclosedate + " 23:59:59");
			}
			@@ -477,17 +473,24 @@
			search = search.Substring(3);//截取索引2后面的字符
			// --------------查询指定数据--------------
			var total = 0; //总条数
			var sql = @"select distinct A.wo_code,M.partcode,M.partname,M.partspec,T.stepcode,T.stepname,A.task_qty,G.group_code,G.group_name,B.report_qty,isnull(S.unprice,0) as unprice,B.report_qty*isnull(S.unprice,0) as usermoney,U.username as lm_user,B.report_date
			from TK_Wrk_Record A
			inner join TK_Wrk_RecordSub B on A.id=B.m_id
			inner join TK_Wrk_Step P on A.wo_code=P.wo_code and A.step_code=P.step_code and P.isend='Y'
			left join TK_Wrk_Man K on A.wo_code=K.wo_code
			left join TGroup G on B.usergroup_code=G.group_code
			left join TPrteEqp_Stad S on A.materiel_code=S.materiel_code and A.eqp_code=S.eqp_code and A.step_code=S.step_code and K.route_code=S.route_code and K.wkshp_code=S.wkspcode
			left join TMateriel_Info M on A.materiel_code=M.partcode
			left join TStep T on A.step_code=T.stepcode
			left join TUser U on B.report_person=U.usercode
			where " + search;
			//var sql = @"select distinct A.wo_code,M.partcode,M.partname,M.partspec,T.stepcode,T.stepname,
			// A.task_qty,B.report_qty,isnull(S.unprice,0) as unprice,
			// B.report_qty*isnull(S.unprice,0) as moneys,U.username,B.report_date
			// from TK_Wrk_Record A
			// inner join TK_Wrk_RecordSub B on A.id=B.m_id
			// inner join TK_Wrk_Step P on A.wo_code=P.wo_code and A.step_code=P.step_code
			// left join TK_Wrk_Man K on A.wo_code=K.wo_code
			// left join TPrteEqp_Stad S on A.materiel_code=S.materiel_code and A.eqp_code=S.eqp_code and A.step_code=S.step_code and K.route_code=S.route_code and K.wkshp_code=S.wkspcode
			// left join TMateriel_Info M on A.materiel_code=M.partcode
			// left join TStep T on A.step_code=T.stepcode
			// left join TUser U on B.report_person=U.usercode where" + search;
			var sql = @"select A.wo_code,A.partnumber as partcode,B.partname,B.partspec,S.stepcode,S.stepname,
			A.task_qty,A.report_qty,isnull(A.unprice,0) as unprice,
			A.report_qty*isnull(A.unprice,0)-isnull(A.bad_money,0) as moneys,U.username,A.report_date
			from TK_WorkRecord_Verify A
			left join TMateriel_Info B on A.partnumber=B.partcode
			left join TStep S on A.step_code=S.stepcode
			left join TUser U on A.usercode=U.usercode where "+search;
			var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
			mes.code = "200";
			mes.Message = "查询成功!";
			@@ -519,28 +522,23 @@
			}
			if (partcode != "" && partcode != null)
			{
			search += "and M.partcode like '%'+@partcode+'%' ";
			search += "and A.partnumber like '%'+@partcode+'%' ";
			dynamicParams.Add("@partcode", partcode);
			}
			if (partname != "" && partname != null)
			{
			search += "and M.partname like '%'+@partname+'%' ";
			search += "and B.partname like '%'+@partname+'%' ";
			dynamicParams.Add("@partname", partname);
			}
			if (partspec != "" && partspec != null)
			{
			search += "and M.partspec like '%'+@partspec+'%' ";
			search += "and B.partspec like '%'+@partspec+'%' ";
			dynamicParams.Add("@partspec", partspec);
			}
			if (stepname != "" && stepname != null)
			{
			search += "and T.stepname like '%'+@stepname+'%' ";
			search += "and S.stepname like '%'+@stepname+'%' ";
			dynamicParams.Add("@stepname", stepname);
			}
			if (groupcode != "" && groupcode != null)
			{
			search += "and G.group_code=@groupcode ";
			dynamicParams.Add("@groupcode", groupcode);
			}
			if (reportname != "" && reportname != null)
			{
			@@ -549,7 +547,7 @@
			}
			if (reportopendate != "" && reportopendate != null)
			{
			search += "and B.report_date between @reportopendate and @reportclosedate ";
			search += "and A.report_date between @reportopendate and @reportclosedate ";
			dynamicParams.Add("@reportopendate", reportopendate + " 00:00:00");
			dynamicParams.Add("@reportclosedate", reportclosedate + " 23:59:59");
			}
			@@ -561,19 +559,26 @@
			search = search.Substring(3);//截取索引2后面的字符
			// --------------查询指定数据--------------
			var total = 0; //总条数
			var sql = @"select distinct A.wo_code as 工单编号,M.partcode as 产品编码,M.partname as 产品名称,M.partspec as 产品规格,T.stepcode as 工序编码,T.stepname as 工序名称,
			A.task_qty as 任务数量,G.group_code as 生产班组编码,G.group_name as 生产班组名称,B.report_qty as 报工数量,isnull(S.unprice,0) as 工序单价,
			B.report_qty*isnull(S.unprice,0) as 计件工资,U.username as 报工人员,B.report_date as 报工时间
			from TK_Wrk_Record A
			inner join TK_Wrk_RecordSub B on A.id=B.m_id
			inner join TK_Wrk_Step P on A.wo_code=P.wo_code and A.step_code=P.step_code and P.isend='Y'
			left join TK_Wrk_Man K on A.wo_code=K.wo_code
			left join TGroup G on B.usergroup_code=G.group_code
			left join TPrteEqp_Stad S on A.materiel_code=S.materiel_code and A.eqp_code=S.eqp_code and A.step_code=S.step_code and K.route_code=S.route_code and K.wkshp_code=S.wkspcode
			left join TMateriel_Info M on A.materiel_code=M.partcode
			left join TStep T on A.step_code=T.stepcode
			left join TUser U on B.report_person=U.usercode
			where " + search;
			//var sql = @"select distinct A.wo_code as 工单编号,M.partcode as 产品编码,M.partname as 产品名称,M.partspec as 产品规格,T.stepcode as 工序编码,T.stepname as 工序名称,
			// A.task_qty as 任务数量,B.report_qty as 报工数量,isnull(S.unprice,0) as 工序单价,
			// B.report_qty*isnull(S.unprice,0) as 计件工资,U.username as 报工人员,B.report_date as 报工时间
			// from TK_Wrk_Record A
			// inner join TK_Wrk_RecordSub B on A.id=B.m_id
			// inner join TK_Wrk_Step P on A.wo_code=P.wo_code and A.step_code=P.step_code
			// left join TK_Wrk_Man K on A.wo_code=K.wo_code
			// left join TGroup G on B.usergroup_code=G.group_code
			// left join TPrteEqp_Stad S on A.materiel_code=S.materiel_code and A.eqp_code=S.eqp_code and A.step_code=S.step_code and K.route_code=S.route_code and K.wkshp_code=S.wkspcode
			// left join TMateriel_Info M on A.materiel_code=M.partcode
			// left join TStep T on A.step_code=T.stepcode
			// left join TUser U on B.report_person=U.usercode
			// where " + search;
			var sql = @"select A.wo_code as 工单编号,A.partnumber as 产品编码,B.partname as 产品名称,B.partspec as 产品规格,S.stepcode as 工序编码,S.stepname as 工序名称,
			A.task_qty as 任务数量,A.report_qty as 报工数量,isnull(A.unprice,0) as 工序单价,
			A.report_qty*isnull(A.unprice,0)-isnull(A.bad_money,0) as 计件工资,U.username as 报工人员,A.report_date as 报工时间
			from TK_WorkRecord_Verify A
			left join TMateriel_Info B on A.partnumber=B.partcode
			left join TStep S on A.step_code=S.stepcode
			left join TUser U on A.usercode=U.usercode where " + search;
			DataTable data = DapperHelper.selectdata(sql, dynamicParams);
			data.TableName = "Table"; //设置DataTable的名称
			string msg = DownLoad.DataTableToExcel(data, "人员工资明细报表");