コード例 #1
0
        public static Boolean SOMS_RefreshedDeliverySchedule(IDeliverySchedule _schedule)
        {
            SqlCommand cmd = new SqlCommand("SOMS_RefreshedDeliverySchedule");

            cmd.CommandType = CommandType.StoredProcedure;

            cmd.Parameters.AddWithValue("@PartID", _schedule.PartID);

            SqlHelper.ExecuteNonQuery(ClsConfig.SqlConnectionString, cmd);

            return(true);
        }
コード例 #2
0
        public static Boolean RefreshedDeliveryScheduleByYear(IDeliverySchedule _schedule)
        {
            SqlCommand cmd = new SqlCommand("RefreshedDeliveryScheduleByYear");

            cmd.CommandType = CommandType.StoredProcedure;

            cmd.Parameters.AddWithValue("@PartID", _schedule.PartID);

            //cmd.Parameters.AddWithValue("@month", _schedule.DateMonth);

            cmd.Parameters.AddWithValue("@year", _schedule.DateYear);

            SqlHelper.ExecuteNonQuery(ClsConfig.SqlConnectionString, cmd);

            return(true);
        }