public string DeleteTPEMDataSQL(string cGroupCD, DateTime dDate, string cShift, string cUnit, string cArea, string cMachine)
 {
     try
     {
         TPEMTransitionBL tpemTransition = new TPEMTransitionBL(GetstrConn(cGroupCD));
         return tpemTransition.DeleteTPEMDataSQL(cGroupCD, dDate, cShift, cUnit, cArea, cMachine);
     }
     catch (Exception Ex)
     {
         Common.General.BLLoger.Error("TPEMTransitionService.DeleteTPEMDataSQL", Ex);
         return string.Empty;
     }
 }
 public string GetAllMachineSQL()
 {
     try
     {
         TPEMTransitionBL tpemTransition = new TPEMTransitionBL(GetstrConn(""));
         return tpemTransition.GetAllMachineSQL();
     }
     catch (Exception Ex)
     {
         Common.General.BLLoger.Error("TPEMTransitionService.GetAllMachineSQL", Ex);
         return string.Empty;
     }
 }
 public string InsertTPEMDataByDateSQL(string cGroupCD, DateTime dDate)
 {
     try
     {
         TPEMTransitionBL tpemTransition = new TPEMTransitionBL(GetstrConn(cGroupCD));
         return tpemTransition.InsertTPEMDataByDateSQL(cGroupCD, dDate);
     }
     catch (Exception Ex)
     {
         Common.General.BLLoger.Error("TPEMTransitionService.InsertTPEMDataByDateSQL", Ex);
         return string.Empty;
     }
 }