// public void OF_INSERT(DataRow dr) // { // Sql.ExecuteNonQuery("SAP", "INSERT INTO [dbo].[tbl_OF]" + // "([CD_OF]" + // ",[DT_PREV]" + // ",[CD_MAT]" + // ",[LB_MAT]" + // ",[QT_PREV]" + // ")" + //"VALUES" + // "('" + dr["CD_OF"].ToString() + // "','" + DateTime.Parse(dr["DT_PREV"].ToString(), CultureInfo.CreateSpecificCulture("en-GB")) + // "','" + dr["CD_MAT"].ToString() + // "','" + dr["LB_MAT"].ToString() + // "'," + dr["QT_PREV"] + // ")", CommandType.Text); // } public DataTable RMUsed_Report(string Prefix_RM) { DataTable dt = new DataTable(); dt = Oracle.ExecuteDataTable("select HISDOS.NO_LOT as NO_LOT,V1.DT_MVMT as DT_MVMT, V1.CD_LOTORG, V1.NO_LOTORG,V1.CD_MAT,V1.LB_MAT,V1.QT_PREV,V1.QT_MVMT,V1.CD_ZONE " + " from HISDOS, " + " ( " + " SELECT MOUVEMENT.CD_LOTDEST as CD_LOTDEST, " + " CASE WHEN MOUVEMENT.CD_ZONE = 'RM WHSE' THEN 'HT1' ELSE MOUVEMENT.CD_ZONE END as CD_ZONE, " + " MOUVEMENT.DT_MVMT as DT_MVMT, " + " MOUVEMENT.CD_LOTORG as CD_LOTORG, " + " MOUVEMENT.QT_PREV as QT_PREV, " + " MOUVEMENT.CD_MAT as CD_MAT, " + " MOUVEMENT.QT_MVMT as QT_MVMT, " + " MOUVEMENT.LB_MAT as LB_MAT, " + " HISTRANSLOTORG .NO_LOT as NO_LOT, " + " CASE " + " WHEN HISTRANSLOTORG.NO_LOTORG IS null THEN MOUVEMENT.CD_LOTORG " + " ELSE HISTRANSLOTORG.NO_LOTORG " + " END as NO_LOTORG " + " FROM MOUVEMENT " + " FULL OUTER JOIN HISTRANSLOTORG " + " ON MOUVEMENT.CD_LOTORG = HISTRANSLOTORG.NO_LOT " + " WHERE MOUVEMENT.CD_MAT LIKE '%" + Prefix_RM + "%' AND MOUVEMENT.CD_MAT not LIKE 'F%' AND MOUVEMENT.QT_MVMT > 0 ) V1 " + //and MOUVEMENT.CD_ZONE NOT LIKE 'TR%' ) V1 " + " where HISDOS.NO_LOT = V1.CD_LOTDEST " + " ORDER BY V1.CD_ZONE,HISDOS.NO_LOT, V1.CD_LOTORG,V1.NO_LOTORG", CommandType.Text); return(dt); }
public DataTable RMUsed_Report_Simple(string Prefix_RM) { DataTable dt = new DataTable(); dt = Oracle.ExecuteDataTable("select V1.CD_LOTORG, V1.NO_LOTORG, V1.CD_MAT, V1.LB_MAT, SUM(V1.QT_MVMT) as QT_MVMT " + " from HISDOS, " + " ( " + " SELECT MOUVEMENT.CD_LOTDEST as CD_LOTDEST, " + " MOUVEMENT.CD_LOTORG as CD_LOTORG, " + " MOUVEMENT.CD_MAT as CD_MAT, " + " MOUVEMENT.QT_MVMT as QT_MVMT, " + " MOUVEMENT.LB_MAT as LB_MAT, " + " CASE " + " WHEN HISTRANSLOTORG.NO_LOTORG IS null THEN MOUVEMENT.CD_LOTORG " + " ELSE HISTRANSLOTORG.NO_LOTORG " + " END as NO_LOTORG " + " FROM MOUVEMENT " + " FULL OUTER JOIN HISTRANSLOTORG " + " ON MOUVEMENT.CD_LOTORG = HISTRANSLOTORG.NO_LOT " + " WHERE MOUVEMENT.CD_MAT LIKE '%" + Prefix_RM + "%' AND MOUVEMENT.CD_MAT not LIKE 'F%' AND MOUVEMENT.QT_MVMT > 0 ) V1 " + " where HISDOS.NO_LOT = V1.CD_LOTDEST " + " GROUP BY V1.CD_LOTORG, V1.NO_LOTORG, V1.CD_MAT, V1.LB_MAT ", CommandType.Text); return(dt); }