コード例 #1
0
        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));
        }
コード例 #2
0
 public ActionResult Touroku_NyuukaEntry(Touroku_NyuukaModel tnmodel)
 {
     if (string.IsNullOrWhiteSpace(tnmodel.Mode))
     {
         tnmodel.Mode = "New";
     }
     return(View(tnmodel));
 }
コード例 #3
0
 public ActionResult Touroku_NyuukaList(Touroku_NyuukaModel tnmodel)
 {
     if (tnmodel.Mode == "Edit" || tnmodel.Mode == "Delete" || tnmodel.status == "5")
     {
         tnmodel.newmodelstatus = "sts";
     }
     return(View(tnmodel));
 }
コード例 #4
0
        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));
        }
コード例 #5
0
        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));
        }
コード例 #6
0
        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));
        }
コード例 #7
0
        public string D_StockData_StockDateCheck([FromBody] Touroku_NyuukaModel tnmodel)
        {
            Touroku_Nyuuka_BL rbl = new Touroku_Nyuuka_BL();

            return(rbl.D_StockData_StockDateCheck(tnmodel));
        }
コード例 #8
0
        public string MT_Materials_SelectByMaterialsCD([FromBody] Touroku_NyuukaModel tnmodel)
        {
            Touroku_Nyuuka_BL rbl = new Touroku_Nyuuka_BL();

            return(rbl.MT_Materials_SelectByMaterialsCD(tnmodel));
        }
コード例 #9
0
        public string D_StockData_Search([FromBody] Touroku_NyuukaModel tnmodel)
        {
            Touroku_Nyuuka_BL tnbl = new Touroku_Nyuuka_BL();

            return(tnbl.D_StockData_Search(tnmodel));
        }