public ActionResult MasterTouroku_MaterialsEntry(MasterTouroku_MaterialsModel mmodel)
{
if (string.IsNullOrWhiteSpace(mmodel.Mode))
{
mmodel.Mode = "New";
}
return(View(mmodel));
}
public string MT_Materials_SelectByMaterialsCD(MasterTouroku_MaterialsModel mmodel)
{
BaseDL bdl = new BaseDL();
mmodel.Sqlprms = new SqlParameter[1];
mmodel.Sqlprms[0] = new SqlParameter("@MaterialsCD", SqlDbType.VarChar)
{
Value = (object)mmodel.MaterialsCD ?? DBNull.Value
};
return(bdl.SelectJson("MT_Materials_SelectByMaterialsCD", mmodel.Sqlprms));
}
public string MT_Materials_IUD(MasterTouroku_MaterialsModel mmodel)
{
BaseDL bdl = new BaseDL();
mmodel.Sqlprms = new SqlParameter[4];
mmodel.Sqlprms[0] = new SqlParameter("@MaterialsCD", SqlDbType.VarChar)
{
Value = (object)mmodel.MaterialsCD ?? DBNull.Value
};
mmodel.Sqlprms[1] = new SqlParameter("@MaterialsName", SqlDbType.VarChar)
{
Value = (object)mmodel.MaterialsName ?? DBNull.Value
};
mmodel.Sqlprms[2] = new SqlParameter("@UnitPrice", SqlDbType.VarChar)
{
Value = (object)mmodel.UnitPrice ?? DBNull.Value
};
mmodel.Sqlprms[3] = new SqlParameter("@Mode", SqlDbType.VarChar)
{
Value = (object)mmodel.Mode ?? DBNull.Value
};
return(bdl.SelectJson("MT_Materials_IUD", mmodel.Sqlprms));
}
public string MT_Materials_IUD([FromBody] MasterTouroku_MaterialsModel mmodel)
{
MasterTouroku_Materials_BL rbl = new MasterTouroku_Materials_BL();
return(rbl.MT_Materials_IUD(mmodel));
}
