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