public string Print_Genka_ProjectData(Print_GenkaModel Pmodel)
{
BaseDL bdl = new BaseDL();
Pmodel.Sqlprms = new SqlParameter[6];
Pmodel.Sqlprms[0] = new SqlParameter("@ProjectCD", SqlDbType.VarChar)
{
Value = (object)Pmodel.ProjectCD ?? DBNull.Value
};
Pmodel.Sqlprms[1] = new SqlParameter("@BrandCD", SqlDbType.VarChar)
{
Value = (object)Pmodel.BrandCD ?? DBNull.Value
};
Pmodel.Sqlprms[2] = new SqlParameter("@LoginID", SqlDbType.VarChar)
{
Value = (object)Pmodel.LoginID ?? DBNull.Value
};
Pmodel.Sqlprms[3] = new SqlParameter("@HinbanCD", SqlDbType.VarChar)
{
Value = (object)Pmodel.HinbanCD ?? DBNull.Value
};
Pmodel.Sqlprms[4] = new SqlParameter("@Season", SqlDbType.VarChar)
{
Value = (object)Pmodel.Season ?? DBNull.Value
};
Pmodel.Sqlprms[5] = new SqlParameter("@Type", SqlDbType.VarChar)
{
Value = (object)Pmodel.Type ?? DBNull.Value
};
return(bdl.SelectJson("Print_Genka_ProjectData", Pmodel.Sqlprms));
}
public string M_Contrl_Year_ExitCheck(Print_GenkaModel Pmodel) // for 対象年度
{
BaseDL bdl = new BaseDL();
Pmodel.Sqlprms = new SqlParameter[0];
return(bdl.SelectJson("M_Contrl_Year_ExitCheck"));
}
public ActionResult Print_Genka(Print_GenkaModel pgModel)
{
if (string.IsNullOrWhiteSpace(pgModel.Mode))
{
pgModel.Mode = "New";
}
return(View(pgModel));
}
public string M_Project_ExistsCheck(Print_GenkaModel Pmodel)
{
BaseDL bdl = new BaseDL();
Pmodel.Sqlprms = new SqlParameter[1];
Pmodel.Sqlprms[0] = new SqlParameter("@ProjectCD", SqlDbType.VarChar)
{
Value = Pmodel.ProjectCD
};
return(bdl.SelectJson("M_Project_ExistsCheck", Pmodel.Sqlprms));
}
public string Print_GenkaCSV(Print_GenkaModel Pmodel)
{
BaseDL bdl = new BaseDL();
Pmodel.Sqlprms = new SqlParameter[9];
Pmodel.Sqlprms[0] = new SqlParameter("@ModelYear", SqlDbType.VarChar)
{
Value = (object)Pmodel.ModelYear ?? DBNull.Value
};
Pmodel.Sqlprms[1] = new SqlParameter("@BrandCD", SqlDbType.VarChar)
{
Value = (object)Pmodel.BrandCD ?? DBNull.Value
};
Pmodel.Sqlprms[2] = new SqlParameter("@BrandName", SqlDbType.VarChar)
{
Value = (object)Pmodel.BrandName ?? DBNull.Value
};
Pmodel.Sqlprms[3] = new SqlParameter("@Season", SqlDbType.VarChar)
{
Value = (object)Pmodel.Season ?? DBNull.Value
};
Pmodel.Sqlprms[4] = new SqlParameter("@targetyear", SqlDbType.VarChar)
{
Value = (object)Pmodel.TargetYear ?? DBNull.Value
};
Pmodel.Sqlprms[5] = new SqlParameter("@ProjectCD", SqlDbType.VarChar)
{
Value = (object)Pmodel.ProjectCD ?? DBNull.Value
};
Pmodel.Sqlprms[6] = new SqlParameter("@ProjectName", SqlDbType.VarChar)
{
Value = (object)Pmodel.ProjectName ?? DBNull.Value
};
Pmodel.Sqlprms[7] = new SqlParameter("@DeliveryStatus", SqlDbType.VarChar)
{
Value = (object)Pmodel.DeliveryStatus ?? DBNull.Value
};
Pmodel.Sqlprms[8] = new SqlParameter("@LoginID", SqlDbType.VarChar)
{
Value = (object)Pmodel.LoginID ?? DBNull.Value
};
//Pmodel.Sqlprms[6] = new SqlParameter("@FiscalYYYYMM", SqlDbType.Int) { Value = (object)Pmodel.Year ?? DBNull.Value };
return(bdl.SelectJson("Print_GenkaCSV", Pmodel.Sqlprms));
}
public string M_Contrl_Year_ExitCheck([FromBody] Print_GenkaModel pgmodel) // for 対象年度
{
return(pgbl.M_Contrl_Year_ExitCheck(pgmodel));
}
public string Print_Genka_ProjectData([FromBody] Print_GenkaModel pmodel)
{
return(pgbl.Print_Genka_ProjectData(pmodel));
}
public string Print_GenkaCSV([FromBody] Print_GenkaModel pgmodel)
{
return(pgbl.Print_GenkaCSV(pgmodel));
}
public string M_Project_ExistsCheck([FromBody] Print_GenkaModel pgmodel)
{
return(pgbl.M_Project_ExistsCheck(pgmodel));
}
