Ejemplo n.º 1
0
        public string GetTB039_Down(string date_)
        {
            string _TC002     = "";
            string dateFormat = date_.Substring(1);
            string firstvalue = dateFormat + "9999";
            sqlCON data       = new sqlCON();
            string check9999  = data.sqlExecuteScalarString("select count(*) TRANSNO from m_SFTKEY where TRANSNO = '" + firstvalue + "'");

            if (int.Parse(check9999) != 0)
            {
                string minTB002 = data.sqlExecuteScalarString("select min(TRANSNO) from m_SFTKEY where TRANSNO like '" + dateFormat + "%'");
                int    valueset = int.Parse(minTB002.Trim().Substring(7, 4));
                valueset = valueset - 1;
                _TC002   = dateFormat + valueset.ToString("0000");
            }
            else
            {
                _TC002 = firstvalue;
            }
            //insertnextvalue
            string sqlinsert = "insert into m_SFTKEY(TRANSNO, datetimeRST) values ('" + _TC002 + "', getdate()) ";

            data.sqlExecuteNonQuery(sqlinsert, false);
            return(_TC002);
        }
Ejemplo n.º 2
0
 public void updateERPMQC(string serno)
 {
     try
     {
         StringBuilder update = new StringBuilder();
         update.Append("update m_ERPMQC set status = 'OK' where serno = '" + serno + "'");
         sqlCON data = new sqlCON();
         data.sqlExecuteNonQuery(update.ToString(), false);
     }
     catch (Exception ex)
     {
         SystemLog.Output(SystemLog.MSG_TYPE.Err, "updateERPMQC(string serno)", ex.Message);
     }
 }
Ejemplo n.º 3
0
        public string GetCodeNGFrom_process(string Dept, string PLCNG)
        {
            string        Str = "";
            StringBuilder sql = new StringBuilder();

            sql.Append("select  itemcode ");
            sql.Append("from m_process ");
            sql.Append("where 1=1 ");
            sql.Append("and modelcode = '" + Dept + "' ");
            sql.Append("and processcode = '" + PLCNG + "' ");
            sqlCON data = new sqlCON();

            Str = data.sqlExecuteScalarString(sql.ToString());
            return(Str);
        }
Ejemplo n.º 4
0
 public bool UpdateToERPMQC_Realtime(string Status, string lot)
 {
     try
     {
         StringBuilder sqlupdate = new StringBuilder();
         sqlupdate.Append("update m_ERPMQC_REALTIME set status = '" + Status + "' where ");
         sqlupdate.Append("lot = '" + lot + "' and data not like '0' and status  like ''");
         sqlCON data = new sqlCON();
         data.sqlExecuteNonQuery(sqlupdate.ToString(), false);
         return(true);
     }
     catch (Exception ex)
     {
         SystemLog.Output(SystemLog.MSG_TYPE.Err, "  UpdateToERPMQC_Realtime(string Status, string lot)", ex.Message);
         return(false);
     }
 }
Ejemplo n.º 5
0
 public bool UpdateToERPMQC_Error(string Status, string serno)
 {
     try
     {
         StringBuilder sqlupdate = new StringBuilder();
         sqlupdate.Append("update m_ERPMQC_Error set status = '" + Status + "' where ");
         sqlupdate.Append("serno = '" + serno + "'");
         sqlCON data = new sqlCON();
         data.sqlExecuteNonQuery(sqlupdate.ToString(), false);
         return(true);
     }
     catch (Exception ex)
     {
         SystemLog.Output(SystemLog.MSG_TYPE.Err, " UpdateToERPMQC_Error(string Status, string serno)", ex.Message);
         return(false);
     }
 }
Ejemplo n.º 6
0
 public bool InsertToERPMQC(DataTable table)
 {
     try
     {
         for (int i = 0; i < table.Rows.Count; i++)
         {
             if (table.Rows[i]["data"].ToString().Trim() != "0" && double.Parse(table.Rows[i]["data"].ToString()) > 0)
             {
                 StringBuilder sqlInsert = new StringBuilder();
                 sqlInsert.Append("insert into m_ERPMQC ");
                 sqlInsert.Append(@"(serno, lot, model, site, factory, line, process, item, inspectdate, inspecttime, data, judge, status, remark )");
                 sqlInsert.Append(" values ( ");
                 sqlInsert.Append("'" + table.Rows[i]["serno"].ToString() + "' , ");
                 sqlInsert.Append("'" + table.Rows[i]["lot"].ToString() + "' , ");
                 sqlInsert.Append("'" + table.Rows[i]["model"].ToString() + "' , ");
                 sqlInsert.Append("'" + table.Rows[i]["site"].ToString() + "' , ");
                 sqlInsert.Append("'" + table.Rows[i]["factory"].ToString() + "' , ");
                 sqlInsert.Append("'" + table.Rows[i]["line"].ToString() + "' , ");
                 sqlInsert.Append("'" + table.Rows[i]["process"].ToString() + "' , ");
                 sqlInsert.Append("'" + table.Rows[i]["item"].ToString() + "' , ");
                 sqlInsert.Append("'" + table.Rows[i]["inspectdate"].ToString() + "' , ");
                 sqlInsert.Append("'" + table.Rows[i]["inspecttime"].ToString() + "' , ");
                 sqlInsert.Append("'" + table.Rows[i]["data"].ToString() + "' , ");
                 sqlInsert.Append("'" + table.Rows[i]["judge"].ToString() + "' , ");
                 sqlInsert.Append("'" + table.Rows[i]["status"].ToString() + "', ");
                 sqlInsert.Append("'" + table.Rows[i]["remark"].ToString() + "' ) ");
                 sqlCON data = new sqlCON();
                 data.sqlExecuteNonQuery(sqlInsert.ToString(), false);
             }
         }
         return(true);
     }
     catch (Exception ex)
     {
         SystemLog.Output(SystemLog.MSG_TYPE.Err, "InsertToERPMQC(DataTable table)", ex.Message);
         return(false);
     }
 }
Ejemplo n.º 7
0
        public List <NGItemsMapping> listNGMapping(string Dept)
        {
            List <NGItemsMapping> nGItemsMappings = new List <NGItemsMapping>();
            StringBuilder         sql             = new StringBuilder();

            sql.Append("select distinct modelcode, processcode, processname, itemcode, itemname ");
            sql.Append("from m_process ");
            sql.Append("where 1=1 ");
            sql.Append("and modelcode = '" + Dept + "' ");
            sqlCON    data = new sqlCON();
            DataTable dt   = new DataTable();

            data.sqlDataAdapterFillDatatable(sql.ToString(), ref dt);
            nGItemsMappings = (from DataRow dr in dt.Rows
                               select new NGItemsMapping()
            {
                Department = dr["modelcode"].ToString(),
                NGCode_Process = dr["processcode"].ToString(),
                NGCodeName_Process = dr["processname"].ToString(),
                NGCode_SFT = dr["itemcode"].ToString(),
                NGCodeName_SFT = dr["itemname"].ToString()
            }).ToList();
            return(nGItemsMappings);
        }
Ejemplo n.º 8
0
        public void GetListLOT()
        {
            try
            {
                string   sqlgetListLOT = "select distinct lot  from m_ERPMQC_REALTIME  where data not like '0' and status  like '' ";
                ComboBox cmb_          = new ComboBox();
                sqlCON   data          = new sqlCON();
                data.getComboBoxData(sqlgetListLOT, ref cmb_);
                string inspectdate = DateTime.Now.ToString("yyyy-MM-dd");
                string inspecttime = DateTime.Now.ToString("HH:mm:ss");
                string DateUp      = DateTime.Now.ToString("yyyyMMdd");
                string TimeUp      = DateTime.Now.ToString("HH:mm:ss");
                string TimeSerno   = DateTime.Now.ToString("HHmmss");
                //   if (cmb_.Items.Count == 0) return;
                for (int cmbitem = 0; cmbitem < cmb_.Items.Count; cmbitem++)
                {
                    string        serno       = cmb_.Items[cmbitem].ToString().Split(';')[0] + "-" + DateUp + "_" + TimeSerno;
                    DataTable     table       = new DataTable();
                    StringBuilder sqlGetTable = new StringBuilder();
                    sqlGetTable.Append("select '" + serno + "' as serno,");
                    sqlGetTable.Append("lot, model, site, factory, line, process,item,");
                    sqlGetTable.Append("'" + inspectdate + "' as inspectdate,");
                    sqlGetTable.Append("'" + inspecttime + "' as inspecttime,");
                    sqlGetTable.Append("sum(cast(data as int)) as data,");
                    sqlGetTable.Append("'0' as judge , status, remark from m_ERPMQC_REALTIME  ");
                    sqlGetTable.Append("where data not like '0' and status  like '' and lot = '" + cmb_.Items[cmbitem].ToString() + "'");
                    sqlGetTable.Append("group by item,lot,model,site, factory, line, process, item,  status, remark");
                    data.sqlDataAdapterFillDatatable(sqlGetTable.ToString(), ref table);

                    int intCountOK = CounterỌKERP(ref table);
                    int intCountNG = CounterNGERP(ref table);
                    strLot = table.Rows[0]["lot"].ToString();
                    string code = table.Rows[0]["serno"].ToString().Split('-')[0];
                    string No   = table.Rows[0]["serno"].ToString().Split('-')[1];
                    //string serno = table.Rows[0]["serno"].ToString();
                    string typeNG      = "";
                    int    checkdouble = 0;
                    //check file trung
                    string sqlERP      = "select count(*) from m_ERPMQC_Error where serno = '" + serno + "'";
                    string sqlERPError = "select count(*) from m_ERPMQC_REALTIME where serno = '" + serno + "'";
                    checkdouble = int.Parse(data.sqlExecuteScalarString(sqlERP)) + int.Parse(data.sqlExecuteScalarString(sqlERPError));
                    //An Them Code Check Nguyen Vat Lieu ngay 10/05/2019
                    string               MaLSX        = code + "-" + No;
                    Material             material     = new Material();
                    bool                 IsDuSoLuong  = false;
                    bool                 IsNVL        = false;
                    List <string>        _messages    = new List <string>();
                    List <MaterialAdapt> listMaterial = new List <MaterialAdapt>();
                    double               SL_UPload    = intCountOK + intCountNG;
                    //Chua ma Lenh San xuat vao 2 truong dang dua vao
                    bool        IsResultheck = material.KiemtraNguyenVatLieu(code, No, SL_UPload, out IsDuSoLuong, out IsNVL, out listMaterial, out _messages);
                    insertERP   classinsert  = new insertERP();
                    DefectClass defectClass  = new DefectClass();
                    if ((intCountNG + intCountOK > 0) && checkdouble == 0)
                    {
                        //update to realtime

                        if (IsResultheck == true)
                        {
                            classinsert.InsertdataToERP(table.Rows[0]["lot"].ToString(), intCountOK.ToString(), intCountNG.ToString(), DateUp, TimeUp);
                            classinsert.updateERP(table.Rows[0]["lot"].ToString(), intCountOK.ToString(), intCountNG.ToString(), DateUp, TimeUp);
                            classinsert.InsertdataToSFT(table.Rows[0]["lot"].ToString(), intCountOK.ToString(), intCountNG.ToString(), DateUp, TimeUp);
                            classinsert.UpdatedataToSFT(table.Rows[0]["lot"].ToString(), intCountOK.ToString(), intCountNG.ToString(), DateUp, TimeUp);


                            for (int i = 0; i < table.Rows.Count; i++)
                            {
                                typeNG = table.Rows[i]["item"].ToString();
                                string SL = table.Rows[i]["data"].ToString();

                                if (int.Parse(SL) > 0 && typeNG.Contains("NG"))
                                {
                                    var insert = defectClass.InsertToSFT_OP_EXCEPT(MaLSX, typeNG, int.Parse(SL), classinsert.Sequence_OP_REAL_RUN);
                                }
                            }
                            classinsert.InsertToERPMQC(table);
                            classinsert.UpdateToERPMQC_Realtime("OK", strLot);
                            classinsert.updateERPMQC(table.Rows[0]["serno"].ToString());
                            classinsert.UpdateToERPMQC_Error("OK", table.Rows[0]["serno"].ToString());
                        }
                        else //insert to Temperate database
                        {
                            classinsert.InsertToERPMQC_Error(table);
                            classinsert.InsertToERPMQC(table);
                            classinsert.UpdateToERPMQC_Realtime("OK", strLot);
                        }
                    }
                }
                UpdateFromERPMQC_ErrorToSFT_ERP(); //waiting
            }

            catch (Exception ex)
            {
                SystemLog.Output(SystemLog.MSG_TYPE.Err, " GetListLOT", ex.Message);
            }
        }
Ejemplo n.º 9
0
        public void UpdateFromERPMQC_ErrorToSFT_ERP()
        {
            try
            {
                StringBuilder sqlquery = new StringBuilder();
                sqlquery.Append(@"select distinct
serno,lot,model,site,factory,line,process,item,inspectdate,inspecttime,data,judge,status,remark
from m_ERPMQC_Error 
where status !='OK' ");
                sqlCON    data    = new sqlCON();
                DataTable dtTable = new DataTable();
                data.sqlDataAdapterFillDatatable(sqlquery.ToString(), ref dtTable);

                for (int i = 0; i < dtTable.Rows.Count; i++)
                {
                    Material             material     = new Material();
                    bool                 IsDuSoLuong  = false;
                    bool                 IsNVL        = false;
                    List <string>        _messages    = new List <string>();
                    List <MaterialAdapt> listMaterial = new List <MaterialAdapt>();
                    //Chua ma Lenh San xuat vao 2 truong dang dua vao
                    string code    = dtTable.Rows[i]["serno"].ToString().Split('-')[0];
                    string No      = dtTable.Rows[i]["serno"].ToString().Split('-')[1];
                    double dataQTY = dtTable.Rows[i]["data"].ToString() != null?double.Parse(dtTable.Rows[i]["data"].ToString()) : 0;

                    string      DateUp       = DateTime.Parse(dtTable.Rows[i]["inspectdate"].ToString()).ToString("yyyyMMdd");
                    string      TimeUp       = dtTable.Rows[i]["inspecttime"].ToString().Substring(0, 8);
                    string      typeNG       = "";
                    string      MaLSX        = code + "-" + No;
                    bool        IsResultheck = material.KiemtraNguyenVatLieu(code, No, dataQTY, out IsDuSoLuong, out IsNVL, out listMaterial, out _messages);
                    DefectClass defectClass  = new DefectClass();
                    if (IsNVL && (dtTable.Rows[i]["data"].ToString() != "0"))
                    {//Update Status
                        string    test        = dtTable.Rows[i]["remark"].ToString();
                        int       countOK     = dtTable.Rows[i]["remark"].ToString() == "OP" ? int.Parse(dtTable.Rows[i]["data"].ToString()) : 0;
                        int       countNG     = dtTable.Rows[i]["remark"].ToString() == "NG" ? int.Parse(dtTable.Rows[i]["data"].ToString()) : 0;
                        insertERP classinsert = new insertERP();
                        classinsert.InsertdataToERP(dtTable.Rows[i]["lot"].ToString(), countOK.ToString(), countNG.ToString(), DateUp, TimeUp);
                        classinsert.updateERP(dtTable.Rows[i]["lot"].ToString(), countOK.ToString(), countNG.ToString(), DateUp, TimeUp);
                        classinsert.InsertdataToSFT(dtTable.Rows[i]["lot"].ToString(), countOK.ToString(), countNG.ToString(), DateUp, TimeUp);
                        classinsert.UpdatedataToSFT(dtTable.Rows[i]["lot"].ToString(), countOK.ToString(), countNG.ToString(), DateUp, TimeUp);
                        classinsert.updateERPMQC(dtTable.Rows[i]["serno"].ToString());
                        classinsert.UpdateToERPMQC_Error("OK", dtTable.Rows[i]["serno"].ToString());
                        // for (int j = 0; j < dtTable.Rows.Count; j++)
                        {
                            typeNG = dtTable.Rows[i]["item"].ToString();
                            string SL = dtTable.Rows[i]["data"].ToString();

                            if (int.Parse(SL) > 0 && typeNG.Contains("NG"))
                            {
                                var insert = defectClass.InsertToSFT_OP_EXCEPT(MaLSX, typeNG, int.Parse(SL), classinsert.Sequence_OP_REAL_RUN);
                            }
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                SystemLog.Output(SystemLog.MSG_TYPE.Err, "UpdateFromERPMQC_ErrorToSFT_ERP ()", ex.Message);
            }
        }