/// <summary>
/// 生产订单信息
/// </summary>
/// <param name="pPlanStartDate">计划开工日期</param>
/// <param name="pFormId">业务标识</param>
/// <returns></returns>
public DataTable GetMo(string pPlanStartDate, Model.Enum.FormID pFormId)
{
string strOrg;
switch (pFormId)
{
case Model.Enum.FormID.PRD_PPBOM:
strOrg = "100508";
break;
case Model.Enum.FormID.PRD_PPBOM_DX:
strOrg = "492501088";
break;
default:
strOrg = "100508";
break;
}
_SQL = string.Format("SELECT DISTINCT MTL.FNUMBER 物料编码, MTLL.FNAME 物料名称, DEP.FNUMBER 部门编码, DEPL.FNAME 部门 ");
_SQL += string.Format(" FROM T_PRD_MO A ");
_SQL += string.Format(" INNER JOIN T_PRD_MOENTRY AE ON A.FID = AE.FID ");
_SQL += string.Format(" INNER JOIN T_PRD_MOENTRY_A AA ON AE.FENTRYID = AA.FENTRYID AND AA.FSTATUS IN({0}) ", strOrg == "100508" ? "3,4" : "4");
_SQL += string.Format(" INNER JOIN T_BD_DEPARTMENT DEP ON AE.FWORKSHOPID = DEP.FDEPTID ");
_SQL += string.Format(" INNER JOIN T_BD_DEPARTMENT_L DEPL ON DEP.FDEPTID = DEPL.FDEPTID AND DEPL.FLOCALEID = 2052 ");
_SQL += string.Format(" INNER JOIN T_PRD_PPBOMENTRY PBE ON AA.FENTRYID = PBE.FMOENTRYID ");
_SQL += string.Format(" INNER JOIN T_BD_MATERIAL MTL ON PBE.FMATERIALID = MTL.FMATERIALID AND MTL.FUSEORGID = {0} ", strOrg);
_SQL += string.Format(" INNER JOIN T_BD_MATERIAL_L MTLL ON MTL.FMATERIALID = MTLL.FMATERIALID AND MTLL.FLOCALEID = 2052 ");
_SQL += string.Format(" LEFT JOIN T_AUTO_MSTOCKSETTING MST ON MTL.FMATERIALID = MST.FMATERIALID AND DEP.FDEPTID = MST.FDEPTID ");
_SQL += string.Format(" WHERE (MST.FMATERIALID IS NULL OR MST.FSTOCKID IS NULL) AND A.FDOCUMENTSTATUS = 'C' AND A.FPRDORGID = {0} AND TO_CHAR(AE.FPLANSTARTDATE,'yyyy-mm-dd') = '{1}'", strOrg, pPlanStartDate);
return(ORAHelper.ExecuteTable(_SQL));
}
/// <summary>
/// 根据日期获取入库单编号
/// </summary>
/// <param name="pDateTime">日期</param>
/// <returns>DataTable</returns>
public DataTable GetInstockBillNo(DateTime pDateTime)
{
_SQL = string.Format("SELECT DISTINCT A.FBILLNO ");
_SQL += string.Format(" FROM T_PRD_INSTOCK A ");
_SQL += string.Format(" LEFT JOIN T_PRD_PICKMTRLDATA_A PICA ON A.FID = PICA.FSRCBIZINTERID ");
_SQL += string.Format(" WHERE TO_CHAR(A.FDATE, 'yyyy-MM-dd') >= '{0}' AND A.FDOCUMENTSTATUS = 'C' AND PICA.FSRCBIZBILLNO IS NULL", pDateTime.ToString("yyyy-MM-dd"));
return(ORAHelper.ExecuteTable(_SQL));
}