예제 #1
0
        public JsonResult completeEDI(string listselectedProcess, string listJyuProcess)
        {
            string    ConStringEx = Models.MasterModels.ConStringEx;
            DataTable dtResult    = new DataTable();

            using (SqlConnection con = new SqlConnection(ConStringEx))
            {
                dtResult = new DataTable();
                SqlCommand cmd = new SqlCommand("SELECT * FROM D1000_EDI " +
                                                " WHERE JYUNO " + listselectedProcess, con);
                con.Open();
                SqlDataAdapter ada = new SqlDataAdapter(cmd);
                ada.Fill(dtResult);
                con.Close();

                foreach (DataRow row in dtResult.Rows)
                {
                    Models.JyuucyuuModels jyucyu = new Models.JyuucyuuModels
                    {
                        Jyuucyuno   = row["JYUNO"].ToString(),
                        Tokuicode   = row["TOKCD"].ToString(),
                        Tokuiname   = row["TNAME"].ToString(),
                        Nounyucode  = row["NOUCD"].ToString(),
                        Nonyuname   = row["NNAME"].ToString(),
                        Seihincode  = row["SEICD"].ToString(),
                        Seihinzuban = row["ZUBAN"].ToString(),
                        Seihinname  = row["NAME"].ToString(),
                        Seihinkisyu = row["KISYU"].ToString(),
                        Quantity    = row["JYUSU"].ToString(),
                        Tanka       = row["JTANKA"].ToString(),
                        Nouki       = row["NOUKI"].ToString(),
                        Nounyu      = row["YDATE"].ToString(),
                        Bumoncode   = row["BMNCD"].ToString(),
                        Tantoucode  = row["JTANCD"].ToString(),
                        Cyumonno1   = row["CYUNO"].ToString(),
                        Cyumonno2   = row["EDANO"].ToString(),
                        Seizou      = row["SEIZO"].ToString(),
                        Bikou       = row["BIKOU"].ToString(),
                        Ndate       = row["NDATE"].ToString(),
                        Status      = row["STATUS"].ToString()
                    };

                    jyucyu.inputTESCWORK();
                }
            }
            List <Models.JyuucyuuModels> listJyu = new List <Models.JyuucyuuModels>();

            using (SqlConnection con = new SqlConnection(ConStringEx))
            {
                dtResult = new DataTable();
                SqlCommand cmd = new SqlCommand("SELECT JYUNO,TOKCD,TNAME,NOUCD,NNAME,SEICD,ZUBAN,NAME,KISYU,JYUSU,JTANKA,NOUKI,YDATE,BMNCD,JTANCD,CYUNO,EDANO,SEIZO,BIKOU,NDATE,STATUS FROM D1000_EDI " +
                                                " WHERE JYUNO " + listJyuProcess, con);
                con.Open();
                SqlDataAdapter ada = new SqlDataAdapter(cmd);
                ada.Fill(dtResult);
                con.Close();
                foreach (DataRow row in dtResult.Rows)
                {
                    Models.JyuucyuuModels jyucyu = new Models.JyuucyuuModels
                    {
                        Jyuucyuno   = row["JYUNO"].ToString(),
                        Tokuicode   = row["TOKCD"].ToString(),
                        Tokuiname   = row["TNAME"].ToString(),
                        Nounyucode  = row["NOUCD"].ToString(),
                        Nonyuname   = row["NNAME"].ToString(),
                        Seihincode  = row["SEICD"].ToString(),
                        Seihinzuban = row["ZUBAN"].ToString(),
                        Seihinname  = row["NAME"].ToString(),
                        Seihinkisyu = row["KISYU"].ToString(),
                        Quantity    = row["JYUSU"].ToString(),
                        Tanka       = row["JTANKA"].ToString(),
                        Nouki       = row["NOUKI"].ToString(),
                        Nounyu      = row["YDATE"].ToString(),
                        Bumoncode   = row["BMNCD"].ToString(),
                        Tantoucode  = row["JTANCD"].ToString(),
                        Cyumonno1   = row["CYUNO"].ToString(),
                        Cyumonno2   = row["EDANO"].ToString(),
                        Seizou      = row["SEIZO"].ToString(),
                        Bikou       = row["BIKOU"].ToString(),
                        Ndate       = row["NDATE"].ToString(),
                        Status      = row["STATUS"].ToString(),
                    };

                    listJyu.Add(jyucyu);
                }
            }

            Models.JyuucyuuModels[] result = listJyu.ToArray <Models.JyuucyuuModels>();
            return(Json(result, JsonRequestBehavior.AllowGet));
        }
예제 #2
0
 public string registerOrder(Models.JyuucyuuModels newYuucyu)
 {
     return(newYuucyu.inputTESCWORK());
 }