public void syncEDIDATA() { Models.JyuucyuuModels jyucyu = new Models.JyuucyuuModels(); jyucyu.syncEDI(); //return this.GetJyuProcess(); }
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)); }
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(""); }
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)); }
public string validateDATA(Models.JyuucyuuModels JyuuProcess) { return(JyuuProcess.checkERROR()); }
public string checkData(Models.JyuucyuuModels JyuuProcess) { return(JyuuProcess.checkERROR()); }
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()); } }
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)); }
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(); * } */ }
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); }
public JsonResult savetoJyuEDI(Models.JyuucyuuModels JyuuProcess) { JyuuProcess.updateInf(); return(this.GetJyuProcess()); }
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)); }
public string registerOrder(Models.JyuucyuuModels newYuucyu) { return(newYuucyu.inputTESCWORK()); }