public string D_StockData_IUD(Touroku_NyuukaModel tnmodel)
{
BaseDL bdl = new BaseDL();
tnmodel.Sqlprms = new SqlParameter[6];
tnmodel.Sqlprms[0] = new SqlParameter("@SEQ", SqlDbType.VarChar)
{
Value = (object)tnmodel.SEQ ?? DBNull.Value
};
tnmodel.Sqlprms[1] = new SqlParameter("@MaterialsCD", SqlDbType.VarChar)
{
Value = (object)tnmodel.MaterialsCD ?? DBNull.Value
};
tnmodel.Sqlprms[2] = new SqlParameter("@StockDate", SqlDbType.VarChar)
{
Value = (object)tnmodel.StockDate ?? DBNull.Value
};
tnmodel.Sqlprms[3] = new SqlParameter("@StockAmount", SqlDbType.VarChar)
{
Value = (object)tnmodel.StockAmount ?? DBNull.Value
};
tnmodel.Sqlprms[4] = new SqlParameter("@Remarks", SqlDbType.VarChar)
{
Value = (object)tnmodel.Remarks ?? DBNull.Value
};
tnmodel.Sqlprms[5] = new SqlParameter("@Mode", SqlDbType.VarChar)
{
Value = (object)tnmodel.Mode ?? DBNull.Value
};
return(bdl.SelectJson("D_StockData_IUD", tnmodel.Sqlprms));
}
public ActionResult Touroku_NyuukaEntry(Touroku_NyuukaModel tnmodel)
{
if (string.IsNullOrWhiteSpace(tnmodel.Mode))
{
tnmodel.Mode = "New";
}
return(View(tnmodel));
}
public ActionResult Touroku_NyuukaList(Touroku_NyuukaModel tnmodel)
{
if (tnmodel.Mode == "Edit" || tnmodel.Mode == "Delete" || tnmodel.status == "5")
{
tnmodel.newmodelstatus = "sts";
}
return(View(tnmodel));
}
public string D_StockData_SelectBySEQ(Touroku_NyuukaModel tnmodel)
{
BaseDL bdl = new BaseDL();
tnmodel.Sqlprms = new SqlParameter[1];
tnmodel.Sqlprms[0] = new SqlParameter("@SEQ", SqlDbType.VarChar)
{
Value = (object)tnmodel.SEQ ?? DBNull.Value
};
return(bdl.SelectJson("D_StockData_SelectBySEQ", tnmodel.Sqlprms));
}
public string MT_Materials_SelectByMaterialsCD(Touroku_NyuukaModel tnmodel)
{
BaseDL bdl = new BaseDL();
tnmodel.Sqlprms = new SqlParameter[1];
tnmodel.Sqlprms[0] = new SqlParameter("@MaterialsCD", SqlDbType.VarChar)
{
Value = (object)tnmodel.MaterialsCD ?? DBNull.Value
};
return(bdl.SelectJson("MT_Materials_SelectByMaterialsCD", tnmodel.Sqlprms));
}
public string D_StockData_Search(Touroku_NyuukaModel tnmodel)
{
BaseDL bdl = new BaseDL();
if (tnmodel.status.Equals("5"))
{
tnmodel.Sqlprms = new SqlParameter[2];
tnmodel.Sqlprms[0] = new SqlParameter("@status", SqlDbType.Int)
{
Value = (object)tnmodel.status ?? DBNull.Value
};
tnmodel.Sqlprms[1] = new SqlParameter("@UserID", SqlDbType.VarChar)
{
Value = (object)tnmodel.LoginID ?? DBNull.Value
};
return(bdl.SelectJson("Data_Show_List", tnmodel.Sqlprms));
}
tnmodel.Sqlprms = new SqlParameter[5];
tnmodel.Sqlprms[0] = new SqlParameter("@MaterialsCD", SqlDbType.VarChar)
{
Value = (object)tnmodel.MaterialsCD ?? DBNull.Value
};
tnmodel.Sqlprms[1] = new SqlParameter("@MaterialsName", SqlDbType.VarChar)
{
Value = (object)tnmodel.MaterialsName ?? DBNull.Value
};
tnmodel.Sqlprms[2] = new SqlParameter("@Stock_sDate", SqlDbType.VarChar)
{
Value = (object)tnmodel.Stock_sDate ?? DBNull.Value
};
tnmodel.Sqlprms[3] = new SqlParameter("@Stock_eDate", SqlDbType.VarChar)
{
Value = (object)tnmodel.Stock_eDate ?? DBNull.Value
};
tnmodel.Sqlprms[4] = new SqlParameter("@UserID", SqlDbType.VarChar)
{
Value = (object)tnmodel.LoginID ?? DBNull.Value
};
return(bdl.SelectJson("D_Stock_History_Select", tnmodel.Sqlprms));
}
public string D_StockData_StockDateCheck([FromBody] Touroku_NyuukaModel tnmodel)
{
Touroku_Nyuuka_BL rbl = new Touroku_Nyuuka_BL();
return(rbl.D_StockData_StockDateCheck(tnmodel));
}
public string MT_Materials_SelectByMaterialsCD([FromBody] Touroku_NyuukaModel tnmodel)
{
Touroku_Nyuuka_BL rbl = new Touroku_Nyuuka_BL();
return(rbl.MT_Materials_SelectByMaterialsCD(tnmodel));
}
public string D_StockData_Search([FromBody] Touroku_NyuukaModel tnmodel)
{
Touroku_Nyuuka_BL tnbl = new Touroku_Nyuuka_BL();
return(tnbl.D_StockData_Search(tnmodel));
}