public tblworeport GettblworeportsDet3(int MachineID, string correctedDate, string ProdFAI)
        {
            tblworeport ddldet             = new tblworeport();
            Repository <tblworeport> lista = new Repository <tblworeport>();

            try
            {
                string query = "SELECT MinorLoss from [i_facility_TSAL].[dbo].tblworeport WHERE MachineID =" + MachineID + " and CorrectedDate ='" + correctedDate + "' and Type = '" + ProdFAI + "'";
                ddldet = lista.GetFirstOrDefault(query, _connectionFactory.GetConnection);
            }
            catch (Exception ex)
            {
                // MessageBox.Show(ex.ToString());
            }
            return(ddldet);
        }
示例#2
0
        public decimal GettblworeportsDet3(int MachineID, string correctedDate, string ProdFAI)
        {
            decimal     det                = 0;
            tblworeport ddldet             = new tblworeport();
            Repository <tblworeport> lista = new Repository <tblworeport>();

            try
            {
                string query = "SELECT Sum(MinorLoss) from [" + ConnectionFactory.DB + "].[" + ConnectionFactory.Schema + "].tblworeport WHERE MachineID =" + MachineID + " and CorrectedDate ='" + correctedDate + "' and Type = '" + ProdFAI + "'";
                ddldet = lista.GetFirstOrDefault(query, _connectionFactory.GetConnection);
                det    = (decimal)ddldet.MinorLoss;
            }
            catch (Exception ex)
            {
                // MessageBox.Show(ex.ToString());
            }
            return(det);
        }