Esempio n. 1
0
        public void syncEDIDATA()
        {
            Models.JyuucyuuModels jyucyu = new Models.JyuucyuuModels();

            jyucyu.syncEDI();

            //return this.GetJyuProcess();
        }
Esempio n. 2
0
        public JsonResult GetJyuProcess()
        {
            DataTable dtResult = new DataTable();

            //string ConStringEx = "Data Source=10.121.21.15;Initial Catalog=TESCex;Persist Security Info=True;User ID=TESCWIN;";
            string ConStringEx = Models.MasterModels.ConStringEx;

            using (SqlConnection con = new SqlConnection(ConStringEx))
            {
                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 STATUS IS NOT NULL AND STATUS != 'FN' AND STATUS != 'DEL'", con);
                con.Open();
                SqlDataAdapter ada = new SqlDataAdapter(cmd);
                ada.Fill(dtResult);
                con.Close();
            }

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

            foreach (DataRow row in dtResult.Rows)
            {
                Models.JyuucyuuModels jyucyu = new Models.JyuucyuuModels
                {
                    selected    = false,
                    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));
        }
Esempio n. 3
0
        public string delJyuProcess(Models.JyuucyuuModels Jyuu)
        {
            string ConStringEx = Models.MasterModels.ConStringEx;
            //"Data Source=10.121.21.15;Initial Catalog=TESCex;Persist Security Info=True;User ID=TESCWIN;";

            //Update FN on EDI
            string updateSQL = "UPDATE D1000_EDI SET STATUS = 'DEL' WHERE CYUNO='" + Jyuu.Cyumonno1 + "' AND JYUNO='" + Jyuu.Jyuucyuno + "'";

            using (SqlConnection connection = new SqlConnection(ConStringEx))
            {
                SqlCommand command = new SqlCommand(updateSQL, connection);
                command.Connection.Open();
                command.ExecuteNonQuery();
                command.Connection.Close();
            }

            return("");
        }
Esempio n. 4
0
        public JsonResult deleteSelectedSeiyo(string listselectedProcess, string listSeiProcess)
        {
            string ConStringEx = Models.MasterModels.ConStringEx;

            using (SqlConnection connection = new SqlConnection(ConStringEx))
            {
                SqlCommand command = new SqlCommand("DELETE [TESCex].[dbo].D1100_EDI WHERE SIYNO " + listselectedProcess, connection);
                //SqlCommand command = new SqlCommand("UPDATE D1000_EDI SET SEICD='462379' WHERE JYUNO='000000'", connection);
                command.Connection.Open();
                command.ExecuteNonQuery();
            }

            return(this.GetSeiProcess());


            return(new JsonResult());


            string updateSQL = "UPDATE D1000_EDI SET STATUS = 'DEL' WHERE JYUNO " + listselectedProcess;

            using (SqlConnection connection = new SqlConnection(ConStringEx))
            {
                SqlCommand command = new SqlCommand(updateSQL, connection);
                command.Connection.Open();
                command.ExecuteNonQuery();
                command.Connection.Close();
            }


            DataTable dtResult = new DataTable();


            //"Data Source=10.121.21.15;Initial Catalog=TESCex;Persist Security Info=True;User ID=TESCWIN;";
            using (SqlConnection con = new SqlConnection(ConStringEx))
            {
                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 " + listSeiProcess, con);
                con.Open();
                SqlDataAdapter ada = new SqlDataAdapter(cmd);
                ada.Fill(dtResult);
                con.Close();
            }
            List <Models.JyuucyuuModels> listJyu = new List <Models.JyuucyuuModels>();

            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));
        }
Esempio n. 5
0
 public string validateDATA(Models.JyuucyuuModels JyuuProcess)
 {
     return(JyuuProcess.checkERROR());
 }
Esempio n. 6
0
 public string checkData(Models.JyuucyuuModels JyuuProcess)
 {
     return(JyuuProcess.checkERROR());
 }
Esempio n. 7
0
        public JsonResult deleteSelectedOrder(List <Models.JyuucyuuModels> listJyuProcess)
        {
            if (listJyuProcess != null)
            {
                string cond = " IN (";
                foreach (Models.JyuucyuuModels jyucyu in listJyuProcess)
                {
                    cond += "'" + jyucyu.Jyuucyuno + "',";

                    if (jyucyu.selected == true)
                    {
                        //string ConStringEx = Models.MasterModels.ConStringEx;
                        //"Data Source=10.121.21.15;Initial Catalog=TESCex;Persist Security Info=True;User ID=TESCWIN;";

                        //Update FN on EDI
                        string updateSQL = "UPDATE D1000_EDI SET STATUS = 'DEL' WHERE CYUNO='" + jyucyu.Cyumonno1 + "' AND JYUNO='" + jyucyu.Jyuucyuno + "'";
                        using (SqlConnection connection = new SqlConnection(Models.MasterModels.ConStringEx))
                        {
                            SqlCommand command = new SqlCommand(updateSQL, connection);
                            command.Connection.Open();
                            command.ExecuteNonQuery();
                            command.Connection.Close();
                        }
                    }
                }

                cond = cond.Substring(0, cond.Length - 1) + ")";

                DataTable dtResult = new DataTable();

                string ConStringEx = Models.MasterModels.ConStringEx;
                //"Data Source=10.121.21.15;Initial Catalog=TESCex;Persist Security Info=True;User ID=TESCWIN;";
                using (SqlConnection con = new SqlConnection(ConStringEx))
                {
                    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 " + cond, con);
                    con.Open();
                    SqlDataAdapter ada = new SqlDataAdapter(cmd);
                    ada.Fill(dtResult);
                    con.Close();
                }

                List <Models.JyuucyuuModels> listJyu = new List <Models.JyuucyuuModels>();
                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));
            }
            else
            {
                return(new JsonResult());
            }
        }
Esempio n. 8
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));
        }
Esempio n. 9
0
        public void importEDI(Models.JyuucyuuModels newYuucyu)
        {
            if (newYuucyu.checkExists())
            {
                return;
            }

            var result = "";

            int    maxJYU, insertRow;
            string ConStringEx = Models.MasterModels.ConStringEx;

            //"Data Source=10.121.21.15;Initial Catalog=TESCex;Persist Security Info=True;User ID=TESCWIN;";

            //Get maxJYU
            maxJYU = 0;
            DataTable dtResult = new DataTable();

            using (SqlConnection con = new SqlConnection(ConStringEx))
            {
                SqlCommand cmd = new SqlCommand("SELECT D1000_EDI.SEICD maxJYU FROM D1000_EDI WHERE JYUNO = '000000'", con);
                con.Open();

                SqlDataAdapter ada = new SqlDataAdapter(cmd);
                ada.Fill(dtResult);
                con.Close();
            }
            maxJYU = Int32.Parse(dtResult.Rows[0]["maxJYU"].ToString());
            //maxSEI = Int32.Parse(dtResult.Rows[0]["maxSEI"].ToString());

            insertRow = 1;

            //if (insertRow == 1) return "test";

            using (SqlConnection connection = new SqlConnection(ConStringEx))
            {
                SqlCommand command = new SqlCommand("UPDATE D1000_EDI SET SEICD='" + (maxJYU + insertRow) + "' WHERE JYUNO='000000'", connection);
                //SqlCommand command = new SqlCommand("UPDATE D1000_EDI SET SEICD='462379' WHERE JYUNO='000000'", connection);
                command.Connection.Open();
                command.ExecuteNonQuery();
            }

            /*
             * using (SqlConnection connection = new SqlConnection(ConString))
             * {
             *  SqlCommand command = new SqlCommand("UPDATE D1100_EDI SET ZAICD='" + (maxSEI + insertRow) + "' WHERE SIYNO='000000'", connection);
             *  //SqlCommand command = new SqlCommand("UPDATE D1100_EDI SET ZAICD='445159' WHERE SIYNO='000000'", connection);
             *  command.Connection.Open();
             *  command.ExecuteNonQuery();
             * }
             */

            //確定受注
            string insertSQL = "INSERT INTO D1000_EDI VALUES " +
                               "('" + (maxJYU + 1) + "','','" + newYuucyu.Tokuicode + "','" + newYuucyu.Tokuiname + "','" + newYuucyu.Nounyucode + "','" + newYuucyu.Nonyuname + "'," +
                               "'" + newYuucyu.Seihincode + "','" + newYuucyu.Seihinzuban + "','" + newYuucyu.Seihinname + "','" + newYuucyu.Seihinkisyu + "','" + newYuucyu.Quantity + "','" + newYuucyu.Tanka + "'," +
                               "'" + newYuucyu.Nouki.Replace("-", "").Substring(0, 8) + "','" + newYuucyu.Nounyu.Replace("-", "").Substring(0, 8) + "'," +
                               "'999','" + newYuucyu.Tantoucode + "','" + newYuucyu.Cyumonno1 + "','" + newYuucyu.Cyumonno2 + "','" + newYuucyu.Seizou + "','" + newYuucyu.Bikou + "','0'" +
                               ",'','','',0,0," +
                               "'" + DateTime.Now.ToString("yyyyMMdd") + "','" + newYuucyu.Status + "')";

            insertSQL = insertSQL.Replace("''", "null");
            using (SqlConnection connection = new SqlConnection(ConStringEx))
            {
                SqlCommand command = new SqlCommand(insertSQL, connection);
                command.Connection.Open();
                command.ExecuteNonQuery();
            }

            /*
             * string strcon = @"Provider = Microsoft.Jet.OLEDB.4.0; Data Source = \\10.121.21.16\Rainbow; Extended Properties = dBASE IV;";
             * string sqlINS = "UPDATE CYUMNDF.DBF SET SFLG='2' WHERE CYUNO = '" + CYUNO + "'";// SFLG IS NULL";
             *
             * using (OleDbConnection conn = new OleDbConnection(strcon))
             * {
             *  OleDbCommand cmd = new OleDbCommand(sqlINS, conn);
             *  conn.Open();
             *  cmd.ExecuteNonQuery();
             *  conn.Close();
             * }
             */
        }
Esempio n. 10
0
        public Models.JyuucyuuModels convertCyu(Models.DBFCYUMNModels cyumn)
        {
            //Models.JyuucyuuModels result = new Models.JyuucyuuModels();

            //

            Models.JyuucyuuModels jyucyu = new Models.JyuucyuuModels();
            jyucyu.Jyuucyuno = "";


            jyucyu.Tokuicode  = "00" + cyumn.Tokcd;
            jyucyu.Nounyucode = "00" + cyumn.Noucd;

            string temp = this.findName(jyucyu.Tokuicode, jyucyu.Nounyucode);

            jyucyu.Tokuiname = temp.Split(new string[] { " - " }, StringSplitOptions.None)[0];
            jyucyu.Nonyuname = temp.Split(new string[] { " - " }, StringSplitOptions.None)[1];


            jyucyu.Seihinname  = cyumn.Sname;
            jyucyu.Seihinzuban = cyumn.Zuban;
            jyucyu.Seihinkisyu = cyumn.Kisyu;
            jyucyu.Quantity    = cyumn.Cyusu;
            jyucyu.Tanka       = cyumn.Tanka;

            //find by SQL
            DataTable dtResult = cyumn.findSehinCode();
            string    result   = "";

            var    rowC = dtResult.Rows.Count;
            string rtani;
            double rtanka, ctanka;


            if (rowC < 1)
            {
                result = "NG: Can not find this sehin";
            }

            if (rowC == 1)
            {
                jyucyu.Seihinname  = dtResult.Rows[0]["NAME"].ToString().Trim();
                jyucyu.Seihinkisyu = dtResult.Rows[0]["KISYU"].ToString().Trim();
                rtani  = dtResult.Rows[0]["TANI"].ToString().Trim();
                rtanka = double.Parse(dtResult.Rows[0]["TANKA"].ToString());

                if (cyumn.Sname == null)
                {
                    cyumn.Sname = "";
                }
                if (cyumn.Kisyu == null)
                {
                    cyumn.Kisyu = "";
                }
                if (cyumn.Tani == null)
                {
                    cyumn.Tani = "";
                }
                if (cyumn.Tanka == null)
                {
                    ctanka = 0;
                }
                else
                {
                    ctanka = double.Parse(cyumn.Tanka);
                }

                if (jyucyu.Seihinname != cyumn.Sname)
                {
                    result += "NG: Name is not correct, ";
                }
                if (jyucyu.Seihinkisyu != cyumn.Kisyu.ToString())
                {
                    result += "NG: Kisyu is not correct, ";
                }
                if (rtani != cyumn.Tani.ToString())
                {
                    result += "NG: Tani is not correct, ";
                }
                if (rtanka != ctanka)
                {
                    result += "NG: Tanka is not correct, ";
                }

                if (result != "")
                {
                    result = result.Substring(0, result.Length - 2);
                }

                jyucyu.Tanka      = rtanka.ToString();
                jyucyu.Seihincode = dtResult.Rows[0]["ZAICD"].ToString().Trim();
            }

            else
            {
                result = "NG: Have many sehin Code";
            }

            jyucyu.Nouki = cyumn.Nouki;

            jyucyu.Nounyu = new DateTime(Int32.Parse(cyumn.Nouki.Substring(0, 4)), Int32.Parse(cyumn.Nouki.Substring(4, 2)), Int32.Parse(cyumn.Nouki.Substring(6, 2))).AddDays(-2).ToString("yyyyMMdd");//early nouki 2 days

            jyucyu.Bumoncode  = "999";
            jyucyu.Bumonname  = "データCONV";
            jyucyu.Tantoucode = "209";   //by Login User
            jyucyu.Tantouname = "和久井清美"; //by Login User
            jyucyu.Cyumonno1  = cyumn.Cyuno;
            jyucyu.Cyumonno2  = "";
            jyucyu.Seizou     = "";
            jyucyu.Bikou      = "";
            jyucyu.Status     = result; //"Checking";

            return(jyucyu);
        }
Esempio n. 11
0
        public JsonResult savetoJyuEDI(Models.JyuucyuuModels JyuuProcess)
        {
            JyuuProcess.updateInf();

            return(this.GetJyuProcess());
        }
Esempio n. 12
0
        public JsonResult convertCyuToJyu(Models.DBFCYUMNModels cyumn)
        {
            Models.JyuucyuuModels jyucyu = new Models.JyuucyuuModels();
            jyucyu.Jyuucyuno = "";


            jyucyu.Tokuicode  = "00001";
            jyucyu.Tokuiname  = "(株)玉吉製作所大田原工場";
            jyucyu.Nounyucode = "00001";
            jyucyu.Nonyuname  = "大田原工場";


            jyucyu.Seihinname  = cyumn.Sname;
            jyucyu.Seihinzuban = cyumn.Zuban;
            jyucyu.Seihinkisyu = cyumn.Kisyu;
            jyucyu.Quantity    = cyumn.Cyusu;
            jyucyu.Tanka       = cyumn.Tanka;

            //find by SQL

            DataTable dtResult = cyumn.findSehinCode();
            string    result   = "";

            var    rowC = dtResult.Rows.Count;
            string rtani;
            double rtanka, ctanka;


            if (rowC < 1)
            {
                result = "Error : Can not find this sehin";
            }

            if (rowC == 1)
            {
                jyucyu.Seihinname  = dtResult.Rows[0]["NAME"].ToString().Trim();
                jyucyu.Seihinkisyu = dtResult.Rows[0]["KISYU"].ToString().Trim();
                rtani  = dtResult.Rows[0]["TANI"].ToString().Trim();
                rtanka = double.Parse(dtResult.Rows[0]["TANKA"].ToString());

                if (cyumn.Sname == null)
                {
                    cyumn.Sname = "";
                }
                if (cyumn.Kisyu == null)
                {
                    cyumn.Kisyu = "";
                }
                if (cyumn.Tani == null)
                {
                    cyumn.Tani = "";
                }
                if (cyumn.Tanka == null)
                {
                    ctanka = 0;
                }
                else
                {
                    ctanka = double.Parse(cyumn.Tanka);
                }

                if (jyucyu.Seihinname != cyumn.Sname)
                {
                    result += "Name is not correct, ";
                }
                if (jyucyu.Seihinkisyu != cyumn.Kisyu.ToString())
                {
                    result += "Kisyu is not correct, ";
                }
                if (rtani != cyumn.Tani.ToString())
                {
                    result += "Tani is not correct, ";
                }
                if (rtanka != ctanka)
                {
                    result += "Tanka is not correct, ";
                }

                if (result != "")
                {
                    result = "Error: " + result.Substring(0, result.Length - 2);
                }

                jyucyu.Tanka      = rtanka.ToString();
                jyucyu.Seihincode = dtResult.Rows[0]["ZAICD"].ToString().Trim();
            }

            else
            {
                result = "Error : Have many sehin Code";
            }

            jyucyu.Nouki  = cyumn.Nouki;
            jyucyu.Nounyu = "";//early nouki 2 days

            jyucyu.Bumoncode  = "999";
            jyucyu.Bumonname  = "データCONV";
            jyucyu.Tantoucode = "209";   //by Login User
            jyucyu.Tantouname = "和久井清美"; //by Login User
            jyucyu.Cyumonno1  = cyumn.Cyuno;
            jyucyu.Cyumonno2  = "";
            jyucyu.Seizou     = "";
            jyucyu.Bikou      = "";
            jyucyu.Status     = result; //"Checking";

            return(Json(jyucyu, JsonRequestBehavior.AllowGet));
        }
Esempio n. 13
0
 public string registerOrder(Models.JyuucyuuModels newYuucyu)
 {
     return(newYuucyu.inputTESCWORK());
 }