public void getSeiEDI(int kubun, bool kaitenCheck) { Models.SeisanModels seisan = new Models.SeisanModels(); seisan.syncEDI(kubun, kaitenCheck); //return this.GetJyuProcess(); }
public string TWSeiProcess(string listseiSelected) { 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 SIYNO,SIYKB,TOKCD,TNAME,ZAIKB,ZAICD,ZUBAN,NAME,KISYU,SEISU,JTANKA,NOUKI,NAIJI,HIKSU,TMKBN,SKKBN,NDATE,STATUS FROM [TESCex].[dbo].[D1100_EDI] " + " WHERE SIYNO " + listseiSelected, con); con.Open(); SqlDataAdapter ada = new SqlDataAdapter(cmd); ada.Fill(dtResult); con.Close(); } foreach (DataRow row in dtResult.Rows) { Models.SeisanModels seisan = new Models.SeisanModels { selected = false, SIYNO = row["SIYNO"].ToString(), SIYKB = row["SIYKB"].ToString(), TOKCD = row["TOKCD"].ToString(), TNAME = row["TNAME"].ToString(), ZAIKB = row["ZAIKB"].ToString(), ZAICD = row["ZAICD"].ToString(), ZUBAN = row["ZUBAN"].ToString(), NAME = row["NAME"].ToString(), KISYU = row["KISYU"].ToString(), SEISU = row["SEISU"].ToString(), JTANKA = row["JTANKA"].ToString(), NOUKI = row["NOUKI"].ToString(), NAIJI = row["NAIJI"].ToString(), HIKSU = row["SEISU"].ToString(), TMKBN = row["TMKBN"].ToString(), SKKBN = row["SKKBN"].ToString(), NDATE = row["NDATE"].ToString(), Status = row["STATUS"].ToString() }; seisan.TWSeiProcess(); } return(""); /* * if (listSeiProcess != null) * { * foreach (Models.SeisanModels ss in listSeiProcess) * { * if (ss.selected) * { * ss.TWSeiProcess(); * } * } * } * return "";*/ }
public JsonResult GetSeiProcess() { 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 SIYNO,SIYKB,TOKCD,TNAME,ZAIKB,ZAICD,ZUBAN,NAME,KISYU,SEISU,JTANKA,NOUKI,NAIJI,HIKSU,TMKBN,SKKBN,NDATE,STATUS FROM [TESCex].[dbo].[D1100_EDI] WHERE STATUS IS NOT NULL AND STATUS != 'FN'", con); con.Open(); SqlDataAdapter ada = new SqlDataAdapter(cmd); ada.Fill(dtResult); con.Close(); } List <Models.SeisanModels> listSei = new List <Models.SeisanModels>(); foreach (DataRow row in dtResult.Rows) { Models.SeisanModels seisan = new Models.SeisanModels { selected = false, SIYNO = row["SIYNO"].ToString(), SIYKB = row["SIYKB"].ToString(), TOKCD = row["TOKCD"].ToString(), TNAME = row["TNAME"].ToString(), ZAIKB = row["ZAIKB"].ToString(), ZAICD = row["ZAICD"].ToString(), ZUBAN = row["ZUBAN"].ToString(), NAME = row["NAME"].ToString(), KISYU = row["KISYU"].ToString(), SEISU = row["SEISU"].ToString(), JTANKA = row["JTANKA"].ToString(), NOUKI = row["NOUKI"].ToString(), NAIJI = row["NAIJI"].ToString(), HIKSU = row["SEISU"].ToString(), TMKBN = row["TMKBN"].ToString(), SKKBN = row["SKKBN"].ToString(), NDATE = row["NDATE"].ToString(), Status = row["STATUS"].ToString() }; listSei.Add(seisan); } Models.SeisanModels[] result = listSei.ToArray <Models.SeisanModels>(); return(Json(result, JsonRequestBehavior.AllowGet)); }
public bool createSeiProcess(Models.SeisanModels seiProcess) { return(seiProcess.createSeiProcess()); //return ""; }
public string delSeiProcess(Models.SeisanModels seiProcess) { seiProcess.delSeiProcess(); return(""); }
public string updateSeiProcess(Models.SeisanModels seiProcess, string updateID) { return(seiProcess.updateSeiProcess(updateID)); }