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));
}
